Hacktoberfest 2026: the issues maintainers tagged for October, open and beginner-friendly. Browse Hacktoberfest issues

After upgrading Nextcloud from 34.0.5 to 35.0.2 database corrupt.

Open
  • Is something wrong?
#5,091 3 comments 0 reactions 0 assignees View on GitHub

Maintainers usually reply within 1 day

Nobody has claimed this yet.

Assessment

Difficulty
4/5
Estimated time
3-5 days
Newbie friendliness
22/100
Issue type
Bug
Clarity
Needs clarification
Activity status
Active
Tech stack
php, postgresql
Domain
database

Research direction

Start from the occ db:schema:check -v output in the issue, which lists unexpected indexes and a column type mismatch across the oc_polls_* tables and a few core tables such as oc_filecache. Reproducing it needs a PostgreSQL 15 instance upgraded from Nextcloud 34 to 35 with polls 9.3.0. The issue does not say whether the fix belongs in polls migrations or in Nextcloud core, and the reporter was sent here by Nextcloud support, so confirm that first. Done means the schema check passes on PostgreSQL 15.

Written by the indexing model from the issue text.

Description

needs approval
⚠️ This issue respects the following points: ⚠️
  • This is a bug, not a question or a configuration/webserver/proxy issue.
  • This issue is not already reported on Github (I've searched it).
  • I agree to follow Nextcloud's Code of Conduct.
What went wrong, what did you observe?

After upgrading NextCloud 34 to 35, I have database errors about oc_polls*

NextCloud support ask to open a issue.

https://github.com/nextcloud/server/issues/64505#issuecomment-6212538134

The database schema does not match what is expected for the installed version:
  - oc_filecache: unexpected index 'fs_storage_path_prefix'
  - oc_appointments_hash: column 'appt_doc' differs in: type
  - oc_federated_invites: unexpected index 'fed_inv_open_email_uniq'
  - oc_share_external: column 'id' differs in: autoincrement
  - oc_polls_groups_polls: unexpected index 'idx_99598f933c947c0f'
  - oc_polls_groups_polls: unexpected index 'idx_99598f93fe54d947'
  - oc_polls_groups_polls: unexpected index 'polls_groups_polls'
  - oc_polls_groups_polls: unexpected index 'uniq_poll_group_relation'
  - oc_polls_options: unexpected index 'idx_9aa5663c947c0f'
  - oc_polls_options: unexpected index 'polls_options'
  - oc_polls_options: unexpected index 'uniq_9aa5663c947c0fbd4bf59a5d6e63e'
  - oc_polls_options: unexpected index 'uniq_options'
  - oc_polls_votes: unexpected index 'idx_a20806f93c947c0f'
  - oc_polls_votes: unexpected index 'uniq_a20806f93c947c0fa76ed3958a3bfe0f'
  - oc_polls_votes: unexpected index 'uniq_votes'
  - oc_polls_comments: unexpected index 'idx_8843eb9b3c947c0f'
  - oc_polls_share: unexpected index 'idx_1c85e16c3c947c0f'
  - oc_polls_share: unexpected index 'uniq_1c85e16c3c947c0ffe54d947a76ed395'
  - oc_polls_share: unexpected index 'uniq_shares'
  - oc_polls_share: unexpected index 'uniq_token'
  - oc_polls_notif: unexpected index 'idx_33f0715d3c947c0f'
  - oc_polls_notif: unexpected index 'uniq_subscription'
  - oc_polls_log: unexpected index 'idx_3710b4a43c947c0f'
  - oc_polls_log: unexpected index 'uniq_unprocessed'
  - oc_polls_watch: unexpected index 'idx_a38836103c947c0f'
  - oc_polls_watch: unexpected index 'uniq_a38836103c947c0ff6298f46613fecdf'
  - oc_polls_watch: unexpected index 'uniq_watch'
  - oc_polls_preferences: unexpected index 'uniq_preferences'
  - oc_text_steps: unexpected index 'text_steps_doc_id_id_index'
Run "occ db:schema:check -v" for details.
What did you expect, how polls should behave instead?

No database errors

What steps does it need to replay this bug?
Affected polls version

polls: 9.3.0

Installation method

Installed/updated from the appstore (Apps section of your site)

Installation type

First time installation

Can you rule out that any extension you use is involved in the issue?
  • I have checked all browser extension
Which browser did you use, when experiencing the bug?
  • Firefox
  • Chrome
  • Chromium/Chromium based (i.e. Edge)
  • Safari
  • Other/Don't know
Other browser

No response

Add your browser log here
Additional client environment information

No response

NC version

Other/Don't know

Other Nextcloud version

nextcloud 35

PHP engine version

PHP 8.4

Other PHP version

No response

Database engine

PostgreSQL

Database Engine version or other Database

postgreSQL 15

Which user-backends are you using?
  • Default user-backend (database)
  • LDAP/ Active Directory
  • SSO - SAML
  • Other/Don't know
Add your nextcloud server log here
Additional environment informations

No response

Configuration report
List of activated Apps
Nextcloud Signing status
Additional Information

No response

Dominant language
JavaScript
Stars
285
Forks
91
Avg merge
3d 5h
Merged PRs (30d)
47

Getting set up

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from nextcloud/polls

All issues in nextcloud/polls

Similar issues

More JavaScript issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.