MyBB Community Forums

Hey there.

So I've been setting up some localhost test forums on my ...well, localhost. I've gotten past the point of putting up all the details and to actually creating the tables and install the board. This is the error I get from that:



Text form for the non-imagers out there! (?)

MyBB Error Wrote: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;

Any ideas?
Thanks guys.

- Jordan.

Its an issue with the latest mybb and its MySQL version,use this wamp and it should solve your problem:

http://sourceforge.net/projects/wampserv...e/download

I'd prefer to use something like XAMPP, which is what I'm currently using at the moment. What's the differences between that Wampp version and XAMPP?

(2011-03-27, 08:17 AM)trilobyte- Wrote: [ -> ]I'd prefer to use something like XAMPP, which is what I'm currently using at the moment. What's the differences between that Wampp version and XAMPP?

Nothing brother,both are same,am using WAMP without any problem,fast,smooth and reliable.

Fair enough, thanks for the advice and solution. I'll keep this to see if there's anything else that can be done to solve it while keeping XAMPP.

Try downloading this and see if problem gets solved,uninstall current version and install this:

http://sourceforge.net/projects/xampp/fi...z/download

Hello, Do you try to re-install it? because I use XAMPP the latest and works perfectly.

MyBB 1.6.2 and older are incompatible with MySQL 5.5. http://dev.mybb.com/issues/1379
It's not always to install the latest versions of PHP or MySQL as this could break some web application if they haven't been optimized for the latests versions yet.

You could download that patch and apply it to your 1.6.2 version and try the installation again.

(2011-03-27, 09:09 AM)Aries-Belgium Wrote: [ -> ]MyBB 1.6.2 and older are incompatible with MySQL 5.5. http://dev.mybb.com/issues/1379
It's not always to install the latest versions of PHP or MySQL as this could break some web application if they haven't been optimized for the latests versions yet.

You could download that patch and apply it to your 1.6.2 version and try the installation again.

yes as I said.

OP download either xampp or wamp of the links which I gave.

Thankyou both for the excellent replies. I will download an older version of XAMPP or just head to Wamp. Thanks!