Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Foreign key constraint is incorrectly formed #9106

Closed
loadbrain opened this issue Jun 20, 2023 · 4 comments
Closed

Foreign key constraint is incorrectly formed #9106

loadbrain opened this issue Jun 20, 2023 · 4 comments

Comments

@loadbrain
Copy link

loadbrain commented Jun 20, 2023

Getting SQL Error on upgrading from 3.3.0-14 to 3.4.0.0:
[error while downgrading "APP\migration\upgrade\v3_4_0\I3573_AddPrimaryKeys": SQLSTATE[HY000]: General error: 1025 Error on rename of './db_50_ojs33/#sql-alter-3a1b6e-a4815d' to './db_50_ojs33/review_form_responses' (errno: 150 "Foreign key constraint is incorrectly formed") (SQL: ALTER TABLE review_form_responses CHANGE review_form_response_id review_form_response_id INT UNSIGNED NOT NULL)]
What can I do?
Fixed in 3.4.0.1?

@asmecher
Copy link
Member

@loadbrain, what version of MySQL are you using?

@loadbrain
Copy link
Author

10.10.5-MariaDB-1:10.10.5+maria~deb11

@asmecher
Copy link
Member

asmecher commented Jul 1, 2023

@loadbrain, can you include more of the output of the upgrade process? I think the message you quoted is happening after the message that breaks the upgrade.

@loadbrain
Copy link
Author

I gave up updating.
So many errors...🙄

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants