Error upgrading OJS 3.2.1.3 to 3.4

[manimughal]

Dear @asmecher,
We are having trouble upgrading OJS 3.2.1.3 to OJS 3.4.
The following error occurred:

• A database error has occurred: Storage engine that doesn’t support foreign key constraints detected in one or more tables: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , . Change to InnoDB before running the upgrade.

Already attempted.
Please guide.
Regards

[asmecher]

Hi @manimughal,

The problem is that all or part of your MySQL or MariaDB database is using the old MyISAM storage engine, when it should be using InnoDB. You’ll need to convert your database to InnoDB before running the upgrade. (This will perform better, and will support important features like referential integrity; InnoDB has been the MySQL default for many years.)

The upgrade script tries to warn you about this, but as you can see the list is not properly displayed. You can fix that part by applying this fix. (We’ll release that in OJS 3.4.0-1 very shortly, also including a few other fixes.)

For information on converting your database to InnoDB, see e.g.: Convert MyISAM Tables to InnoDB

Regards,
Alec Smecher
Public Knowledge Project Team