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

Software Support
1

With a database with version 3.2.1.4 and wanting to migrate to version 3.4.0.5 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

2

Hi @jpmaidana,

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

Regards,
Alec Smecher
Public Knowledge Project Team

4

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