column d.device_role_id does not exist LINE 17

[Honie123]

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

[milevskiy2]

Help

[mfoleyfh]

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.

[PeterKnotek]

But now write : column p.asn does not exist LINE 5: p.asn AS asn, ^