search

den-it / ntmap

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

column d.device_role_id does not exist LINE 17 #22

Open Honie123 opened 8 months ago

Honie123 commented 8 months ago

Maybe this is a bug with latest version of ntmap working with netbox latest version v3.7.1:

All created maps fail with following error.

column d.device_role_id does not exist LINE 17: ON d.device_role_id = r.id ^ HINT: Perhaps you meant to reference the column "d.device_type_id".

Please help! Many thanks Error

milevskiy2 commented 5 months ago

Help

mfoleyfh commented 5 months ago

I found a workaround by editing /opt/ntmap/backend/wsgi.py. Do a search for d.device_role_id and change the line to d.role_id. The full line should look like this: ON d.role_id = r.id After the change, restart the service with "systemctl restart ntmap" and reload the page.

The value in the Netbox database use to be device_role and was changed to just role.