OJS3 user and articles schemas


Hi Community,

Is there a manual or documentation. That states the information about users and articles schemas.

Suppose if I add user or article , what are all the tables get effected. Where can I find this information or provide me that information.

Thanks in advance and it will help me upgrading ojs2 to ojs3.

Tried to upgrade and it’s broke hence I am planning differently



I just requested for documentation At least… . Nobody responded. Dont we have it for the new versions of OJS?


Hi @Umadhar,

We don’t have any specific documentation answering that question. How did your installation get broken? Maybe it’s possible to fix it.

Alec Smecher
Public Knowledge Project Team


Hi @asmecher,

Thank you for your response.

I tried to upgrade from 2.4.7 to and i am having the following error and could not proceed further:

Errors occurred during installation:

A database error has occurred: Illegal mix of collations (latin1_swedish_ci,IMPLICIT), (utf8_general_ci,COERCIBLE), (utf8_general_ci,COERCIBLE) for operation ‘replace’

What is the best action to take on this. Please suggest.

Appreciate and thanks in advance.


Hi @Umadhar,

Your MySQL database is trying to mix two different encodings in its data, suggesting that your old and new database configurations are different. I’d suggest standardizing everything on UTF-8 rather than Latin1, but you may need to transcode your database in order to do that. It’s a bit beyond the scope of this forum, as it’s more of a MySQL question than an OJS question, but you may find some useful discussions on stackoverflow.com.

Alec Smecher
Public Knowledge Project Team