OJS Upgrade Failed 3.2.1.1. to 3.3.0.10

Software Support
1

ekran

2

no matter what I did I couldn’t solve the problem.

3

Hi @ikram,

OJS 3.3 requires your MySQL user to have REFERENCE privilege:

  1. On PHP MyAdmin, go to the mysql database and open the table user.
  2. Locate your OJS database user, click on edit and change the value of the column References_priv from N to Y.
  3. Issue a new SQL query in phpMyAdmin: FLUSH PRIVILEGES;

This should solve your issue, try to run the upgrade again.

Best regards,

Josh Noronha (he/him)
Systems Administrator
PKP|PS Support Team

Subscribe to the PS Bulletin for quarterly updates on
PKP software, support, and community events

5

ddd

Thanks. Sorry for Turkish in the picture. User privileges are like this. I think there must be another solution.

6

Hi @ikram,

You’ll need to double check. on PHP MyAdmin, on the left column, click on Mysql, then select the table users. Locate the database user and click on Edit. Check the attached file, please.

forum-mysql-references

Best regards,

Josh Noronha (he/him)
Systems Administrator
PKP|PS Support Team

7

aaa

I guess this job will be done by the hosting company. Because mysql database does not appear on my screen.

8

I asked the firm that I bought hosting service about this situation. Their answer:
Unfortunately, this type of change cannot be made in shared hosting services. For this, you need to have a virtual server service.