[Forum] Unknown column 'user.userid' in 'on clause'

[cloferba]

Since a few minutes ago, I´m receiving this email:

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT post.postid, post.title, post.pagetext, post.dateline, post.userid, post.visible AS postvisible,
IF(user.username <> '', user.username, post.username) AS username,
thread.threadid, thread.title AS threadtitle, thread.postuserid, thread.visible AS threadvisible,
forum.forumid, forum.password

FROM post AS post
LEFT JOIN user AS user ON (post.userid = user.userid)
INNER JOIN thread AS thread ON (post.threadid = thread.threadid)
INNER JOIN forum AS forum ON (thread.forumid = forum.forumid)

WHERE post.postid IN (750484);

MySQL Error : Unknown column 'user.userid' in 'on clause'
Error Number : 1054
Request Date : Saturday, July 7th 2012 @ 06:44:32 PM
Error Date : Saturday, July 7th 2012 @ 06:44:32 PM
Script : http://www.xxxxx.com/newreply.php?do=newreply&p=750484
Referrer :
IP Address : 65.52.108.25
Username : No registrado
Classname : vB_Database

what does it means? I have disabled all plugins through config.php but the issue still and I´m unable to enter to my forum because I´m getting a Database Error page

[Dustin L.]

On its own line in config.php after the opening PHP tag <?php, add the following code:

define('DISABLE_HOOKS', true); 

Then save the file and upload/overwrite it to your server.

Does that resolve the issue?



Dustin

[Zachery]

That is a very very bad error, do you have a recent backup? Also open a support ticket.

[Dustin L.]

Zachery's right. Sorry about that. I got confused with your thread here: https://www.vbulletin.com/forum/show...in-from-clause

Which is related to a modification.

[cloferba]

well, the database was hacked but I had a backup so this is "fixed"