[John3971]

Originally Posted by Andrew Green

$db->query_write("CREATE TABLE test (testid integer NOT NULL PRIMARY KEY auto_increment, testname text)");

that was the one i had but i keep getting this error when im importing the plugin:

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, date date, time time, poster varchar, text 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 ' date date, time time, poster varchar, text text)' at line 1
Error Number  : 1064
Date          : Wednesday, January 16th 2008 @ 09:17:28 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