ok on my Vbulletin forums ( version 3.6.4) everytime i try to search i get the following error: Database error in vBulletin 3.6.4: Code: Invalid SQL: SELECT * FROM phpbb_search AS search WHERE searchhash = '38ba5f969be6d73b59fcd65974f1ab5b' AND userid = 22 AND completed = 1; MySQL Error : Unknown column 'completed' in 'where clause' Error Number : 1054 Date : Friday, April 13th 2007 @ 06:36:06 PM Script : http://www.****.com/forums/search.php?do=process Referrer : http://www.****.com/forums/index.php IP Address : ******* Username : ***** Classname : vb_database any1 know a fix? or how i can fix this?
Run the following query. Code: ALTER TABLE vbsearch ADD COLUMN `completed` smallint(5) unsigned NOT NULL default '1'; There was an issue with the vB 3.6 I remember for an upgrade / import which I came to know when doing the cfanatic.com site.
answer from queery An error occurred while attempting to execute your query. The following information was returned. error number: 1146 error desc: Table 'web82-honcho.vbsearch' doesn't exist
This table should exist. As you have a prefix use the following. phpbb_search as table name. Code: ALTER TABLE <vbsearch TABLENAME = phpbb_search> ADD COLUMN `completed` smallint(5) unsigned NOT NULL default '1';
I have no idea what is your table name but I am assuming it should be phpbb_search and so if you read the post what to execute you will see I have mentioned what to be substituted as table name. Now try this Code: ALTER TABLE phpbb_search ADD COLUMN `completed` smallint(5) unsigned NOT NULL default '1';