I dontknow what kin of problem is this, im total dummie in this whole database error and stuff. But please can anyone help me. I have this error message whem I'm and anybody else trying to search on my forum: Database error in vBulletin 3.6.4: Invalid SQL: SELECT * FROM search AS search WHERE searchhash = 'f811323ed990aaf7fcfd2d0488a98e53' AND userid = 1 AND completed = 1; MySQL Error : Unknown column 'completed' in 'where clause' Error Number : 1054 Date : Thursday, July 19th 2007 @ 01:11:04 AM Script : http://onlinemovieforum.com/search.php?do=process Referrer : http://onlinemovieforum.com/index.php IP Address : 212.7.31.96 Username : Loonm Classname : vB_Database Code (markup): or check by yourself, here is the link : http://onlinemovieforum.com try search enything. Thanks !!!
Check with vbulletin. It may need to be upgraded. I heard there was an issue with v3.6 Current version is 3.6.7 PL1
I dont think there is alot of forums that are 3.6.4. Could this problem be caused by bad hosting (old mysql version or something i dont know) ?
Ok to me it looks like the SQL is either older or newer than the script files. Have you tried updating recently?
try going to admincp->maintenance->repair/optimize tables and select all then click run. If that doesnt help then when you run the repair it should tell you after if you have any older script files.