Show Thread Enhancements - Guests First Post Only

Guests First Post Only

Description:
This mod only shows the first post of a thread to guests. After it displays the first post, it then displays a message telling the guest to login or register.

Installation:
All the installation information is in the package.

Changes:
2 Templates
12 Plugins
4 Phrases

Other Versions:
Guests First Post Only for 3.6 - https://vborg.vbsupport.ru/showthread.php?t=135016

[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?

[Dismounted]

That error does not seem to be caused by this modifications. Judging by the error, it looks like it is caused by PhotoPlog.

[benstillman]

Originally Posted by Dismounted

That error does not seem to be caused by this modifications. Judging by the error, it looks like it is caused by PhotoPlog.

Odd that photoplog is (and has been for a while) disabled. This error only occurs when I enable this mod. As soon as I disable it, the error goes ago. Also, the error only appears for guests. For logged in users the page loads fine without error.

[benstillman]

Weird as hell.....

I went ahead and tried it again just now and it worked. I'll keep an eye on it and see if it happens again. Weird.

[drsli]

Will this work on vb3.8?

[Dismounted]

Most likely.

[drsli]

Thanks for the assessment. I installed it onto my vb3.81-live-forum and as far as I can see, it works flawlessly!

[210665]

Hello

There is also this addon for vb 4.02 or there is nothing planned.
Would something like looking for my board, maybe you can help me.
Thanks

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxxx

hallo

gibt es dieses addon auch für das vb 4.02 oder ist da nichts geplant.
Würde so etwas suchen für mein Board, vielleicht könnt ihr mir weiterhelfen.

Danke

[KURTZ]

hi Hanson, any upgrade for the 'suite'?

[Dismounted]

Real Soon Now (tm)

At least I hope I can do it in that timeframe...