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)

Yellow-06-GT 05-22-2008 10:00 PM

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?

Doctor Death 05-23-2008 08:54 AM

Quote:

Originally Posted by Total666 (Post 1489105)
I get this error sometimes in the forum .. Ideas ??

Database error in vBulletin 3.6.9:

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(4,8,3,5,164,151,152,204,205,622,644,6,7,11,12,1 67,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 syntax; check 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 : Saturday, April 12th 2008 @ 11:11:39 AM

My board does this exact thing too.... I never traced it to BOT activity.

bitbender 05-27-2008 03:08 PM

Can any one shed some light as to why the Java effects are lost in 3.7?

I'd really like to use this mod, and before tearing it apart to see what's up, I'd thought I'd ask again...

It displays the new post lines properly, but they are all there in a list, not one at a time as the xample shows...

bitbender 06-04-2008 04:24 PM

Well, I am going to uninstall this mod, there seems to be no support for it. Pity, too.. it was the nicest fader....

orok 07-05-2008 03:52 PM

Quote:

Originally Posted by orok (Post 1435947)
Hello Mr. Almotamyz,
i found error that when you go to an deleted thread or deleted forum link you will have Data base error , deactive the product all things work agin .. i insert replay in your forum :

http://www.almotmaiz.net/vb/showthread.php?t=13323

thank you

Alslam Alikom
no Updates ?

Yellow-06-GT 07-05-2008 04:44 PM

Quote:

Originally Posted by Doctor Death (Post 1528750)
My board does this exact thing too.... I never traced it to BOT activity.

I am guessing it is bot activity because users would not never go to a deleted forum since there is nothing for them to clik on. Also, all the errors have been traced to only "GUEST" users which are usaly bots.

I still have the problem, but just live with it. I see others are having the problem too.

aisais 07-13-2008 01:45 PM

Quote:

Originally Posted by Doctor Death (Post 1528750)
My board does this exact thing too.... I never traced it to BOT activity.

Me too. I had to uninstall it.

aisais 07-13-2008 06:14 PM

I helped myself with this:
https://vborg.vbsupport.ru/showthread.php?t=185223

It works fine with 3.7.2 pl1

Alpha14 07-15-2008 02:11 PM

Hi,

Have installed this update and now get the following error when trying to access my forum

Fatal error: Call to undefined function nlp_iconinfo() in /home/alphabravo/public_html/forum/global.php(591) : eval()'d code on line 175

Please could you advise. When I de-activate the mod then forum works normally again.

Thanks
Alex:confused:

mystic10 07-15-2008 04:03 PM

will u be updating it for 3.7 and higher...thanks in advance


All times are GMT. The time now is 01:08 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.01365 seconds
  • Memory Usage 1,776KB
  • 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
  • (4)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