php query help

[lancepoint]

i need to remove threaddesc out of a table vbulletin_thread
This is what i used to add it ...


ALTER TABLE `vbulletin_thread` ADD `threaddesc` VARCHAR( 125 ) NOT NULL;

Now, no posts can be made because of the table has that extra row... Please help me. It should be something simple like remove from or delete from .. please respond with the full query command. Its The newest mysql version on unix based system.

thanks

[Xenon]

*moved to correct forum*

ALTER TABLE `vbulletin_thread` DROP `threaddesc`

nevertheless vb does not have a problem when there are more fields at the threadtable.
we have more than one field added, and everything works as it should :)

[lancepoint]

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


thanks

[Logikos]

Column count doesn't match value count at row 1

That means the selected feilds in the query don't coun't up to the values. You have 14 feilds to insert into, and there are 15 values there. You either added one to many values into your query, or you missed a feild to insert into.

Here an example query, notice there are 5 feilds to insert into, and the values for all 5 feilds, you can't have 6 feilds and 5 values, or 6 vaules and 5 feilds, it all has to match in the order its being inserted into.


$DB_site->query("
INSERT INTO " . TABLE_PREFIX . " TABLE_NAME
(feild_1, feild_2, feild_3, feild_4, feild_5)
VALUES
(value_for_feild_1, value_for_feild_2, value_for_feild_3, value_for_feild_4, value_for_feild_5)
");

[lancepoint]

can you tell me how i should go about fixing it?

[Logikos]

what file are you getting the error from?

[lancepoint]

newthread.php is the php script

[lancepoint]

do you want to have a look at my file?

[Dean C]

Remove the original changes you made to the file or upload a fresh one :)

[lancepoint]

did that still got errors

[Serge]

Is it the same error or a different one?

If it is the same error then you don't have a fresh copy on your computer and you need to redownload vBulletin and then upload the copy of newthread.php from the zip you just downloaded and everything should work fine.

[Logikos]

Or its one of the include files with the error.