Problem when migrating from version 3.2 to 3.4 - SQLSTATE[HY000]: General error: 1824

With a database with version and wanting to migrate to version it shows me an error when trying to add a constraint, the error is the following:

SQLSTATE[HY000]: General error: 1824 Failed to open the referenced table ‘submission_files’ (SQL: alter table submission_file_revisions add constraint submission_file_revisions_submission_file_id_foreign foreign key (submission_file_id) references submission_files (submission_file_id))

The version of PHP I am using is 8.3.6

It seems that the problem is with the migration of the I8073_RemoveNotesWithoutQueriesAndRelatedObjects.php file

I hope for your help, greetings

Hi @jpmaidana,

Double-check that all tables in your database use the same MySQL storage engine (normally this should be InnoDB).

Alec Smecher
Public Knowledge Project Team

This topic was automatically closed after 11 days. New replies are no longer allowed.