Error when deleting items #9716

Closed
opened 2025-12-29 21:21:32 +01:00 by adam · 1 comment
Owner

Originally created by @deanfourie1 on GitHub (May 22, 2024).

Deployment Type

Self-hosted

NetBox Version

v4.0.2

Python Version

3.11

Steps to Reproduce

Attempt to delete a device in the "Devices" section.

Expected Behavior

The device to be deleted.

Observed Behavior

Fails to deleted, screenshot provided.

image

Originally created by @deanfourie1 on GitHub (May 22, 2024). ### Deployment Type Self-hosted ### NetBox Version v4.0.2 ### Python Version 3.11 ### Steps to Reproduce Attempt to delete a device in the "Devices" section. ### Expected Behavior The device to be deleted. ### Observed Behavior Fails to deleted, screenshot provided. ![image](https://github.com/netbox-community/netbox/assets/71812804/f3f24f66-78e7-4f59-b157-fe958cd8073f)
adam closed this issue 2025-12-29 21:21:32 +01:00
Author
Owner

@deanfourie1 commented on GitHub (May 22, 2024):

Can see that tables listed here, however I cant seem to delete the,

netbox=> \dt netbox_topology_views_*
                                  List of relations
 Schema |                            Name                            | Type  | Owner  
--------+------------------------------------------------------------+-------+--------
 public | netbox_topology_views_circuitcoordinate                    | table | netbox
 public | netbox_topology_views_coordinate                           | table | netbox
 public | netbox_topology_views_coordinategroup                      | table | netbox
 public | netbox_topology_views_individualoptions                    | table | netbox
 public | netbox_topology_views_individualoptions_preselected_device | table | netbox
 public | netbox_topology_views_individualoptions_preselected_tag    | table | netbox
 public | netbox_topology_views_powerfeedcoordinate                  | table | netbox
 public | netbox_topology_views_powerpanelcoordinate                 | table | netbox
 public | netbox_topology_views_roleimage                            | table | netbox
(9 rows)
netbox-> DROP TABLE netbox_topology_views_roleimage;
DROP TABLE
ERROR:  syntax error at or near "TABLE"
LINE 2: DROP TABLE netbox_topology_views_roleimage;
             ^
netbox-> 
@deanfourie1 commented on GitHub (May 22, 2024): Can see that tables listed here, however I cant seem to delete the, ``` netbox=> \dt netbox_topology_views_* List of relations Schema | Name | Type | Owner --------+------------------------------------------------------------+-------+-------- public | netbox_topology_views_circuitcoordinate | table | netbox public | netbox_topology_views_coordinate | table | netbox public | netbox_topology_views_coordinategroup | table | netbox public | netbox_topology_views_individualoptions | table | netbox public | netbox_topology_views_individualoptions_preselected_device | table | netbox public | netbox_topology_views_individualoptions_preselected_tag | table | netbox public | netbox_topology_views_powerfeedcoordinate | table | netbox public | netbox_topology_views_powerpanelcoordinate | table | netbox public | netbox_topology_views_roleimage | table | netbox (9 rows) ``` ``` netbox-> DROP TABLE netbox_topology_views_roleimage; DROP TABLE ERROR: syntax error at or near "TABLE" LINE 2: DROP TABLE netbox_topology_views_roleimage; ^ netbox-> ```
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/netbox#9716