2006-02-13, 03:05 PM
Hello everyone,
While activating Nitemares ad rotator 3.40 under MyBB 1.03, I get this MYSQL Syntax error:
mySQL 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 '( 255 ) NOT NULL , MODE INT( 3 ) NOT NULL , shown INT( 3 )
Query: CREATE TABLE mybb_ads( aid INT( 100 ) NOT NULL AUTO_INCREMENT , code TEXT( 255 ) NOT NULL , MODE INT( 3 ) NOT NULL , shown INT( 3 ) NOT NULL , max INT( 3 ) NOT NULL , PRIMARY KEY (
According to that, its saying that there is an error in that script somewhere. Can someone find it out and tell me the correct script please?
Thank you,
Shock260
While activating Nitemares ad rotator 3.40 under MyBB 1.03, I get this MYSQL Syntax error:
mySQL 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 '( 255 ) NOT NULL , MODE INT( 3 ) NOT NULL , shown INT( 3 )
Query: CREATE TABLE mybb_ads( aid INT( 100 ) NOT NULL AUTO_INCREMENT , code TEXT( 255 ) NOT NULL , MODE INT( 3 ) NOT NULL , shown INT( 3 ) NOT NULL , max INT( 3 ) NOT NULL , PRIMARY KEY (
aid
) ) According to that, its saying that there is an error in that script somewhere. Can someone find it out and tell me the correct script please?
Thank you,
Shock260