Issue: New database tables are being created as InnoDB (when using MariaDB / MySQL). They should be MyISAM.
Solution: The default engine is likely configured as InnoDB.
SSH into server as root, and check database configuration:
nano /etc/my.cnf
You may see something similar to:
[mysqld]
bind-address=127.0.0.1
default-storage-engine=InnoDB
innodb_file_per_table=1
max_allowed_packet=268435456
open_files_limit=10000
local-infile=0
init_connect='SET collation_connection=utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_unicode_ci
query_cache_type = 1
query_cache_limit = 1M
query_cache_size = 128M
Changed the line: default-storage-engine=InnoDB to:
default-storage-engine = MyISAM
If using cPanel, restart the DB with:
/usr/local/cpanel/scripts/restartsrv_mysql
If not using cPanel, restart the database with:
/etc/init.d/mysql restart