MyBB Community Forums

Hi guys

I am getting an error when I get to the table creation part of the setup.

This is the error I get when trying to create it..

Creating table mybb_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 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 am running mysql 5.3.5 on wamp and this is the local ip/root Im using
http://localhost/upload/install/index.php

I must add Im not sure what to write in the table prefix part of the setup

You sure your running MySQL 5.3.5? This is usually caused by MySQL 5.5. Could you please double check that you are running 5.3.5, and not 5.5? If you are running 5.5, then the changes you need to fix this are available here: http://dev.mybb.com/projects/mybb/reposi...sions/5299

(2011-02-19, 06:40 AM)Joshua Mayer Wrote: [ -> ]You sure your running MySQL 5.3.5? This is usually caused by MySQL 5.5. Could you please double check that you are running 5.3.5, and not 5.5? If you are running 5.5, then the changes you need to fix this are available here: http://dev.mybb.com/projects/mybb/reposi...sions/5299

Yes you are right Im a complete nipple, I was lookin at my php version not sql.

Just to confirm what I have to do... I have to go through all php files in my upload folder and change TYPE=MYISSAM to ENGINE=INNODB..

Thanks man.

Easiest solution is to just download the updated files. Click on upgrade.php, and click download. Place it in the install folder, then do the same with the 5 other files mentioned and put them in the install/resources folder.

Ah man I've done it!!

This is cool, thanks man. First forum/website Ive ever had!!

Just one more thing, it mentions I need to delete a "lock" file somewhere. Is this necessary and how do I do it..

Cheers :-)

Ah, in the install directory, there is a file called 'lock'. Just delete it. It's just a file to prevent the installer being ran a second time.

Thanks man!!!