Database Error when searching

[jasculs]

I am getting this error when I do a search. This is after upgrading form 3.6.7 to 3.7 rc1

Database error in vBulletin 3.7.0 Release Candidate 1:

Invalid SQL:

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

MySQL Error : Unknown column 'completed' in 'where clause'
Error Number : 1054
Date : Friday, March 21st 2008 @ 02:53:05 PM
Script : http://www.grapplersguide.com/forums/search.php?do=process
Referrer : http://www.grapplersguide.com/forums/search.php?do=process
IP Address : xxxxxx
Username : xxxxxx
Classname : vb_database
MySQL Version : 4.1.22-standardThanks for any help

[Jose Amaral Rego]

I did not see this column 'completed' in version 3.7.0 Beta 5 and it may not be something that is for 3.7.0 RC 1

Try disabling your modification:

To temporarily disable the plugin system, edit config.php and add this line right under <?php
define('DISABLE_HOOKS', true);



If that doesn't work try to re-upload your unmodified files and run
Maintenance > Diagnostics > Suspect File Versions Test.

[jasculs]

Thanks for the reply...I already disabled all of my plugins using the method you mentioned but that didn't work.

Also I only get the error when it tries to bring up an actual search result. If I put in a search term that I know isn't there then it doesn't give me the database error.

[Jose Amaral Rego]

Wait till staff says this query is safe to run on your site.
http://www.vbulletin.com/forum/showthread.php?t=246705

[jasculs]

Thank you...I ran that query and now everything works well.

[Jose Amaral Rego]

You ran it. :) Could not wait for answer from Staff. I was at your site and any search words were getting that error. I do not know why you were missing that column in search field.

[jasculs]

You ran it. :) Could not wait for answer from Staff. I was at your site and any search words were getting that error. I do not know why you were missing that column in search field.

lol...yeah...I couldn't wait...I was looking at the link you posted and it seemed the like the same error I was getting so I figured what the heck. I needed to get it fixed because I have paying members on my site and I didn't want them to get annoyed.