Installation failed! SQL error during table creation
Hey dear MyBB community.
So I recently tried to install the MyBB forums, but quickly run into a very annoying problem.
I followed the instruction provided on this post from MyBB: https://docs.mybb.com/1.8/install/
I did everything, edited the file permissions, the requirements check when I began the install worked perfectly and it said congratulations and I could go on.
Then I came to the database configuration. I then gave everything in correctly, the host, name, password etc. and selected improved SQL. PostgreSQL was also an option but that didn't work.
I went on with improved SQL option that worked and then the table creation page showed up with the following text:
Connection to the database server and database you specified was successful.
Database Engine: MySQLi 5.7.19
The MyBB database tables will now be created.
Creating table mybb_adminlog...
And directly after that a blue box that has the title: MyBB SQL Error. Inside the box was the following text:
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:1286 - Unknown storage engine 'MyISAM'Query:CREATE TABLE mybb_adminlog ( uid int unsigned NOT NULL default '0', ipaddress varbinary(16) NOT NULL default '', dateline int unsigned NOT NULL default '0', module varchar(50) NOT NULL default '', action varchar(50) NOT NULL default '', data text NOT NULL, KEY module (module, action), KEY uid (uid) ) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci;
I have tried everything and several times and nothing seems to work...would really appreciate your help!
Thanks in advance
So I recently tried to install the MyBB forums, but quickly run into a very annoying problem.
I followed the instruction provided on this post from MyBB: https://docs.mybb.com/1.8/install/
I did everything, edited the file permissions, the requirements check when I began the install worked perfectly and it said congratulations and I could go on.
Then I came to the database configuration. I then gave everything in correctly, the host, name, password etc. and selected improved SQL. PostgreSQL was also an option but that didn't work.
I went on with improved SQL option that worked and then the table creation page showed up with the following text:
Connection to the database server and database you specified was successful.
Database Engine: MySQLi 5.7.19
The MyBB database tables will now be created.
Creating table mybb_adminlog...
And directly after that a blue box that has the title: MyBB SQL Error. Inside the box was the following text:
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:1286 - Unknown storage engine 'MyISAM'Query:CREATE TABLE mybb_adminlog ( uid int unsigned NOT NULL default '0', ipaddress varbinary(16) NOT NULL default '', dateline int unsigned NOT NULL default '0', module varchar(50) NOT NULL default '', action varchar(50) NOT NULL default '', data text NOT NULL, KEY module (module, action), KEY uid (uid) ) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci;
I have tried everything and several times and nothing seems to work...would really appreciate your help!
Thanks in advance
