[SnowBot]

hhmm great idea but i got an error

Database error in vBulletin 3.8.0:
Invalid SQL:
  CREATE TABLE guest 
  (
   guestid varchar(32) NOT NULL default '',
   hostip varchar(15) NOT NULL default '',
   useragent varchar(100) NOT NULL default '',
   lastactive int(10) unsigned NOT NULL default 0,
   spider varchar(32) NOT NULL default '',
   script varchar(20) NOT NULL default '',
   rdata text NOT NULL, 
   PRIMARY KEY (guestid),
   KEY ipaddress (ipaddress), 
   KEY lastactive (lastactive) 
  );
MySQL Error   : Key column 'ipaddress' doesn't exist in table
Error Number  : 1072
Request Date  : Friday, January 9th 2009 @ 04:31:44 PM
Error Date    : Friday, January 9th 2009 @ 04:31:44 PM
Script        : http://www.socialspace.co.uk/forum/a...=productimport
Referrer      : http://www.socialspace.co.uk/forum/a...?do=productadd
IP Address    : 
Username      : Snowy
Classname     : vB_Database
MySQL Version : 4.1.22-standard-log