Mysql error - null in ports_stp table

Help
1

Hello,

in librenms.log we have error like this:
MySQL Error: Incorrect integer value: ‘’ for column ‘port_id’ at row 1 (UPDATE ports_stp set priority =‘128’,state =‘forwarding’,enable =‘enabled’,pathCost =‘20000’,designatedCost =‘20000’,designatedPort =‘6’,forwardTransitions =‘5’,device_id =‘3’,port_id =’’,designatedRoot =‘000c30d0dd00’,designatedBridge =‘001b8f7f4700’ WHERE device_id = ‘3’ AND port_id = ‘’)

port_id in update is NULL where in DB schema is mark as NOT NULL: port_id int(11) NOT NULL.

https://p.libren.ms/view/4fc9eaca
https://p.libren.ms/view/4f0ccd6e#L1978

2

3 posts were merged into an existing topic: Report database schema issues here