Error when updating to 30.0.2: Foreign key constraint is incorrectly formed #3778
Comments
|
have you tried |
|
@dartcafe Yes, I tried that, but with no results. The error still exists. |
|
That makes no sense. Either the error message is misleading or something else exists inside the database, preventing the action. Is there any stack trace of the error? What confuses me, is that the creation of the comments table is reported to be failing. This leads to the conclusion, that it does not exist. An export of the table definitions could help. |
This comment has been minimized.
This comment has been minimized.
|
There is no hint inside the table structure, which may help to analyze the error. I need more details about the error line, to get an idea, what is wrong. It seems the error does not describe a failure on creating the table but attaching the fk. There should be more information within the printed error which names the failing fk structure. |
|
OK, now I got an error, when I try to use |
|
I have no idea, what resides inside your database, but these error messages still make no sense to me, since this seems no wide spread problem. Please try to wipe all polls related tables and information (you can do this with I recommend the following steps:
|
What went wrong, what did you observe?
When I updated to NC 30.0.2, I got a problem updating polls.
nextcloud.oc_polls_comments(errno: 150 "Foreign key constraint is incorrectly formed")I first tried to disable polls, delete the tables oc_polls_*, restore them from backup an re-enabled polls, but the problem persists.
What did you expect, how polls should behave instead?
No error message when the upgrade-command is executed
What steps does it need to replay this bug?
Installation method
Installed/updated from the appstore (Apps section of your site)
Installation type
Updated from previous major version (i.e. 3.x.x to 4.x.x)
Affected polls version
7.2.4
Which browser did you use, when experiencing the bug?
Other browser
No response
Add your browser log here
Additional client environment information
No response
NC version
Nextcloud 30
Other Nextcloud version
No response
PHP engine version
PHP 8.3
Other PHP version
No response
Database engine
MariaDB
Database Engine version or other Database
10.5.8
Which user-backends are you using?
Add your nextcloud server log here
no logs for polls foundAdditional environment informations
No response
Configuration report
{ "system": { "instanceid": "***REMOVED SENSITIVE VALUE***", "passwordsalt": "***REMOVED SENSITIVE VALUE***", "secret": "***REMOVED SENSITIVE VALUE***", "trusted_domains": [ "cloud.alpenverein-hannover.de" ], "datadirectory": "***REMOVED SENSITIVE VALUE***", "dbtype": "mysql", "version": "30.0.2.2", "dbname": "***REMOVED SENSITIVE VALUE***", "dbhost": "***REMOVED SENSITIVE VALUE***", "dbport": "", "dbtableprefix": "oc_", "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "default_language": "de", "default_locale": "de_DE", "installed": true, "remember_login_cookie_lifetime": 1296000, "session_lifetime": 86400, "session_keepalive": true, "skeletondirectory": "", "knowledgebaseenabled": false, "lost_password_link": "disabled", "ldapIgnoreNamingRules": false, "ldapProviderFactory": "\\OCA\\User_LDAP\\LDAPProviderFactory", "mail_from_address": "***REMOVED SENSITIVE VALUE***", "mail_smtpmode": "smtp", "mail_smtpauthtype": "LOGIN", "mail_domain": "***REMOVED SENSITIVE VALUE***", "auth.bruteforce.protection.enabled": true, "maintenance": false, "updater.release.channel": "stable", "maintenance_window_start": 1, "theme": "", "loglevel": 2, "forcessl": true, "forceSSLforSubdomains": true, "trashbin_retention_obligation": "7, 20", "has_internet_connection": true, "check_for_working_webdav": true, "check_for_working_wellknown_setup": true, "check_for_working_htaccess": true, "cron_log": true, "logtimezone": "Europe\/Berlin", "logdateformat": "F d, Y H:i:s", "ldapUserCleanupInterval": 51, "filelocking.enabled": "true", "mail_smtpsecure": "ssl", "mail_smtpauth": 1, "mail_smtphost": "***REMOVED SENSITIVE VALUE***", "mail_smtpport": "465", "mail_smtpname": "***REMOVED SENSITIVE VALUE***", "mail_smtppassword": "***REMOVED SENSITIVE VALUE***", "overwrite.cli.url": "https:\/\/cloud.alpenverein-hannover.de", "share_folder": "\/Mit mir geteilt", "app_install_overwrite": [ "calendar", "circles", "groupfolders", "ocr", "impersonate", "bruteforcesettings", "twofactor_gateway", "issuetemplate", "checksum_api" ], "twofactor_enforced": "true", "twofactor_enforced_groups": [ "AdminUser2F" ], "twofactor_enforced_excluded_groups": [], "mysql.utf8mb4": true, "default_phone_region": "DE", "memcache.local": "\\OC\\Memcache\\APCu", "memcache.locking": "\\OC\\Memcache\\Redis", "redis": { "host": "***REMOVED SENSITIVE VALUE***", "port": 0, "timeout": 0 }, "preview_max_x": 1024, "preview_max_y": 768, "preview_max_scale_factor": 1, "activity_expire_days": 30, "allow_local_remote_servers": true } }List of activated Apps
Nextcloud Signing status
Additional Information
No response
The text was updated successfully, but these errors were encountered: