Error upgrade 3.2.1.4 -> 3.3.0.7

Software Support
1

Hi,

I’m unable to update OJS 3.2.1.4 to 3.3.0.7.

I found this error
ERROR: Upgrade failed: DB: SQLSTATE[42000]: Syntax error or access violation: 1142 REFERENCES command denied to user ‘myuser’@‘localhost’ for table ‘files’ (SQL: alter table submission_files add constraint submission_files_file_id_foreign foreign key (file_id) references files (file_id))

Thanks for any help.

2

Hi @luciano,

This message states your MySQL user doesn’t have enough permissions on its database to perform the upgrade.

You can easily fix this, but you need root access to your database. Just run the query below (of course, replacing the data with your username and database name):

GRANT REFERENCES ON `database`.* TO 'youruser'@'localhost';

After that, your user will have enough permissions to proceed.

3

Hi @janiosarmento

Sorry for the delay. I had problems with the cloud environment where I was testing.

After the changes the system completed the update.

Thanks.