Not possible to remove widgets, App not compatible with utf8mb4_unicode_520_ci ?

[Kaennorsing]

No longer possible to remove any widgets...
Possibly more issues that I did not notice yet
Invalid database records seem to remain in the database after uninstallation of the plugin
Is it possible to fix it ?

[index] Error: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'UPDATE oc_dashboard_settings SET enabled = ? WHERE (widget_id = ?) AND (user_id = ?)' with params [false, "fortunes", "someusername"]:

SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column nextcloud.oc_dashboard_settings.enabled at row 1 at <>

/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 128
convertException("An exception oc ... 1", Doctrine\DBAL\Dr ... ]})
/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php line 1015
driverExceptionDuringQuery(Doctrine\DBAL\Driver\PDOMySql\Driver {}, Doctrine\DBAL\Dr ... ]}, "UPDATE `oc_dash ... )", {1: false,2: "fortunes",3: "someusername"})
/var/www/html/nextcloud/lib/private/DB/Connection.php line 216
executeUpdate("UPDATE `oc_dash ... )", [false,"fortunes","someusername"], [2,2,2])
/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php line 208
executeUpdate("UPDATE `oc_dash ... )", {dcValue1: false ... "}, {dcValue1: 2,dcValue2: 2,dcValue3: 2})
/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 214
execute()
/var/www/html/nextcloud/apps/dashboard/lib/Db/SettingsRequest.php line 106
execute()
/var/www/html/nextcloud/apps/dashboard/lib/Service/WidgetsService.php line 124
disableWidget("fortunes", "someusername")
/var/www/html/nextcloud/apps/dashboard/lib/Controller/NavigationController.php line 140
removeWidget("fortunes")
/var/www/html/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 166
deleteWidget("fortunes")
/var/www/html/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 99
executeController(OCA\Dashboard\Co ... {}, "deleteWidget")
/var/www/html/nextcloud/lib/private/AppFramework/App.php line 118
dispatch(OCA\Dashboard\Co ... {}, "deleteWidget")
/var/www/html/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php line 47
main("OCA\Dashboard\ ... r", "deleteWidget", OC\AppFramework\ ... {}, {_route: "dashbo ... "})
<>
__invoke({_route: "dashbo ... "})
/var/www/html/nextcloud/lib/private/Route/Router.php line 297
call_user_func(OC\AppFramework\ ... {}, {_route: "dashbo ... "})
/var/www/html/nextcloud/lib/base.php line 987
match("/apps/dashboard/widget")
/var/www/html/nextcloud/index.php line 42
handleRequest()

DELETE /nextcloud/index.php/apps/dashboard/widget
from removedmyipaddress by someusername at 2019-04-09T20:44:28+02:00

[MarkPartlett]

I had this problem due to MySQL 5.5 , I modified line 102 of /apps/dashboards/lib/Db/SettingsRequest.php to " $qb->set('enabled', $qb->createNamedParameter('0')); " to debug/work-around the issue.