[benstillman]

I get this error when the mod is enabled:

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,


                       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
                       , '' AS field6, '' AS field7, '' AS field8, '' AS field9, '' AS field12
                       , IF(SUM(photoplog_fileuploads.moderate) > 0 AND 0 = 0,COUNT(photoplog_fileuploads.moderate) - SUM(photoplog_fileuploads.moderate),COUNT(photoplog_fileuploads.moderate)) AS photoplog_filecount
               FROM vbb_post AS post
               LEFT JOIN vbb_user AS user ON(user.userid = post.userid)
               LEFT JOIN vbb_userfield AS userfield ON(userfield.userid = user.userid)
               LEFT JOIN vbb_usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
               LEFT JOIN vbb_icon AS icon ON(icon.iconid = post.iconid)
               LEFT JOIN vbb_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vbb_customavatar AS customavatar ON(customavatar.userid = user.userid)


               LEFT JOIN vbb_editlog AS editlog ON(editlog.postid = post.postid)
               LEFT JOIN vbb_postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 5 AND postparsed.languageid = 1)
               LEFT JOIN vbb_sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 5 AND sigparsed.languageid = 1)
               LEFT JOIN vbb_sigpic AS sigpic ON(sigpic.userid = post.userid)
                       LEFT JOIN photoplog_fileuploads AS photoplog_fileuploads ON(photoplog_fileuploads.userid = user.userid)
               WHERE post.postid = 134199
               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

I used this mod on 3.6 and loved it. Haven't been able to get it working on 3.7. I've removed the template edits, removed the xml file, etc. No avail. Anybody have a clue what's going on?