View Single Post
  #395  
Old 03-19-2010, 06:46 AM
basilrath's Avatar
basilrath basilrath is offline
 
Join Date: Apr 2006
Posts: 741
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i have a guest database error too ............ although other than this its working fine

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  
FridayMarch 19th 2010 03:28:23 AM
Error Date    
FridayMarch 19th 2010 03:28:24 AM
Script        
http://www.tabletennistalk.co.uk/forum/forumdisplay.php?f=71
Referrer      
IP Address    66.235.116.43
Username      
Unregistered
Classname     
vB_Database
MySQL Version 



Is there any chance of pulling latest classified too?
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01755 seconds
  • Memory Usage 1,787KB
  • 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