Polls app update causing error

[apesorguk]

We have 2 nextcloud servers, one updated fine and one runs into this error we can not get rind of when the polls app is updated.

[apesorguk]

I have tried to delete and delete data on remove, but when trying to install I get this An error occurred during the request.

Unable to proceed.
Database error when running migration 090000Date20260302212000 for app polls An exception occurred while executing a query: SQLSTATE[42P07]: Duplicate table: 7 ERROR: relation "uniq_watch" already exists

[james]

Hello @apesorguk
Sorry to read that you are having issues.
Neither Nextcloud nor Cloudron can provide a full coverage of every app available for Nextcloud for each update.
This issue was also already reported upstream for the polls app https://github.com/nextcloud/polls/issues/4619

Maybe you can try to disable the poll app with the following docs: https://docs.cloudron.io/packages/nextcloud#fixing-a-broken-install

or you try the suggested fix from the issue:

Quote:

To fix it I ran against the database:

DROP INDEX uniq_shares;
DROP INDEX uniq_token;
DROP INDEX uniq_subscription;
DROP INDEX uniq_unprocessed;
DROP INDEX uniq_watch;
DROP INDEX uniq_preferences;

[sponch]

Be careful with the Polls app. I’ve stopped using it because it bricked several Nextcloud instances for me multiple times.

[apesorguk]

@james said:

Hello @apesorguk
Sorry to read that you are having issues.
Neither Nextcloud nor Cloudron can provide a full coverage of every app available for Nextcloud for each update.
This issue was also already reported upstream for the polls app https://github.com/nextcloud/polls/issues/4619

Maybe you can try to disable the poll app with the following docs: https://docs.cloudron.io/packages/nextcloud#fixing-a-broken-install

or you try the suggested fix from the issue:

Quote:

To fix it I ran against the database:

DROP INDEX uniq_shares;
DROP INDEX uniq_token;
DROP INDEX uniq_subscription;
DROP INDEX uniq_unprocessed;
DROP INDEX uniq_watch;
DROP INDEX uniq_preferences;

Thank you. Worked a treat.

@sponch said:

Be careful with the Polls app. I’ve stopped using it because it bricked several Nextcloud instances for me multiple times.

We have gotten to the position of when ever we update apps now we also backup before hand sure to avoid issues with some app updates breaking the server.

[james]

Hello @apesorguk
That is a good idea.
Nextcloud apps are a notorious offender in breaking Nextcloud setups.

[apesorguk]

@james said:

Hello @apesorguk
That is a good idea.
Nextcloud apps are a notorious offender in breaking Nextcloud setups.

Totally agree, we have said to nextcloud that they should not release updates and apps until tested with all other apps. They need to get rid of untested apps as well.