[John3971]

Originally Posted by Andrew Green

You can't name a field "date" or "time", you need to rename those, ex:

$db->query_write("CREATE TABLE " . TABLE_PREFIX . "news (id integer NOT NULL PRIMARY KEY auto_increment, title varchar, newsdate varchar, newstime varchar, poster varchar, newst text)");

aa then i understand :P

but i still get error when i use the one you wrote here.

Database error in vBulletin 3.7.0 Beta 3:

Invalid SQL:
CREATE TABLE vb_news (id integer NOT NULL PRIMARY KEY auto_increment, title varchar, newsdate varchar, newstime varchar, poster varchar, newst text);

MySQL Error   : 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 ' newsdate varchar, newstime varchar, poster varchar, newst text)' at line 1
Error Number  : 1064
Date          : Wednesday, January 16th 2008 @ 10:04:39 PM
Script        : http://test.fanrage.org/testvb/admin/plugin.php?do=productimport
Referrer      : http://test.fanrage.org/testvb/admin/plugin.php?do=productadd
IP Address    : 85.224.63.34
Username      : John
Classname     : vB_Database
MySQL Version : 5.0.18-nt-log