Nextcloud Dashboard install error

[marxistvegan]

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]

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

[marxistvegan]

I see an approach to solving this, nextcloud/dashboard#40, but I am not sure how to access the nextcloud database.

[cyberb]

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]

Then you can execute their truncate command

[marxistvegan]

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