mySQL crash : Unknown column 'completed' in 'where clause'

[NinjaX]

Hey can someone help me with this please. For some reason when users search my forums i get this sql error.

What does this error mean? how do i fix it?


everything else seems to work fine, just when someone uses the search, boom crash..

I get the same error from clicking the "quick links > today's posts" link as well.

Database error in vBulletin 3.6.8:

Invalid SQL:

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

MySQL Error : Unknown column 'completed' in 'where clause'
Error Number : 1054
Date : Friday, September 21st 2007 @ 10:40:54 PM
Script : http://purehighspeed.com/forum/search.php?do=process
Referrer : http://purehighspeed.com/forum/search.php
IP Address : 24.30.84.90
Username : xxxxxx
Classname : vb_database


:confused:

[Marco van Herwaarden]

Run the following query:

ALTER TABLE search ADD COLUMN `completed` smallint(5) unsigned NOT NULL default '1';

[NinjaX]

You are not authorized to execute SQL queries?

I'm logged in wih my super admin. it won't let me access it.

[Dismounted]

You will need to add your userid to the section in config.php where it says "Users With Query Running Permissions".

[NinjaX]

Man you guys rock. thank you so much for your help. Working 100% now. I also fixed the server info on the datastore cache config as well as running that query. Seemed to do the trick!

Thanks again!
: )