![]() |
php query help
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 |
*moved to correct forum*
[sql]ALTER TABLE `vbulletin_thread` DROP `threaddesc`[/sql] 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 :) |
THIS IS ERROR I GET>
HTML Code:
Invalid SQL: thanks |
PHP Code:
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. [sql] $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) "); [/sql] |
can you tell me how i should go about fixing it?
|
what file are you getting the error from?
|
newthread.php is the php script
|
do you want to have a look at my file?
|
Remove the original changes you made to the file or upload a fresh one :)
|
did that still got errors
|
All times are GMT. The time now is 12:14 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|