Log in

View Full Version : Thread Description Hack Mysql/Error Help Reversal


lancepoint
11-19-2004, 07:24 AM
i installed thread description hack where it displays a box in newpost and editpost templates and adds a row to the database with this info
This is what i used to add it ...
ALTER TABLE `vbulletin_thread` ADD `threaddesc` VARCHAR( 125 ) NOT NULL;

i need to remove threaddesc out of a table vbulletin_thread


THIS IS ERROR I GET>


Invalid SQL:
INSERT INTO vbulletin_thread(title, lastpost, forumid, open, replycount, postusername, postuserid, lastposter, dateline,
iconid, visible, attach, similar, threaddesc)
VALUES
('THREAD TEST ETEST', 1100856269, 32,
1, 0, 'DesignerBeat', 1,
'DesignerBeat', 1100856269, 0, 1,
0, '', '', 0)

mysql error: Column count doesn't match value count at row 1

mysql error number: 1136


please respond with the full query command. Its The newest mysql version on unix based system.

thanks

lancepoint
11-19-2004, 07:33 AM
i also use phpflashmyadmin to remove the value from the table ... then all of the forum didnt display at all.