vb.org Archive - Major Additions - PhotoPlog: The Lite Gallery

I'd like to share with You an Incompatibility of this Hack with the Hack "Chief First Post - Every Page - 3.6.x" (https://vborg.vbsupport.ru/showthread.php?t=156141); perhaps the Error is on that Hack or in this Hack; I copy/paste the Error Message so that You Could Analyze it and have the necessary Information to Solve that Incompatibility:

:confused: Could you please tell me what can I do to be able to Use both Hacks Together without getting the Error Message I'm Receiving?? :confused:

(I've currently Uninstalled the "Chief First Post - Every Page - 3.6.x" Hack in my Forums, but I hope to be able to use it along with this Hack "PhotoPlog: The Lite Gallery"). :(

I appreciate Your Special Help!! ;)

I copy/paste one of the Messages I've written in the Thread of the Hack "Chief First Post - Every Page - 3.6.x" (https://vborg.vbsupport.ru/showthread.php?t=156141), where I try to tell them about the presence of the Error so that They can Analize it too:

Quote:

Originally Posted by inciarco (Post 1348936)

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!! :confused:

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/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.04966 seconds Memory Usage 1,769KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_code_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (5)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: