[mll]

Originally Posted by Elite_360_

Whats the error?

Get the following error (while creating new blog post or post blog comment):

Database error
The Forums database has encountered a problem.

Database error in vBulletin 4.2.2:

Invalid SQL:

			SELECT blog.blogid, lastblogtextid AS blogtextid, blog_text.userid, blog_text.state, IF(blog_text.userid = 0, blog_text.username, user.username) AS username, blog.blogid, blog.title
			,avatar.avatarpath, user.avatarrevision, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
			, user.e360_prefix, user.e360_font, IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid
			FROM vb4blog AS blog
			LEFT JOIN vb4blog_text AS blog_text ON (blog.lastblogtextid = blog_text.blogtextid)
			LEFT JOIN vb4user AS user ON (blog_text.userid = user.userid)
			INNER JOIN vb4user AS user2 ON (blog.userid = user2.userid)
			LEFT JOIN vb4avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb4customavatar AS customavatar ON(customavatar.userid = user.userid)
			
			
			WHERE blog.userid = 1 AND blog_text.blogtextid <> blog.firstblogtextid AND blog_text.state IN ('visible','moderation') AND blog.state IN ('visible','moderation') AND blog.dateline <= 1428276958 AND blog.pending = 0
			
			ORDER BY blog.lastcomment DESC
			LIMIT 5;

MySQL Error   : Column 'infractiongroupid' in field list is ambiguous
Error Number  : 1052
Request Date  : Monday, April 6th 2015 @ 07:35:58 AM
Error Date    : Monday, April 6th 2015 @ 07:35:59 AM
Script        : http://........../vb4/blog_post.php?do=newblog
Referrer      : http://.........../vb4/blog.php
IP Address    : .............
Username      : admin
Classname     : vB_Database_MySQLi
MySQL Version : 5.6.23-72.1-log

Edit: all normal after disabling.