Cannot activate without InnoDB support
-
I installed this plugin on a website that uses a MySQL server without InnoDB support (the hosting provider limits free users to MyISAM – which is generally OK for WordPress). When trying to activate the plugin, I got the following error page:
Zend_Db_Statement_Exception thrown WP DB Error: [1286] Unknown storage engine 'InnoDB' SQL: CREATE TABLE wp_matomo_user ( login VARCHAR(100) NOT NULL, password VARCHAR(255) NOT NULL, email VARCHAR(100) NOT NULL, twofactor_secret VARCHAR(40) NOT NULL DEFAULT '', superuser_access TINYINT(2) unsigned NOT NULL DEFAULT '0', date_registered TIMESTAMP NULL, ts_password_modified TIMESTAMP NULL, PRIMARY KEY(login) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
…and I was getting it every time I tried to access any WP-Admin page until I renamed the
/wp-content/plugins/matomo
folder using FTP to force deactivate Matomo.I think InnoDB should be noted as a requirement of this plugin (e.g. extend the FAQ item “Which MySQL versions are supported?”). The plugin should also check InnoDB availability before trying to create tables using it.
(Since I’ve already purchased a paid hosting plan, I will switch my DB to InnoDB to use Matomo. However, potential future users should be warned to avoid a bad user experience.)
- The topic ‘Cannot activate without InnoDB support’ is closed to new replies.