• OzzModz is no longer taking registrations. All registrations are being redirected to Snog's Site
    All addons and support is available there now.

DB error in 3.8.4

Max Taxable

The Wyatt Earp of Anti-Spam
I know what is causing it, just want somebody to tell me what this error is saying.

Code:
Database error in vBulletin 3.8.4:

Invalid SQL:

		SELECT
			post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
			user.*, userfield.*, usertextfield.*,
			icon.title as icontitle, icon.iconpath,
			avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
			spamlog.postid AS spamlog_postid,
			deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
			editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
			editlog.reason AS edit_reason, editlog.hashistory,
			postparsed.pagetext_html, postparsed.hasimages,
			sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
			sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
			IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
			
			, IF((SELECT COUNT(*) FROM vbhuman_spam_moderation WHERE vbhuman_spam_moderation.content_type = "post" AND vbhuman_spam_moderation.content_id = vbpost.postid) > 0 AND 1 = 0, 1, post.visible) AS visible
		FROM vbpost AS post
		LEFT JOIN vbuser AS user ON(user.userid = post.userid)
		LEFT JOIN vbuserfield AS userfield ON(userfield.userid = user.userid)
		LEFT JOIN vbusertextfield AS usertextfield ON(usertextfield.userid = user.userid)
		LEFT JOIN vbicon AS icon ON(icon.iconid = post.iconid)
		LEFT JOIN vbavatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vbcustomavatar AS customavatar ON(customavatar.userid = user.userid)
		LEFT JOIN vbspamlog AS spamlog ON(spamlog.postid = post.postid)
			LEFT JOIN vbdeletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND deletionlog.type = 'post')
		LEFT JOIN vbeditlog AS editlog ON(editlog.postid = post.postid)
		LEFT JOIN vbpostparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 2 AND postparsed.languageid = 1)
		LEFT JOIN vbsigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 2 AND sigparsed.languageid = 1)
		LEFT JOIN vbsigpic AS sigpic ON(sigpic.userid = post.userid)
			
		WHERE post.postid IN (0,19)
		ORDER BY post.dateline;

MySQL Error   : Unknown column 'vbpost.postid' in 'where clause'
Error Number  : 1054
Request Date  : Wednesday, January 1st 2014 @ 07:27:49 PM
Error Date    : Wednesday, January 1st 2014 @ 07:27:49 PM
Script        : http://mlbfanforum.com/showthread.php?p=19
Referrer      : http://mlbfanforum.com/index.php
IP Address    : 50.26.22.32
Username      : Tech
Classname     : vB_Database
MySQL Version : 5.1.67-rel14.3-log
 
That's that crazy ass Steve mod, it's very difficult to see exactly where that is coming from. But by the looks of it, it seems like it is trying to put a database prefix somewhere, vbpost.postid
 
Yes this is that Stealth Human Spam Moderation, works fine on 3.8.7 but generating this error on the 3.8.4
 
Dunno haven't looked in db. Prolly should that might be the whole issue no?

EDIT: vbpost exists yes.
 
Last edited:
Back
Top