[sabret00the]

Originally Posted by jilly

Okay, i tried this, and got this error message:

Database error in vBulletin 3.0.7:

Invalid SQL:
INSERT INTO thread_bank(title, lastpost, forumid, open, replycount, postusername, postuserid, lastposter, dateline, visible, sticky)
VALUES ('Who is your favorite Family Guy Character?', NULL, 34, 1, 0, 'ThreadBot', 224, 'ThreadBot', NULL, 1, 0)

mysql error: Table 'bmww.thread_bank' doesn't exist

mysql error number: 1146

Date: Saturday 14th of May 2005 05:32:39 PM
Script: http://www.bmww.org/forums/feed_threadBOT.php
Referer: http://www.bmww.org/forums/feed_threadBOT.php
Username: jilly

ok that's a problem with the queries, run these two in phpmyadmin

[sql]CREATE TABLE `thread_bank` (
`threadid` int(10) unsigned NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`lastpost` int(10) unsigned NULL default '0',
`forumid` smallint(5) unsigned NOT NULL default '0',
`pollid` int(10) unsigned NOT NULL default '0',
`open` tinyint(4) NOT NULL default '0',
`replycount` int(10) unsigned NOT NULL default '0',
`postusername` varchar(50) NOT NULL default '',
`postuserid` int(10) unsigned NOT NULL default '0',
`lastposter` varchar(50) NOT NULL default '',
`dateline` int(10) unsigned NULL default '0',
`views` int(10) unsigned NOT NULL default '0',
`iconid` smallint(5) unsigned NOT NULL default '0',
`notes` varchar(250) NOT NULL default '',
`visible` smallint(6) NOT NULL default '0',
`sticky` smallint(6) NOT NULL default '0',
`votenum` smallint(5) unsigned NOT NULL default '0',
`votetotal` smallint(5) unsigned NOT NULL default '0',
`attach` smallint(5) unsigned NOT NULL default '0',
`firstpostid` int(10) unsigned NOT NULL default '0',
`similar` varchar(55) NOT NULL default '',
PRIMARY KEY (`threadid`),
KEY `iconid` (`iconid`),
KEY `forumid` (`forumid`,`visible`,`sticky`,`lastpost`),
KEY `postuserid` (`postuserid`),
KEY `pollid` (`pollid`),
FULLTEXT KEY `title` (`title`)
);[/sql]

and

[sql]
CREATE TABLE `post_bank` (
`postid` int(10) unsigned NOT NULL auto_increment,
`threadid` int(10) unsigned NOT NULL default '0',
`username` varchar(50) NOT NULL default '',
`userid` int(10) unsigned NOT NULL default '0',
`title` varchar(250) NOT NULL default '',
`dateline` int(10) unsigned NULL default '0',
`pagetext` mediumtext NOT NULL,
`allowsmilie` smallint(6) NOT NULL default '0',
`showsignature` smallint(6) NOT NULL default '0',
`ipaddress` varchar(16) NOT NULL default '',
`iconid` smallint(5) unsigned NOT NULL default '0',
`visible` smallint(6) NOT NULL default '0',
`parentid` int(10) unsigned NOT NULL default '0',
`attach` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`postid`),
KEY `iconid` (`iconid`),
KEY `userid` (`userid`),
KEY `threadid` (`threadid`,`userid`),
FULLTEXT KEY `title` (`title`,`pagetext`)
);[/sql]