search problem

[AlShammari]

hello
I have a problem when somebody try to search
-------------
Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT * FROM search AS search
WHERE searchhash = '7197cb5f14bc86658707effc39055416'
AND userid = 1
AND completed = 1;

MySQL Error : Unknown column 'completed' in 'where clause'
Error Number : 1054
Date : Tuesday, January 22nd 2008 @ 09:46:10 PM
Script : http://localhost/forum/search.php?do=process
Referrer : http://localhost/forum/search.php
IP Address : 168.187.11.130
Username : admin
Classname : vB_Database

[Marco van Herwaarden]

Did you do any recent maintenance? Upgraded your board?

[AlShammari]

Did you do any recent maintenance? Upgraded your board?
yes dear I upgrade it

[Marco van Herwaarden]

From which version?
Did you run upgrade.php, and did it run without problems?

In order to solve your problem, please run the following query:

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

[AlShammari]

from 3.6.5 to 3.6.8

[Marco van Herwaarden]

Then executing the query in post #4 should solve your issue.

[AlShammari]

thanks alot dear

now it is work very well

I just run ALTER TABLE search ADD COLUMN completed smallint(5) unsigned NOT NULL default '1';