mysql issue with search feature
 

please let me know why im getting this error please i just upgraded a forum and now cant see why its coming up


Database error in vBulletin 3.6.5:

Invalid SQL:
SELECT searchid FROM vBsearch AS search WHERE userid = 23 AND searchhash = '64534ee4c81dd3739dc498192013c091' AND orderedids = '32,30' AND announceids = '' AND completed = 1;

MySQL Error : Unknown column 'completed' in 'where clause'
Error Number : 1054
Date : Wednesday, March 21st 2007 @ 03:18:53 AM
Script : http://www.prosportsnow.com/search.php?do=getnew
Referrer : http://www.prosportsnow.com/
IP Address : 0000000000
Username : Steve
Classname : vB_Database

To fix this please run the following query:

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

thank you worked like a charm.