View Single Post
  #1  
Old 01-30-2010, 11:10 AM
MAORBARI MAORBARI is offline
 
Join Date: Sep 2008
Posts: 110
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default External.php Database Error

PHP Code:
Database error in vBulletin 3.8.3:

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(181,351,352,353,361,339,332,360,307,19,246,53,14,119,250,354,357,358,257,338,397,394,120,121,122,123,124,125,168,126,127,128,129,130,131,132,133,252,260,299,134,135,136,137,365,366,367,368,369,370,,168,84)
                            
ORDER BY lastpost DESC 
                            LIMIT 0
5;

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 '168,84)
                            ORDER BY lastpost DESC 
                            LIMIT 0, 5' 
at line 9
Error Number  
1064
Request Date  
SaturdayJanuary 30th 2010 03:03:28 PM
Error Date    
SaturdayJanuary 30th 2010 03:03:28 PM
Script        
external.php?type=RSS2&forumids=395
Referrer      

IP Address    : *******
Username      : &#1488;ורח
Classname     vB_Database 
why is it happen?
how to resolve it?
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01430 seconds
  • Memory Usage 1,805KB
  • 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