[inciarco]

Hello Atakan KOC!! :up:

I'm trying to Activate this Great Hack in My Forums, but when I try to see a Thread in the Forum I've designated to have this Functionality (Chief Post Show first post on every thread page? as Yes) I'm receiving an Error.

Also when I try to create a New Thread in the Forum where I've Chosen to Activate this Hack, the Create New Thead Form appears with the Four New Options (postbit Article, Flipped, Normal, and Legacy), but when I create the Thread, I receive the same Error when the Forum try to show it to me!!

What should I do to use this Hack?? What Should I Change?? Do I Have To Edit a Template??

Thank You For Your Help!!

I'm copying the Error Message:

Forum: http://inciarco.com/foros/forumdisplay.php?f=85
Thread: http://inciarco.com/foros/showthread.php?t=1909

Database error 
The INCIARCO - FOROS - Comunidades Virtuales de Integraci?n database has encountered a problem. 

--------------------------------------------------------------------------------
 
Please try the following: 
Load the page again by clicking the Refresh button in your web browser. 
Open the inciarco.com home page, then try to open another page. 
Click the Back button to try another link. 
 
The inciarco.com forum technical staff have been notified of the error, though you may contact them if the problem persists. 
 
We apologise for any inconvenience. 


Database error in vBulletin 3.6.7:

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,
			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,
			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(SUM(photoplog_fileuploads.moderate) > 0 AND 1 = 0,COUNT(photoplog_fileuploads.moderate) - SUM(photoplog_fileuploads.moderate),COUNT(photoplog_fileuploads.moderate)) AS photoplog_filecount
		FROM vb_post AS post
		LEFT JOIN vb_user AS user ON(user.userid = post.userid)
		LEFT JOIN vb_userfield AS userfield ON(userfield.userid = user.userid)
		LEFT JOIN vb_usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
		LEFT JOIN vb_icon AS icon ON(icon.iconid = post.iconid)
		LEFT JOIN vb_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON(customavatar.userid = user.userid)
			LEFT JOIN vb_deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND deletionlog.type = 'post')
		LEFT JOIN vb_editlog AS editlog ON(editlog.postid = post.postid)
		LEFT JOIN vb_postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 3 AND postparsed.languageid = 2)
		LEFT JOIN vb_sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 3 AND sigparsed.languageid = 2)
		LEFT JOIN vb_sigpic AS sigpic ON(sigpic.userid = post.userid)
			LEFT JOIN photoplog_fileuploads AS photoplog_fileuploads ON(photoplog_fileuploads.userid = user.userid)
		WHERE post.postid IN (0,8415,8415)
		ORDER BY post.dateline;

MySQL Error  : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Error Number : 1140
Date         : Tuesday, September 25th 2007 @ 05:12:30 PM
Script       : http://zzz/showthread.php?t=1909
Referrer     : http://zzz/forumdisplay.php?f=85
IP Address   : zzz.zzz.zzz.zzz
Username     : zzz
Classname    : vb_database