Thread: Statistics Modifications - VSa - Advanced Forum Statistics (AJAX)
View Single Post
  #266  
Old 03-20-2010, 08:44 AM
basilrath's Avatar
basilrath basilrath is offline
 
Join Date: Apr 2006
Posts: 741
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Still keep getting this a times any ideas .............

PHP Code:
Database error in vBulletin 4.0.2:

Invalid SQL:

SELECT thread.threadidthread.titlethread.lastpostthread.forumidthread.replycountthread.postusernamethread.postuseridthread.lastposterthread.lastposteridthread.datelinethread.viewsthread.visiblethread.openuser.usergroupiduser.displaygroupid 
FROM thread 
AS thread
LEFT JOIN user 
AS user ON (user.userid thread.lastposterid)
WHERE NOT ISNULL(thread.threadid) AND thread.visible '1' AND thread.open!='10'  AND thread.forumid NOT IN(229,72,28,58,74,225,224,227,228,)
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 ')
ORDER BY lastpost DESC
LIMIT 0, 10' 
at line 4
Error Number  
1064
Request Date  
SaturdayMarch 20th 2010 07:00:27 AM
Error Date    
SaturdayMarch 20th 2010 07:00:27 AM
Script        
http://tabletennistalk.co.uk/forum/forumdisplay.php?f=45
Referrer      http://tabletennistalk.co.uk/forum/info.php?do=sitemap
IP Address    82.94.176.142
Username      
Unregistered
Classname     
vB_Database
MySQL Version 

Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01067 seconds
  • Memory Usage 1,788KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete