The solution at this problem is add the next query to Pandora FMS database:
set @var=if((SELECT true FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA = DATABASE() AND TABLE_NAME = 'twidget_dashboard' AND CONSTRAINT_NAME = 'twidget_dashboard_ibfk_2' AND CONSTRAINT_TYPE = 'FOREIGN KEY') = true, 'ALTER TABLE twidget_dashboard DROP FOREIGN KEY twidget_dashboard_ibfk_2', 'SELECT 0'); prepare stmt from @var; execute stmt; deallocate prepare stmt;
For its execution we could create a .sql
file with the contain added. Supposing that is called query.sql
this will be its execution into the command line:
cat query.sql | mysql -u root -p -D pandora password:
Once applied it, edit and delete of widgets will work correctly.