search

den-it / ntmap

Network topology map using Netbox as a data source
MIT License
146 stars 14 forks source link

MAP Failure: column i._cable_peer_id does not exist LINE 27: ON #14

Closed LHBL2003 closed 2 years ago

LHBL2003 commented 2 years ago

NTMAP v0.7.1 NETBOX v3.2.2 Python 3.10.4 PostgreSQL 14.2 Ubuntu 14.2

No matter which device I write into the Shema, I always get this error message. Even if I enter a switch and a server that are connected, I get this error message.

column i._cable_peer_id does not exist LINE 27: ON (ni.id = i._cable_peer_id... ^

2022-05-19_10h41_41 image
LHBL2003 commented 2 years ago

Due to error column "_cable_peer_id" is not present by name in the dcim_interface.

image
LHBL2003 commented 2 years ago

Two columns were renamed. (21 Oct 2021)

https://github.com/netbox-community/netbox/blob/f94c1e91ea20c805528125407193371476ccbcd8/netbox/circuits/migrations/0004_rename_cable_peer.py

_cable_peer_id --> _link_peer_id _cable_peer_type --> _link_peer_type

And this must also be adapted

_cable_peer_type_id --> _link_peer_type_id

Then it also works in the current version

image
den-it commented 2 years ago

Fixed in v0.8.0