Upgrade error "Base table or view already exists" from 3.2.1.2 to 3.3.0.6

Hi,
I was able to move forward with this database upgrade error.

When trying to change engine tables from myisam to innodb, mariadb gives an error when processing “submission_file_revisions” table.

The foreign key constraint “submission_file_revisions_submission_file_id_foreign” references the field “submission_file_id” on “submission_files” table. This field “submission_file_id” doesn’t exist in “submission_files” table in our database.

Is this only a problem in our local database or other users have the same problem ?

I’ll try to drop this foreign key temporarily to make the upgrade.

thanks,
mathieu

1 Like