MyBB Community Forums

Hi,

I got this error when activating DennisTT's RSS mod...
What could I do to fix it?

You have an error in your SQL syntax near 'ENGINE = MYISAM' at line 5
Query: CREATE TABLE mybb_rss2post ( fid INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , url VARCHAR( 255 ) NOT NULL , forum INT( 10 ) UNSIGNED NOT NULL ) ENGINE = MYISAM

remove ENGINE = MYISAM then.

No I have:
CREATE TABLE ".TABLE_PREFIX."rss2post (
fid INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
url VARCHAR( 255 ) NOT NULL ,
forum INT( 10 ) UNSIGNED NOT NULL");

But it still gives an error.

Quote:You have an error in your SQL syntax near '' at line 7
Query: CREATE TABLE mybb_rss2post ( fid INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , url VARCHAR( 255 ) NOT NULL , forum INT( 10 ) UNSIGNED NOT NULL

CREATE TABLE ".TABLE_PREFIX."rss2post (
fid INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
url VARCHAR( 255 ) NOT NULL ,
forum INT( 10 ) UNSIGNED NOT NULL default ");

Weird:

Quote:Query: CREATE TABLE mybb_rss2post ( fid INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , url VARCHAR( 255 ) NOT NULL , forum INT( 10 ) UNSIGNED NOT NULL default

Maybe there's something wrong with the system?

You keep doing something wrong

CREATE TABLE `mybb_rss2post` ( `fid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , `url` VARCHAR( 255 ) NOT NULL , `forum` INT( 10 ) UNSIGNED NOT NULL)

Working, thanks.