MyBB Community Forums

MyBB Community Forums > Extensions > Plugins > Plugin Support > 1064 - You have an error in your SQL syntax;
Full Version: 1064 - You have an error in your SQL syntax;
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

Hardscore

2014-01-11, 01:04 PM
Hi guys,

i almost finished my forum, but if i would install a plugin i ve got this error. I dont know whats the problem:

Forum:

http://bege.storage-plan.org/bege/index.php

MYBB 1.6

Plugin MYPS http://www.mybbcentral.com/thread-2059.h...light=myps

(changed myps.php from 14* to 1* for compatibility)
http://www.mybbcentral.com/thread-7520.html

Got this error during installation:

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' at line 12
Query:
    CREATE TABLE mybb_mypslogs ( logid smallint(8) NOT NULL auto_increment, senduid smallint(8) NOT NULL, senuser varchar(20) NOT NULL, recieveuid smallint(8) NOT NULL, recuser varchar(20) NOT NULL, altmyps varchar(16) NOT NULL, dateline int(11) NOT NULL, modaction varchar(3) NOT NULL, reason varchar(200) NOT NULL, PRIMARY KEY (logid) ) TYPE=MyISAM;


Anoyone can help me please?

Destroy666

2014-01-11, 02:40 PM
The solution is 2 topics below your question: http://community.mybb.com/thread-149827.html

Hardscore

2014-01-11, 02:59 PM
Thank you very much Destroy666, it worked fine!

eddiekeyton

2014-01-11, 05:07 PM
Change Type= to Engine= is how i fix it. It's located in the plugin file
MyBB Community Forums > Extensions > Plugins > Plugin Support > 1064 - You have an error in your SQL syntax;