vb.org Archive
Page 7 of 8 « First 56 7 8
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Show Thread Enhancements - Guests First Post Only (https://vborg.vbsupport.ru/showthread.php?t=184717)

benstillman 02-03-2009 07:43 PM
I get this error when the mod is enabled:

Code:
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 02-04-2009 05:21 AM
That error does not seem to be caused by this modifications. Judging by the error, it looks like it is caused by PhotoPlog.

benstillman 02-04-2009 01:44 PM
Quote:
Originally Posted by Dismounted (Post 1733844)
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 02-04-2009 01:47 PM
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 02-27-2009 04:45 PM
Will this work on vb3.8?

Dismounted 02-28-2009 12:30 PM
Most likely.

drsli 02-28-2009 03:17 PM
Thanks for the assessment. I installed it onto my vb3.81-live-forum and as far as I can see, it works flawlessly! :)

210665 03-13-2010 05:34 PM
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 04-27-2010 11:23 AM
hi Hanson, any upgrade for the 'suite'?

Dismounted 04-29-2010 06:12 AM
Real Soon Now (tm)

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


All times are GMT. The time now is 08:24 PM.
Page 7 of 8 « First 56 7 8
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01294 seconds
  • Memory Usage 1,740KB
  • 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
  • (1)bbcode_code_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (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