Log in

View Full Version : Last database error!


aceofspades
07-13-2009, 06:46 PM
Hi,

I fixed one database error with your help, now I have one final one I need help with.

Database error in vBulletin 3.6.2:

Invalid SQL:

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

MySQL Error : Unknown column 'completed' in 'where clause'
Error Number : 1054
Date : Monday, July 13th 2009 @ 08:42:50 PM
Script : http://xxx/forums/search.php?do=process
Referrer : http://xxx/forums/search.php
IP Address : xxx
Username : xxx
Classname : vB_Database

Can anyone help me to understand why this is happening? I was able to fix the last database error by running a query found on this forum that created a missing table. Can i do the same with this one?

--------------- Added 1247568229 at 1247568229 ---------------

Tiny bump :confused:

Marco van Herwaarden
07-14-2009, 12:49 PM
What caused these tablews to be missing or incomplete? You should address the source of the issue and not repair individual symptoms.