Trying To Search

craig2k7's Avatar, Join Date: Apr 2007
Newbie Member
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?
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Do you have any mods / hacks installed.
0
craig2k7's Avatar, Join Date: Apr 2007
Newbie Member
a do now... but when first installed board a didnt and it was the same
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
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.
0
craig2k7's Avatar, Join Date: Apr 2007
Newbie Member
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
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
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';
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
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';