Problem upgrade ojs (OJS 3.2.1.2) to ojs-3.3.0

[Elton_Pereira_Leite]

I’m having problems updating OJS, I’m getting the following error during the upgrade:

ERROR: Upgrade failed: DB: SQLSTATE[HY000]: General error: 1005 Can’t create table submission_pepsic_scielo_br.review_round_files (errno: 150 “Foreign key constraint is incorrectly formed”) (SQL: alter table review_round_files add constraint review_round_files_submission_file_id_foreign foreign key (submission_file_id) references submission_files (submission_file_id))

[janiosarmento]

Elton,

Take a look at this link, it seems to be the same issue:

Updating from 3.2.1.4 to 3.3.0.10, and DB error SQLSTATE[HY000]: General error: 1005

Hi there, You need to grant REFERENCES permission for your database user. GRANT REFERENCES ON `database_name`.* TO 'database_user'@'localhost';

[Elton_Pereira_Leite]

Hi, that didn’t solve my problem!