Thread: Forum Display Enhancements - Kpt - LP Threads
View Single Post
  #69  
Old 05-20-2008, 07:31 PM
lazytown lazytown is offline
 
Join Date: Feb 2004
Posts: 503
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Likely Bug found:

From the forum homepage, with this mod enabled (on the left side): If a user clicks "quick links->Mark Forums Read" it generates the following mysql error..

PHP Code:
Database error in vBulletin 3.7.0:
Invalid SQL:
     
SELECT thread.threadidthread.titlethread.postusernamethread.replycountthread.lastposterthread.viewsthread.attach,icon.title AS icontitleicon.iconpath
     FROM thread 
AS thread
     LEFT JOIN icon 
AS icon ON(icon.iconid thread.iconid)
     
WHERE forumid 
     
order by views DESC
     LIMIT 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 views DESC
     LIMIT 10' 
at line 5
Error Number  
1064
Request Date  
TuesdayMay 20th 2008 01:21:45 PM
Error Date    
TuesdayMay 20th 2008 01:21:45 PM
Script        
xxx/forumdisplay.php?do=markread
Referrer      
xxx/index.php
IP Address    
XX.XX.XX.XX
Username      
XXXXX
Classname     
vB_Database
MySQL Version 
5.0.45-community 
This does not happen with the mod disabeld.

thanks
-vissa
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01069 seconds
  • Memory Usage 1,779KB
  • 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