Go Back   vb.org Archive > Community Discussions > Forum and Server Management
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 05-04-2010, 02:17 PM
MaluNYMets MaluNYMets is offline
 
Join Date: Sep 2008
Posts: 3
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Need help database error

Here is the message. I'm a noob at this so I have no clue.

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT COUNT(post.postid) as unread
FROM post as post FORCE INDEX (dateline)
INNER JOIN thread as thread USING (threadid)
INNER JOIN forum AS forum USING (forumid)
LEFT JOIN threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 1)
LEFT JOIN forumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 1)
WHERE thread.forumid IN(0171,147,148,237,14,134,89,163,6,383,143,320,32 1,322,284,173,197,363,220,368,381,238,227,324,183, 7,15,371,370,377,48,213,47,40,62,215,16,235,262,28 0,242,19,376,25,74,20,75,21,339,73,22,319,212,341, 106,159,261,243,244,245,247,246,214,88,256,257,259 ,260,216,1,2,4,288,346,56,69,79,230,218,226,140,14 1,364,142,174,175,176,177,193,199,200,285,300,301, 302,303,379,29,239,130,131,132,234,314,315,145,36, 8,169,99,307,112,229,292,41,296,295,291,309,160,16 7,382,359,287,369,209,337,362,360,317,316,378,81,3 05,105,282,164,205,102,91,166,137,103,161,192,264, 265,266,267,268,271,272,273,270,290,367,37,361,372 ,373,374,366,194,275,206,278,375,269,289,313,380,1 81,336,182,323,326,327,356,328,329,330,332,333,334 ,335,358,325,340,338,9,146,100,233,129,12,26,365,1 0,170,263,11,157,117,64,31,32,63,298) AND thread.visible IN (0,1,2)
AND post.dateline > IF(threadread.readtime IS NULL, 1272978711, threadread.readtime)
AND post.dateline > IF(forumread.readtime IS NULL, 1272978711, forumread.readtime)
AND post.dateline > 1272978711
AND thread.lastpost > IF(threadread.readtime IS NULL, 1272978711, threadread.readtime)
AND thread.lastpost > IF(forumread.readtime IS NULL, 1272978711, forumread.readtime)
AND thread.lastpost > 1272978711;

MySQL Error : Table './divink5_vb/post' is marked as crashed and should be repaired
Error Number : 145
Request Date : Tuesday, May 4th 2010 @ 10:14:10 AM
Error Date : Tuesday, May 4th 2010 @ 10:14:10 AM
Script : http://divineknightsclan.com/forum/
Referrer :
IP Address : 166.137.138.252
Username : DK_BlackFalcon
Classname : vB_Database
MySQL Version : 5.1.30
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 10:11 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03700 seconds
  • Memory Usage 2,189KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)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)showthread_list
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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_threadedmode.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids_threaded
  • showthread_threaded_construct_link
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete