1064 - You have an error in your SQL syntax;

[Hardscore]

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]

The solution is 2 topics below your question: http://community.mybb.com/thread-149827.html

[Hardscore]

Thank you very much Destroy666, it worked fine!

[eddiekeyton]

Change Type= to Engine= is how i fix it. It's located in the plugin file