So I'm installing MyBB on my fresh install of Wamp server 2.1 and after putting in my database details I get this 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 mybb_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;
I have tried a new copy of mybb and tried multiple database names as well as MySQL and MySQLi, I have no idea how to fix it.
Thank you.
What version of MySQL does that version of Wamp have? MyBB doesn't work on 5.5 yet.
(2011-01-06, 12:06 AM)pyridine Wrote: [ -> ]What version of MySQL does that version of Wamp have? MyBB doesn't work on 5.5 yet.
o.0 I'm using 5.5.8 and i don't know how to downgrade/upgrade
Yeah, you kinda have to downgrade unless you want to wait for a MyBB update. (Who knows when that will be)
Edit: You can edit the installation file so it has the correct syntax. Don't ask me how to do it though.
You can see a list of required changes to fix this here:
http://dev.mybb.com/projects/mybb/reposi...sions/5299
We didn't realise this change had been made to MySQL 5.5 until after 1.6.1 had been released so it's not been fixed in the main download yet. It only seems to be people using WAMP that get this error though, I doubt many hosts are going to be upgrading to 5.5 just yet.
(2011-01-06, 12:17 AM)MattRogowski Wrote: [ -> ]You can see a list of required changes to fix this here: http://dev.mybb.com/projects/mybb/reposi...sions/5299
We didn't realise this change had been made to MySQL 5.5 until after 1.6.1 had been released so it's not been fixed in the main download yet. It only seems to be people using WAMP that get this error though, I doubt many hosts are going to be upgrading to 5.5 just yet.
Thank you, Jitendra linked me too this post:
http://community.mybb.com/thread-84660-p...#pid620042
Thought i would post to help anyone else having this problem.
Edit: I should probably mention the problem is fixed.