Cant get search working - DB error

[aceofspades]

Hi,

I fixed one database error with your help, now I have one final one I need help with.

Database error in vBulletin 3.6.2:

Invalid SQL:

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

MySQL Error : Unknown column 'completed' in 'where clause'
Error Number : 1054
Date : Monday, July 13th 2009 @ 08:42:50 PM
Script : http://xxx/forums/search.php?do=process
Referrer : http://xxx/forums/search.php
IP Address : xxx
Username : xxx
Classname : vB_Database

Can anyone help me to understand why this is happening? I was able to fix the last database error by running a query found on this forum that created a missing table. Can i do the same with this one?

[Steve Machol]

Try adding that field with this query:

ALTER TABLE search ADD completed SMALLINT UNSIGNED NOT NULL DEFAULT '1';

[aceofspades]

Worked perfectly, thank you.