The Arcive of Official vBulletin Modifications Site.

#1 12-07-2006, 10:33 AM

Can anybody tell me how can I make that the first post can remain in every page of the thread.. I try this one https://vborg.vbsupport.ru/showthrea...ght=first+post
but only a custom usergroup doesn't see that i dont know why... all the others can see so any possibility

i had this error in fact:

Code:

Database error in vBulletin 3.6.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,
			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 post AS post
		LEFT JOIN user AS user ON(user.userid = post.userid)
		LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
		LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
		LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
		LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
			LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND deletionlog.type = 'post')
		LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
		LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 13 AND postparsed.languageid = 2)
		LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 13 AND sigparsed.languageid = 2)
		LEFT JOIN 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,279296,279174,279135,279095,279077,279030,279028,279028)
		ORDER BY post.dateline DESC;

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         : Wednesday, December 6th 2006 @ 11:42:31 AM
Script       : http://f********
Referrer     : http://*******
IP Address   : 82.53.131.163
Username     : L'Ingegnere
Classname    : vb_database

Thank you very much

inciarco · #2 10-22-2007, 06:13 AM

I received a Similar Error, and it looks like an Incompatibility with the PhotoPlog Hack!!

I've been trying to Ask for Help from the Developers of the Hacks "Chief First Post - Every Page - 3.6.x" (https://vborg.vbsupport.ru/showthread.php?t=156141) and "PhotoPlog: The Lite Gallery" (https://vborg.vbsupport.ru/showthread.php?t=101368), but None of Them have Provided me with a Solution!!

:down:

I Copy/Paste One of My Messages; I Hope Someone Could Provide Us Some Light In The Right Way to Be Able to Use the First Post on Every Page Hack without Getting That Error!!

:erm:

My Best Regards!!

Quote:

Originally Posted by yoyoyoyo

any idea what is causing this error or how to fix it?

https://vborg.vbsupport.ru/showpost....4&postcount=84

I've Got the Same Error and Haven't Gotten Any Anwer From The Creator of This Hack!!

I've Provided Many information Regarding That Error, also the Code Line that Causes It, and The Creator of This Hack Haven't Even Analyze it and Provided a Way To Correct it!!

Check My Posts in this Thread and You'll Verify what I'm talking about!!

In my Forum this Hack only Works when I Disable the PhotoPlog Lite Hack, because there's a Code Line in the Query I refer in the following Quotings that Work Wrong when The Chief First Post is Activated for a Forum, and the Error You Refer in Your Message Only Gets Triggered in Those Forums with the Chief First Post set to "Yes", and Happens when Trying to See a Thread inside those Forums!!

I've Even Activated the Hack for a Specific Forum so that the Developer of this Hack could see that Error Happening, but Haven't Provided a way to Correct that Query that This Hack Alters in NON Compatibility with the PhotoPlog Lite Hack; perhaps in your case there's a Similar Incompatibility in a SQL QUERY with a Hack you've Installed in your Forums; the Only Way to Analyze that is by Providing the Error Query Message that the VBulletin Forum Displays for Administrators of the Forums, in your case in your Forums!!

I Hope He Corrects that Error, because Now We're Two (2) Users Unable to Use this Hack Because of that Error in a QUERY!!

Atakan Please Tell Us What To Do!! How Do We Correct That QUERY Error??

Quote:

Originally Posted by inciarco

It seems like an Error Caused for Not Compatibility with the Hack PhotoPlog Lite Gallery!!

Thread: PhotoPlog: The Lite Gallery
https://vborg.vbsupport.ru/showthread.php?t=101368

http://www.photoplog.com/forum/forumdisplay.php?f=5

When I Disable the PhotoPlog Lite Hack in the Forum, Your Hack Works but I Receive The Error Message, repeated Several Times:

I Hope You Can Correct that Not Compatibility with the PhotoPlog Lite Gallery, I think is Related with the Code I've referred in my Previous Messages!!

For Now, I'll Not Use This Hack Because Causes Conflict with the Hack PhotoPlog Lite Gallery!! (I'm Very Sad, Because I'd have Liked to be able to Use this Hack in my Forums, to have the Similar Behavior like the VBulletin.Org Site where the First Post is shown in all the Pages of a Thread)

My Best regards!!

Quote:

Originally Posted by inciarco

Any Idea in How To Correct the Incompatibility of this Hack with the Hack "PhotoPlog: The Lite Gallery" (https://vborg.vbsupport.ru/showthread.php?t=101368)??

I Hope You Can Help Me To Be Able To Use Both Hacks Together!!

Copy/Paste of one of the Messages I've written in this Thread where I try to tell you about the presence of the Error so that You can Analize it and Solve This Problem:

Quote:

Originally Posted by inciarco

The only way for the Hack to Work is by Disabling the Photoplog Hack in my Forum, that's why I deduced that some Incompatibility is Happening, also by the Error Message and the piece of code that says "COUNT(photoplog_fileuploads.moderate) - SUM(photoplog_fileuploads.moderate),COUNT(photoplo g_fileuploads.moderate)) AS photoplog_filecount" that includes "COUNT" and is related with Photoplog; but this Error only happens when the Chief First Post Hack is Activated and set to Yes in a Forum, so something isn't working, at least in Version 3.6.7 PL1; I hope you could analyze the Error and Orient me in what should I check/change/set for this Hack to work Ok in my Forums!!

I appreciate your Help and your Patience!!

My Best Regards!!

I copy/paste again the Error Message for you to Analyze it:

Code:

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/foros/forumdisplay.php?f=85
IP Address   : zzz.zzz.zzz.zzz
Username     : zzz
Classname    : vb_database

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03726 seconds Memory Usage 2,199KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (2)bbcode_code (4)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (2)post_thanks_box (2)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (2)post_thanks_postbit_info (2)postbit (1)postbit_onlinestatus (2)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start postbit_imicons tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!