vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Miscellaneous Hacks - Advanced Last X Thread in Marquee,JavaScript with External Options 2.2 (https://vborg.vbsupport.ru/showthread.php?t=149167)

Wizardjv 08-02-2008 04:17 PM

I really love this mod but I am now having problems with it myself. Any plans on updating it to fix the problems? I would love to keep this installed.

Dingo14 08-08-2008 11:54 AM

nice mod just would like to see the usergroup display option problem solved, can't turn off who views it, also date and time displaying wrong, time displays date and vice versa, I have played around with my board settings but still does not fix problem. Other then that looks and works great

BoYagoob 09-04-2008 11:46 AM

installed .. thanks

Total666 09-06-2008 02:16 PM

I would have major mysql problems (Extreme high load ) , when I would have move that 500 members online at once with this mod , I disabled it and had 1008 members on at once without any problem the other night .. No lagging or high load ..

shofolofo 10-07-2008 06:02 AM

I tried to put some usergroups away from viewing this bar by putting their usergroup ids in the options page but doesn't work

elrwnq 01-01-2009 05:20 AM

thank you

jeefo 01-14-2009 08:09 PM

Quote:

Originally Posted by Yellow-06-GT (Post 1528398)
PHP Code:

I get this error sometimes in the forum .. Ideas ??

Database error in vBulletin 3.6.9:

Invalid SQL:

                                                        
SELECT thread.threadidthread.titlethread.lastpostthread.forumidthread.replycount
                                                        
thread.lastposterthread.datelinethread.postusernamethread.postuseridthread.iconid,
                                                        IF(
views<=replycountreplycount+1views) AS viewsthread.visiblethread.open
                                                        
user.usernameuser.useriduser.usergroupid
                                                        IF(
displaygroupid=0user.usergroupiddisplaygroupid) AS displaygroupid
                                                        FROM thread 
AS thread
                                                        LEFT JOIN user 
AS user ON (user.username thread.lastposter)
                                                        
WHERE NOT ISNULL(thread.threadid)  AND thread.visible '1' AND thread.open != '10' 
                                                        
AND thread.forumid NOT IN(4,8,3,5,164,151,152,204,205,622,644,6,7,11,12,167,172,20,,4,8,3,5,164,151,152,204,205,622,644,6,7,11,12,165,166,167,172,221,222,0)
                                                        
ORDER BY lastpost DESC 
                                                        LIMIT 0
10;

MySQL Error  You have an error in your SQL syntaxcheck the manual that corresponds to your MySQL server version for the right syntax to use near '4,8,3,5,164,151,152,204,205,622,644,6,7,11,12,165,166,167,172,221,222,0)
                                                ' 
at line 9
Error Number 
1064
Date         
SaturdayApril 12th 2008 11:11:39 AM 

I am getting this same error. It only happens if a "guest" user (web crawler) tries to access a forum that does not exist. If I am logged in and go to the same link vbulletin gives the invalid forum error as it should. If I log out and try it I get the database error and it sends me the email error message. If I disable the marquee the problem goes away. It looks to me that for some reason something is adding an extra comma in the code. In your error above there is an extra comma between the 20 and the 4.

Mine has the extra comma between two forum IDs also.

Any ideas anyone?


any coming updates ??

Dingo14 01-31-2009 02:20 AM

any chance the vBadvanced CMPS v3.0.0 could be sorted the bar shows with Last 10 posts but nothing scrolling be great if this could be sorted thanks

neto614 02-06-2009 02:38 AM

i am getting this message ... what can i do to fix it



Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount,
thread.lastposter, thread.dateline, thread.postusername, thread.postuserid, thread.iconid,
IF(views<=replycount, replycount+1, views) AS views, thread.visible, thread.open,
user.username, user.userid, user.usergroupid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM thread AS thread
LEFT JOIN user AS user ON (user.username = thread.lastposter)
WHERE NOT ISNULL(thread.threadid) AND thread.visible = '1' AND thread.open != '10'
AND thread.forumid NOT IN(1,)
ORDER BY lastpost DESC
LIMIT 0, 10;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
ORDER BY lastpost DESC
LIMIT 0, 10' at line 9
Error Number : 1064
Request Date : Thursday, February 5th 2009 @ 11:34:51 PM
Error Date : Thursday, February 5th 2009 @ 11:34:51 PM
Script : http://www.ftaccess.net/index.php
Referrer :
IP Address :
Username :
Classname :
MySQL Version :

cr-house 04-29-2009 10:58 PM

that's the best one

Best Regards
Mr.Ajax


All times are GMT. The time now is 02:56 AM.

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.01239 seconds
  • Memory Usage 1,766KB
  • 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_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)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