Jump to the post that solved this thread.
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Not Solved [Installing] SQL ERROR - 1064 - You have an error in your SQL syntax
#1
Not Solved
Hi all, I'm trying to install MyBB 1.6 on my Own PC. Via Xampp. I did it once before but had to uninstall/Reinstall Xampp and Now I can't seem to get MyBB to work =/ I really like MyBB it's sleet and Clean and Really easy to use. But anyways This is my Error I'm getting During install after Database Configuration.



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;

Please contact the MyBB Group for support.


Any help would be very useful please =]
#2
Not Solved
http://community.mybb.com/thread-87216-p...#pid637944 Wink
Your friendly neighbourhood lurker.
#3
Not Solved
Love ya =D Weird that didn't pop up on Google =_= Anyways thanks the 1 file fixed it.
Jump to the post that solved this thread.


Forum Jump:


Users browsing this thread: 1 Guest(s)