How to upgrade OJS 2.x to OJS 3.x » Open Journal Theme

How to upgrade OJS 2.x to OJS 3.x

Upgrade OJS 2.x to OJS 3.x

To get the best performance from OJS software, the OJS upgrade process must be done regularly on your OJS. This is to ensure that your OJS site is optimized, safe from various hacker attacks, and has the latest features from PKP. In this article, we are upgrading using a method that we have tested in a many of previous journals with a careful step-by-step method to ensure that the upgrade results do not cause problems in the future.

Using the latest version of OJS is very important to improve the performance of your journal and maximize all the features available on the OJS system. When upgrading OJS 2 to OJS 3, the process must be done very carefully with a complicated process that takes a lot of time, so before we continue the upgrade process on your journal, please prepare coffee and snacks :).

What are the benefits of doing an OJS upgrade

At the latest version of OJS your Journal site will be maximized as a whole based on the features released by PKP, however  your Journal site must be tailored to your current Journal needs, because there are several changes in terms of appearance and function in OJS 2 to OJS 3, PKP always innovates, also they continue to make improvements to the OJS software so that the software can work maximally.

Details of some of the new features at OJS 3 :
– OJS 3 More responsive
– OJS 2 will be deprecated in the future and is no longer supported
– OJS users more familiar with OJS 3
– OJS 3 already has a more complete OJS management feature
– more supported by 3rd party plugins

Details of some of the new features found in OJS (OJS

– Submission deletion can delete author records in other submissions

– OJS3.2 Editorial activity stats counting submissions from removed journals

– Recommend by Author Plugin duplicates entries

– Add TITLE parameter to IFRAME of article galley view

– Write integration tests for versioning features

– Support a “draft” option for reviews

– and much more

With the features above, in our opinion, it is very helpful in managing journals as well as improving the features of your OJS that have been upgraded.

Consideration of upgrading OJS 2.x to OJS 3.x :

There are several things that you should consider when upgrading OJS 2 to OJS 3 :

– The OJS 2 Theme or your design template you used before, may no longer support the latest OJS version


How to Upgrade OJS2 – OJS 3

To upgrade OJS from OJS2 to OJS3, there are a several of things that must be considered, so that your journal can run well. Because based on the experience of our team, the process of upgrading OJS2 to OJS3 is quite time consuming, so you have to be careful about the process. this, so as not to waste your time by doing the same thing over and over, in the upgrade process . In this article, openjournaltheme will try to provide step by step details of upgrading OJS 2 to OJS 3 in detail and easy to understand.

Note :
–  You must backup the entire OJS system before upgrading, because the OJS2 – OJS 3 upgrade process has a higher failure rate than OJS 3 to OJS 3. files that you should back up:

  • OJS Files (Folder)
  • public (Folder)
  • Current database backup

–  It is important to remember that the upgrade process of ojs 2 to OJS 3 must be done step by step. Go to OJS 3.0.2 first then to version 3.1.2-4.


Upgrade OJS 2.x to 3x  using CLI

(Command line) method

If you are using a vps server in your journal, I recommend you to use the CLI method because of this method. The detailed process when you run the upgrade, will appear in your terminal and if an error occurs, we can immediately find out what process or what caused us to fail in the upgrade process. Then based on our experience, upgrading OJS using the CLI has a higher success rate than using the web browser method.

How Upgrade OJS2.x to OJS3.x CLI ? :

  1. Compress that folder file (files_dir) and public on ojs (which is used by OJS as journal file). Save on location http: //your_domain/
    http: //domain/ So the files that need to be downloaded by the client are:
  2. Extract the database file so that it has a .sql extension
    Create the OJS 2 database that has been downloaded from the client and name it:
    name_journal_3.x The following commands are run on the mysql command line:


    create database name_your_db.3.x;

    use name_your_db.3.x;

    source /location/YOUR_FILE_SQL.sql;

  3. After the first preparatory step is done, then make the settings for the file in the folder that was extracted earlier (name_journal_3.0.2)
    – Change the value of the installed = On parameter to Off
  4. Edit the database connection parameters to mysqli and adjust the username, password and database name that was created earlier
  5. Enter the OJS folder that you created , then type this scipt on your terminal
    php tools/upgrade.php upgrade
  6. The upgrade process will take a 15 minutes to 1 hour. After the upgrade process is complete without any error information as shown below. If you have finished upgrading OJS 2.x to 3.x, the next step is to test all functions on the OJS systems.

OJS Problem after upgrade OJS 3

1. Error  Illegal mix Collations Latin Swedish:

If when you upgrade an error appears like the following

*ERROR: Upgrade failed: DB: Illegal mix of collations (latin1_swedish_ci,IMPLICIT), (utf8mb4_general_ci,COERCIBLE), (utf8mb4_general_ci,COERCIBLE) for operation ‘replace’

Solution : Convert the entire table into collation to utf8_general_ci with the following query in the linux terminal

mysql --user=root --password="" --database=dbname -B -N -e "SHOW TABLES" | awk '{print "SET foreign_key_checks = 0; ALTER TABLE", $1, "CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; SET foreign_key_checks = 1; "}'| mysql --user=root --password="" --database=dbname &

2  Duplicate entry

When you upgrade OJS 2 you may encounter problems like this

[code: Installer Installer::migrateUserAndAuthorNames]
<h1>DB Error: Duplicate entry ‘11477-es_ES-preferredPublicName’

1. TryRun this query on your Mysql or phpmyadmin

SELECT js.setting_value FROM journal_settings js JOIN submissions s ON (s.context_id = js.journal_id) JOIN authors a ON (s.submission_id = a.submission_id) WHERE setting_name='supportedLocales' AND a.author_id = 17;

Result after run query

mysql> SELECT js.setting_value FROM journal_settings js JOIN submissions s ON (s.context_id = js.journal_id) JOIN authors a ON (s.submission_id = a.submission_id) WHERE setting_name=’supportedLocales’ AND a.author_id = 11477;
| setting_value                                                          |
| a:4:{i:0;s:5:”en_US”;i:1;s:5:”es_ES”;i:2;s:5:”es_ES”;i:3;s:5:”pt_BR”;} |
1 row in set (0.00 sec)

As you can see on the following line:

You will find a duplicate language setup in your current OJS. The solution is that you have to disable the duplicated language in your OJS admin dashboard.
2. The way to get rid of duplicate language settings is to access your OJS admin page.
3. Then open the Settings menu -> Website On the website page, please open the language menu. On that tab, please click check the language selection box, then click again.
4.Perform the OJS upgrade steps again through the command line using a database that has not been upgraded.
5.If after you successfully upgrade via the command line, if you encounter an error on the submission menu, please do the settings by changing the parameters as described in the following link.

OJS Upgrade Services

Leave all matters related to your OJS problem with our team that has years of experience and handles various application needs of OJS, servers, security issues, and matters related to system implementation.
We carry out the OJS upgrade process by taking careful steps and handled by a team that is experienced in the OJS field. The upgrade process is carried out without disturbing the OJS that is actively being used. We perform the upgrade process.

OJS Upgrade 2.x to OJS 3latest OJS version

OJS Upgrade 3.x to 3.x or latest OJS version

openjournaltheme have a few of  standards in the process of upgrade OJS site by implementing a staging process and Creating a backup of your current OJS to ensure that nothing goes wrong with your current OJS site.

Leave a Comment

Your email address will not be published. Required fields are marked *

Open Journal Theme

Professional Publishing system services OJS, OMP, Dspace, Eprints

Need More Services  or Question? started in 2016 by a passionate team that focused to provide affordable OJS, OMP,  OPS,  Dspace, Eprints products and services. Our mission to help publishers to be more focus on their content research rather than tackled by many technical OJS issues.

Under the legal company name :
Inovasi Informatik Sinergi Inc.

Secure Payment :

All the clients financial account data is stored in the respective third-party site (such as Paypal, Wise and Direct Payment).
Your financial account is guaranteed protected. We never keep any of the clients’ financial data.