Home
Knowledge Base
Problems (EN)
After the update from 5.x to 6 some actions on the Dashboard are erratic

After the update from 5.x to 6 some actions on the Dashboard are erratic

An element may not be deleted during the database migration. If this occurs, you will have to execute this statement in MySQL:

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;

Was this article helpful?