netbox-community / netbox-floorplan-plugin

NetBox Floorplan plugin
GNU Lesser General Public License v3.0
54 stars 14 forks source link

Database relation missing #10

Closed brosky closed 6 months ago

brosky commented 6 months ago

Hi,

So I followed the docs:

source /opt/netbox/venv/bin/activate pip3.8 delete netbox-floorplan-plugin

added to plugins

systemctl restart netbox

and then when I go to the menu I have:

`Server Error A database programming error was detected while processing this request. Common causes include the following:

Database migrations missing. When upgrading to a new NetBox release, the upgrade script must be run to apply any new database migrations. You can run migrations manually by executing python3 manage.py migrate from the command line.

Unsupported PostgreSQL version. Ensure that PostgreSQL version 12 or later is in use. You can check this by connecting to the database using NetBox's credentials and issuing a query for SELECT VERSION().

The complete exception is provided below:

<class 'django.db.utils.ProgrammingError'>

relation "netbox_floorplan_floorplan" does not exist LINE 1: ...unit", "netbox_floorplan_floorplan"."canvas" FROM "netbox_fl... ^

Python version: 3.8.8 NetBox version: 3.7.0 Plugins: netbox_floorplan: 0.3.4 If further assistance is required, please post to the NetBox discussion forum on GitHub.`

brosky commented 6 months ago

solved by running:

 python manage.py migrate
Operations to perform:
  Apply all migrations: account, admin, auth, circuits, contenttypes, core, dcim, django_rq, extras, ipam, netbox_floorplan, sessions, social_django, taggit, tenancy, users, virtualization, vpn, wireless
Running migrations:
  Applying netbox_floorplan.0001_initial... OK
  Applying netbox_floorplan.0002_floorplan_measurement_unit_alter_floorplan_scale... OK
  Applying netbox_floorplan.0003_floorplan_canvas... OK
  Applying netbox_floorplan.0004_alter_floorplan_options... OK
  Applying netbox_floorplan.0005_alter_floorplan_site... OK
  Applying netbox_floorplan.0006_delete_floorplanobject... OK
  Applying netbox_floorplan.0007_alter_floorplan_options_and_more... OK

The documentation should be upgraded.