[craig2k7]

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:

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?

[shabbir]

Do you have any mods / hacks installed.

[craig2k7]

a do now... but when first installed board a didnt and it was the same

[shabbir]

Run the following query.

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.

[craig2k7]

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

[shabbir]

This table should exist. As you have a prefix use the following. phpbb_search as table name.

ALTER TABLE <vbsearch TABLENAME = phpbb_search> ADD COLUMN `completed` smallint(5) unsigned NOT NULL default '1';

[shabbir]

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

ALTER TABLE phpbb_search ADD COLUMN `completed` smallint(5) unsigned NOT NULL default '1';