![]() Do the Craft installation on a local dev environment that supports MyISAM, convert the searchindex table to InnoDB using your favorite MySQL client, then restore that database to the box that doesn't support MyISAM.'fieldId' => $this->integer()->notNull(),Ĭhange it to this: // Add the FULLTEXT index on searchindex.keywords Modify Craft's install migration at vendor/craftcms/cms/src/migrations/Install.phpįind this: // Add the FULLTEXT index on searchindex.keywords.If you're trying to install Craft directly onto a MySQL box that has MyISAM disabled, you can either: I'm also wondering why I've never run into this before when working with DigitalOcean's managed dbs. But I'm wondering how I can set Craft up with this restriction? If I run show engines in the database I can see that the DB is configured the exact same way as another Craft instance which is working perfectly fine. I understand that MyISAM is not as widely supported as InnoDB but that searchindex requires it because it is full text searchable. => Storage engine MyISAM is disabled (Table creation is disallowed).Ĭaused by: Exception 'PDOException' with message 'SQLSTATE: General error: 3161 Storage engine MyISAM is disabled (Table creation is disallowed).' In /srv/gentri/vendor/yiisoft/yii2/db/Schema.php:678 ) ENGINE=MyISAM DEFAULT CHARACTER SET = utf8' The SQL being executed was: CREATE TABLE `searchindex` ( everything on digitalocean seems correct but it still doesnt connect. craft setup I get this error: Caused by: Exception 'yii\db\Exception' with message 'SQLSTATE: General error: 3161 Storage engine MyISAM is disabled (Table creation is disallowed). I cannot login with the sequel pro software as well. I just cloned an existing droplet with a working instance of Craft, I created a MySQL8 managed DB but whenever I run php.
0 Comments
Leave a Reply. |