View Single Post
  #1  
Old 07-12-2007, 06:35 AM
Adrian Schneider's Avatar
Adrian Schneider Adrian Schneider is offline
 
Join Date: Jul 2004
Posts: 2,528
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default DB Error When Searching

You guys are probably aware, but if not:

Code:
Database error in vBulletin 3.6.7:

Invalid SQL:

            SELECT thread.threadid
            FROM thread AS thread
            
            LEFT JOIN threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 59835)
            INNER JOIN forum AS forum ON (forum.forumid = thread.forumid)
            LEFT JOIN forumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 59835)
        
            WHERE thread.forumid IN(1, 2, 203, 94, 26, 92, 111, 15, 168, 172, 197, 173, 12, 7, 13, 14, 112, 30, 184, 219, 210, 218, 211, 187, 188, 221, 217, 189, 198, 191, 194, 192, 109, 113, 155, 32, 33, 34, 134, 3, 4, 5, 139, 99, 101, 102, 104, 105, 170, 174, 171, 182, 223, 224, 31, 202, 185, 6, 107, 106, 103, 100, 164, 212, 195, 196, 161, 162, 135, 137, 140, 141, 213, 216, 124, 123, 215, 214, 125)
                
            AND thread.lastpost > IF(threadread.readtime IS NULL, 1183361560, threadread.readtime)
            AND thread.lastpost > IF(forumread.readtime IS NULL, 1183361560, forumread.readtime)
            AND thread.lastpost > 1183361560
        
                AND thread.visible IN (0,1,2)
                AND thread.sticky IN (0,1)
                AND thread.open < 10
            ORDER BY thread.lastpost DESC
            LIMIT 500;

MySQL Error  : Table 'thread' is marked as crashed and should be repaired
Error Number : 1194
Date         : Thursday, July 12th 2007 @ 02:32:40 AM
Script       : https://vborg.vbsupport.ru/search.php?do=getnew
Referrer     : https://vborg.vbsupport.ru/
IP Address   : x.x.x.x
Username     : SirAdrian
Classname    : vB_Database
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01229 seconds
  • Memory Usage 1,767KB
  • 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_code
  • (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