[Bug]: error "InvalidArgumentException: Index name "photo_id" for table" during update from 28.0.12.2 to 29.0.9 #49170
Labels
Comments
jdgit4home
added
0. Needs triage
Maybe it was once in place and uninstalled long ago? You can likely drop the two referenced tables (after doing a database backup). For help doing that, please utilize the help forum: https://help.nextcloud.com P.S. Basically this, but for those tables is what you need to do: #41253 (comment) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Bug description
I did an update via web from 28.0.12.2 to 29.0.9 which aborts with the following error (end of logfile)
....
"weather_status" aktualisiert auf 1.9.0
Aktualisiere die App "contacts" aus dem App-Store
InvalidArgumentException: Index name "photo_id" for table "oc_facefinder_facedetaction_face_photo_module" collides with the constraint on table "oc_facefinder_exif_photo_module".
nextcloud is now inoperabel (when I do a web login with admin I get "Aktualisierung starten".
what should I do to get it running again e.g. with version 28.0.12.2.
The update process does automatically an udate to .../data/updater-oce530a2e556/ . Does it help to get back to 28.0.12.2 ?
Steps to reproduce
Expected behavior
successfull update
Nextcloud Server version
28
Operating system
Debian/Ubuntu
PHP engine version
PHP 8.3
Web server
Apache (supported)
Database engine version
MySQL
Is this bug present after an update or on a fresh install?
Upgraded to a MAJOR version (ex. 28 to 29)
Are you using the Nextcloud Server Encryption module?
None
What user-backends are you using?
Configuration report
{ "system": { "instanceid": "***REMOVED SENSITIVE VALUE***", "passwordsalt": "***REMOVED SENSITIVE VALUE***", "datadirectory": "***REMOVED SENSITIVE VALUE***", "dbtype": "mysql", "version": "28.0.12.2", "dbname": "***REMOVED SENSITIVE VALUE***", "dbhost": "***REMOVED SENSITIVE VALUE***", "dbtableprefix": "oc_", "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "installed": true, "theme": "", "maintenance": false, "loglevel": 2, "trusted_domains": [ "cl.fodefip.at" ], "secret": "***REMOVED SENSITIVE VALUE***", "share_folder": "\/Shared", "trashbin_retention_obligation": "auto", "updater.release.channel": "stable", "overwrite.cli.url": "https:\/\/cl.fodefip.at", "app_install_overwrite": [ "calendar", "occweb" ], "encryption.legacy_format_support": false, "encryption.key_storage_migrated": false, "mysql.utf8mb4": true, "default_phone_region": "AT", "mail_domain": "***REMOVED SENSITIVE VALUE***", "mail_from_address": "***REMOVED SENSITIVE VALUE***", "mail_smtpmode": "sendmail", "mail_smtphost": "***REMOVED SENSITIVE VALUE***", "mail_sendmailmode": "smtp", "mail_smtpport": "25", "maintenance_window_start": 1, "updater.secret": "***REMOVED SENSITIVE VALUE***" } }List of activated Apps
Nextcloud Signing status
Nextcloud wird auf Version 29.0.9 aktualisiert Stellen Sie vor dem Fortsetzen bitte sicher, dass die Datenbank, der Konfigurationsordner und der Datenordner gesichert wurden. Zur Vermeidung von Zeitüberschreitungen bei größeren Installationen können Sie stattdessen den folgenden Befehl in Ihrem Installationsverzeichnis ausführen: ./occ upgradeNextcloud Logs
Additional info
No response
The text was updated successfully, but these errors were encountered: