Not able to upgrade to 3.4.0.1 because of default storage engine being MyISAM

Software Support
1

Description:

I’m trying to upgrade OJS OJS Version 3.3.0.8 to OJS Version 3.4.0.1. While upgrading we face the below stated error. We do not have privileges to change the default storage engine. Is there any workaround to this?

Error:

Errors occurred during installation:

  • A database error has occurred: A default database engine MyISAM isn’t supported, expecting InnoDB. Please change the default database engine to InnoDB to run the upgrade.

image
image975×429 117 KB

Figure Description: Snippet of the error

Specifications:

Hosting Service used: CPanel

Php version: PHP 8.1 (ea-php81)

Database server: MariaDB

Server version: 10.6.12-MariaDB - MariaDB Server

Access to change default storage engine: No

image
image581×503 69.9 KB

Figure Description: Error that occurs if we try to change the default database engine via phpMyAdmin through CPanel.

2

Hi @rpk,

I think the best course of action is to get in touch with your hosting company about it, or even migrating to a more flexible one.

Best regards,
Josh

1 Like
3

MyISAM was nice, but nowadays is deprecated:

MyISAM is based on the older (and no longer available) ISAM storage engine but has many useful extensions.

Source: https://dev.mysql.com/doc/refman/8.0/en/myisam-storage-engine.html

If you still have doublts take a look to this article:
https://lefred.be/content/still-using-myisam-it-is-time-to-switch-to-innodb/

Your hosting company will let you select your mysql engine (if not, you MUST change your hosting).

If you can’t change the engine directly from cpanel (or phymyadmin or adminer), you can create a new DB in your cpanel with a InnoDB engine and use mysqldump to export and import your data.