Database error

[crossbuilder]

A few months ago, I installed Dashboard app using the web interface, i.e. from the nextcloud store. I disabled and removed it, because it was not usable back then.

Now when installing/enabling Dashboard app, I get the following error message:

An exception occurred while executing 'INSERT INTO "oc_dashboard_settings"("id","key","value") VALUES(?,?,?)' with params [1, "show_activity", 1]: SQLSTATE[23505]: Unique violation: 7 ERROR: duplicate key value violates unique constraint "oc_dashboard_settings_pkey" DETAIL: Key (id)=(1) already exists.

Please note: I never cloned/downloaded anything manually. All installing/enabling/removing was done using the "Apps" section of the web interface.

[tuxedo-rb]

Hello,

please disable and enable the Dashboard-App once again to remove all old remaining database entries relating to dashboard. There didn't exist any functionality to clean up the database after uninstall in previous versions. Version 5.0.0 added such a feature.

[crossbuilder]

Unfortunately, I can't disable it because I can't enable it at all.

[tuxedo-rb]

Oh, i get it. Then clear table [prefix_]dashboard_settings manually from your nextcloud database. Connect to your nextcloud database and run following sql-query:

TRUNCATE TABLE `oc_dashboard_settings`;