Current time: 04-20-2014, 08:15 AM Hello There, Guest! (LoginRegister)


[Installing] mySQL 5.5 Incompatibility
03-30-2011, 08:53 AM
Post: #1
Not Solved mySQL 5.5 Incompatibility
Using myBB 1.6.2 with a mySQL 5.5 (Master-Master Setup) results in the following error message:

Connection to the database server and table you specified was successful.

Database Engine: MySQLi 5.5.10

The MyBB database tables will now be created.
Creating table board_adminlog...
MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci' at line 9
Query:
CREATE TABLE board_adminlog ( uid int unsigned NOT NULL default '0', ipaddress varchar(50) NOT NULL default '', dateline bigint(30) NOT NULL default '0', module varchar(50) NOT NULL default '', action varchar(50) NOT NULL default '', data text NOT NULL, KEY module (module, action) ) TYPE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci;
Find all posts by this user
03-30-2011, 08:58 AM
Post: #2
Not Solved RE: mySQL 5.5 Incompatibility
It's a known issue: http://dev.mybb.com/issues/1379
Either download the patch and apply it to your mybb installation or downgrade your mysql server. The patches will be included in 1.6.3.

My latest plugins: Extra Forum Permissions | Facebook Meta Tags | Auto Unapprove Reported Posts
[Image: sig.png]
Find all posts by this user
03-30-2011, 09:15 AM
Post: #3
Not Solved RE: mySQL 5.5 Incompatibility
Thank you for your fast response. I'll go with the patches rather than downgrading the mysql setup Smile
Find all posts by this user


Forum Jump:


User(s) browsing this thread: 1 Guest(s)

Contact Us | MyBB | Return to Top | Return to Content | Lite (Archive) Mode | RSS Syndication