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]

Originally Posted by Marco van Herwaarden

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:

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

[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';