I get database error everytime when someone search, Click on New Post, Quick links.
This is the error-
Database error in vBulletin 3.6.4:
Invalid SQL:
SELECT searchid FROM search AS search WHERE userid = 1 AND searchhash = 'fda6ebd683b75aabcd5157ba69dd5ace' AND orderedids = '97,109,108,107,106,105,104,103,102,101,100,99,98, 96,95,94' AND announceids = '' AND completed = 1;
MySQL Error : Unknown column 'completed' in 'where clause'
Error Number : 1054

Please tell me how to solve it, i need to solve this urgently.
Thanksss

MySQL Error : Unknown column 'completed'

add that column

__________________

but how to add column. I have never done this before.
Please reply

go into phpmyadmin, then go into table search, then add completed with values of smallint(5), unsigned, not null, default 1

__________________

I have pretty much the same problem but as cool999 said, you lost me after "go into phpmyadmin, then go into table search" :p

can you give it to us in "an idiots guide to.." format please

do u even have phpmyadmin

__________________

I was hoping for something slightly more constructive than that......
....I didn't think it was possible to run vbulletin without php...

its not but its possiable to run it without phpmyadmin

__________________

well thanks for all your instructive assistance with that one, i'll move on.....................

1) goto phpmyadmin
2) click ur database
3) click table search
4) add new field with valuse i said above

__________________