Search error

[TonyB]

I get this error when anyone does a search:

Database error in vBulletin 3.6.5:

Invalid SQL:

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

MySQL Error : Unknown column 'completed' in 'where clause'
Error Number : 1054
Date : Wednesday, March 14th 2007 @ 11:13:16 AM
Script : http://xxxxxxxxxxxx.com/forums/search.php
Referrer : http://xxxxxxxxxxxx.com/forums/index.php
IP Address : xxx.xxx.xxx.xxx
Username : TonyB
Classname : vB_Database


What does this mean and could some one help by telling me how to correct this. Sorry if I am in-experienced in php but just learning all I can. Thanks

[Marco van Herwaarden]

Run this query:

[sql]ALTER TABLE search ADD completed SMALLINT UNSIGNED NOT NULL DEFAULT '1';[/sql]

[TonyB]

0 match(es) inside table search

Sorry, ran inside vb and corrected problem. Thanks for such a quick reply and the very badly needed help.