vb.org Archive
Page 13 of 27 « First 31112 13 141523 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Mini Mods - Last Poster Avatar (https://vborg.vbsupport.ru/showthread.php?t=275406)

phpdesk 01-06-2012 08:53 PM
The quoted error message seems to be cut and does not include the actual note related to the error. Would it be possible to post the full error message so that I could track it down?

Either way, I have reuploaded the previous version of the mod for those of you having issues with v1.1.1.

Thanks.
Quote:
Originally Posted by bada_bing (Post 2284319)
I have uninstalled this mod because it it not working with vb 4.19 it give a database errro

HTML Code:
Database error in vBulletin 4.1.9:

Invalid SQL:

                SELECT
                        IF(votenum >= 1, votenum, 0) AS votenum,
                        IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
                post.pagetext AS preview,thread.firstpostid, post.pagetext AS thumb,
                        thread.threadid, thread.title AS threadtitle, thread.forumid, thread.pollid, thread.open, thread.postusername, thread.postuserid, thread.iconid AS threadiconid,
                        thread.dateline, thread.notes, thread.visible, thread.sticky, thread.votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
                        thread.prefixid, thread.taglist, thread.hiddencount, thread.deletedcount,
                        user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend,
                        user.lastactivity, user.lastvisit, IF(user.options & 512, 1, 0) AS invisible
                        , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
                        , deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS de

sadiq6210 01-07-2012 08:40 AM
Quote:
Originally Posted by phpdesk (Post 2284583)
The quoted error message seems to be cut and does not include the actual note related to the error. Would it be possible to post the full error message so that I could track it down?

Either way, I have reuploaded the previous version of the mod for those of you having issues with v1.1.1.

Thanks.
What about this?
https://vborg.vbsupport.ru/showpost....&postcount=115

Thanks

I.G.O.T.A. 01-08-2012 06:52 PM
Quote:
Originally Posted by Fready (Post 2284008)
Found a bug/problem.

On the Forums Home, say you have Sub-Forums, if a poster posts on a Thread in the Sub-Forum it doesn't show their av on the Forums Home, it will show the av of the last poster within the main Forum not the Sub Forum even though the last post showing on the Forums Home is from the Sub Forum.

Hope you understand what I mean.
Check it out and test it with a Forum which has a Sub Forum to it.
I have the same problem. I'm on 4.1.8

I.G.O.T.A. 01-10-2012 12:06 PM
Is there a way to fix this issue?

garybrun 01-10-2012 11:26 PM
works ok for me in 4.19a
http://Www.minelabowners.com

bada_bing 01-11-2012 02:24 AM
Quote:
Originally Posted by phpdesk (Post 2284583)
The quoted error message seems to be cut and does not include the actual note related to the error. Would it be possible to post the full error message so that I could track it down?

Either way, I have reuploaded the previous version of the mod for those of you having issues with v1.1.1.

Thanks.
That is the exact copy and past of the error message I get this this plugin enabled

goshalim 01-11-2012 05:39 AM
Hi , this is a very nice mod , good job man !!

I have only a small problem which iam sure that you will help me to solve it.
Please see the link from my web site.

The user name is shown twice and also a part of the code.

http://www.canarybreeder.net/up/forum/forum.php

chiggy 01-11-2012 04:44 PM
Hey Bro U Done Great Job Installed And Working Perfectly And Realy I Like Your Mod And Ur Work
This Modification Give My Forum Something Good Look Bcoz My All Forum Members Almost Using GIF Animated Avatars And In Home Page Its Looking Coolll Man Than You Very Much...... U R The Man
My Side +1000 For You.

bada_bing 01-11-2012 06:10 PM
Quote:
Originally Posted by phpdesk (Post 2284583)
The quoted error message seems to be cut and does not include the actual note related to the error. Would it be possible to post the full error message so that I could track it down?

Either way, I have reuploaded the previous version of the mod for those of you having issues with v1.1.1.

Thanks.
Here is the full error

HTML Code:
Database error in vBulletin 4.1.9:

Invalid SQL:

                SELECT
                        IF(votenum >= 1, votenum, 0) AS votenum,
                        IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
                post.pagetext AS preview,thread.firstpostid, post.pagetext AS thumb,
                        thread.threadid, thread.title AS threadtitle, thread.forumid, thread.pollid, thread.open, thread.postusername, thread.postuserid, thread.iconid AS threadiconid,
                        thread.dateline, thread.notes, thread.visible, thread.sticky, thread.votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
                        thread.prefixid, thread.taglist, thread.hiddencount, thread.deletedcount,
                        user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend,
                        user.lastactivity, user.lastvisit, IF(user.options & 512, 1, 0) AS invisible
                        , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
                        , deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
                       
                        , threadredirect.expires
                        ,IF(customavatar.userid, 1, 0) AS useavatar, user.avatarrevision
, user.avatarrevision AS avatarrevision, thread.lastposterid AS userid, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
                FROM thread AS thread
                        LEFT JOIN user AS user ON (user.userid = thread.lastposterid)
                        LEFT JOIN userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 1)
                        LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
                        LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
                       
                        LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
                       
                        LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
                       
LEFT JOIN customavatar AS customavatar ON (customavatar.userid = thread.postuserid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
                WHERE thread.threadid IN (0,7,1)
                ORDER BY thread.sticky DESC, lastpost DESC;

MySQL Error  : Not unique table/alias: 'customavatar'
Error Number  : 1066
Request Date  : Wednesday, January 11th 2012 @ 01:07:59 PM
Error Date    : Wednesday, January 11th 2012 @ 01:07:59 PM
Script        : http://www.mysite.com/forums/forumdisplay.php?2-mysite-com-Announcements
Referrer      : http://www.mysite.com/forums/forum.php
IP Address    : 67.59.x.x
Username      : adminaccount
Classname    : vB_Database
MySQL Version : 5.0.90-community-nt

bremereric 01-11-2012 07:22 PM
Will this hack also grab pre-defined avatars or only the one's that members have uploaded?


All times are GMT. The time now is 10:34 PM.
Page 13 of 27 « First 31112 13 141523 Last »
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.01340 seconds
  • Memory Usage 1,765KB
  • 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
  • (2)bbcode_html_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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