search

nextcloud / dashboard

ARCHIVED, new Dashboard is in the server
https://nextcloud.com/dashboard
GNU Affero General Public License v3.0
58 stars 29 forks source link

Database error #40

Open crossbuilder opened 6 years ago

crossbuilder commented 6 years ago

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 commented 6 years ago

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 commented 6 years ago

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

tuxedo-rb commented 6 years ago

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`;