SQL General error: 3161 Storage engine MyISAM is disabled

George-field

Hello Everyone,

I am trying to connect to a database and getting the following error General error: 3161 Storage engine MyISAM is disabled Any idea how to resolve this issue? I am using a managed DB service, I believe it has InnoDB as standard.

Full error message:

Something went wrong: SQLSTATE[HY000]: General error: 3161 Storage engine MyISAM is disabled (Table creation is disallowed). (SQL: create tableflrm_posts(idint unsigned not null auto_increment primary key,discussion_idint unsigned not null,numberint unsigned null,timedatetime not null,user_idint unsigned null,typevarchar(100) null,contenttext null,edit_timedatetime null,edit_user_idint unsigned null,hide_timedatetime null,hide_user_idint unsigned null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = MyISAM)

any help would be hugely appreciated!

jordanjay29

George-field What version of MySQL/MariaDB are you using?

clarkwinkelmann

I believe we used to use MyISAM on the posts table for some search optimization, but this was changed back to InnoDB in more recent releases.

The problem is likely that when the migration run, they first create the table as MyISAM and then change it to InnoDB.

If MyISAM is completely unavailable on the server, you could run the migrations (install Flarum) on another server, then copy the database to the production server.

George-field

jordanjay29 Mysql

George-field

clarkwinkelmann Could I try a newer version or am I likely to encounter the same issues?

clarkwinkelmann

George-field if the service purposefully not offers MyISAM a newer version will probably not help.

I suggest you install Flarum on a local computer that has MyISAM, then dump the database and use that dump to create it on the production server.

George-field

So I have done that and I now have the database set up but have the issue that its giving me this error Base table or view already exists: 1050 Table 'flrm_migrations' already exists any ideas on this one? Also, thank you for your help 🙂

clarkwinkelmann

George-field if you manually imported the database, you'll have to create config.php manually with the database credentials already filled in. You can most likely copy this file from the local Flarum you used to create the database and modify as needed.

The error you see is because Flarum currently has no way to detect the database is already ready when installing. If you create config.php then it'll skip those steps.

Adam_Hosker

DigitalOcean managed Database disables MyISAM by default. Is there anywhere around this? perhaps force Flarum to use InnoDB for example?

My sleuthing on DigitalOcean forums proposes this as a solution for PrestaShop.

error

EDIT: Solution Found

I have fixed this error by changing the Engine Type that is Hard-Coded into Flarum. Pull Request Created: flarum/core2442

Edit: vendor/flarum/core/src/Install/DatabaseConfig.php
Change (Line 50):
'engine' => 'MyISAM',
To
'engine' => NULL,

Edit: vendor/flarum/core/migrations/2015_02_24_000000_create_posts_table.php
Remove (Line 34):
$table->engine = 'MyISAM';

Then re-run the install and all is fine.