search

syncloud / platform

Run popular services on your device with one click
https://syncloud.org
GNU General Public License v3.0
400 stars 40 forks source link

Nextcloud Dashboard install error #358

Closed marxistvegan closed 5 years ago

marxistvegan commented 5 years ago

Hey all, Nextcloud is running well, but i am not able to add the Dashboard app, i get this error

An error occured during the request. Unable to proceed.
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.

Which makes it seem I had it installed but I am not sure how to resolve it.

cyberb commented 5 years ago

I guess you need to contact dashboard app devs with this question first.

marxistvegan commented 5 years ago

I see an approach to solving this, https://github.com/nextcloud/dashboard/issues/40, but I am not sure how to access the nextcloud database.

cyberb commented 5 years ago

You can enter the database shell using the following command:

/snap/nextcloud/current/postgresql/bin/psql -U nextcloud -h /var/snap/nextcloud/common/database -p 5436
cyberb commented 5 years ago

Then you can execute their truncate command

marxistvegan commented 5 years ago

OK the truncate command worked, but another issue arose, I am going to close this as it does appear to be an issue upstream.