View Single Post
  #1  
Old 07-14-2009, 02:08 PM
goshalim goshalim is offline
 
Join Date: Oct 2007
Posts: 470
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default fnewpost' is marked as crashed

Help please

I had my forum down doing some works.

Sudently i received this message .

What shall i do please...


Quote:
database error in Subdreamer

Invalid SQL: SELECT COUNT(*) AS posts FROM fnewpost LIMIT 1
Error: Table './gorgino_canary/fnewpost' is marked as crashed and should be repaired Error number: 145
Date: Tuesday 14th 2009f July 2009 03:23:32 PM
File: http://www.canarybreeder.net/up/index.php

Quote:
Database error in vBulletin 3.7.3:

Invalid SQL:

SELECT COUNT(post.postid) as unread
FROM fnewpost as post FORCE INDEX (dateline)
INNER JOIN fnewthread as thread USING (threadid)
INNER JOIN fnewforum AS forum USING (forumid)
LEFT JOIN fnewthreadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 1)
LEFT JOIN fnewforumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 1)
WHERE thread.forumid IN(03,6,27,50,5,28,21,83,69,70,36,22,4,71,91,92,93 ,94,19,14,15,13,52,57,63,53,59,54,60,55,61,56,62,5 8,38,10,11,25,74,41,76,73,40,75,42,49,12,39,78,43, 51,16,17,29,84,79,85,86,87,23,88,89,90,32,30,81,82 ) AND thread.forumid NOT IN(0) AND thread.visible IN (0,1,2)
AND post.dateline > IF(threadread.readtime IS NULL, 1247583694, threadread.readtime)
AND post.dateline > IF(forumread.readtime IS NULL, 1247583694, forumread.readtime)
AND post.dateline > 1247583694
AND thread.lastpost > IF(threadread.readtime IS NULL, 1247583694, threadread.readtime)
AND thread.lastpost > IF(forumread.readtime IS NULL, 1247583694, forumread.readtime)
AND thread.lastpost > 1247583694;

MySQL Error : Table './gorgino_canary/fnewpost' is marked as crashed and should be repaired
Error Number : 145
Request Date : Tuesday, July 14th 2009 @ 11:08:53 AM
Error Date : Tuesday, July 14th 2009 @ 11:08:55 AM
Script : http://canarybreeder.net/up/forum/
Referrer : http://www.canarybreeder.net/up/
IP Address : 62.152.16.169
Username : admin
Classname : vB_Database
MySQL Version : 5.1.30
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01832 seconds
  • Memory Usage 1,769KB
  • 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
  • (2)bbcode_quote
  • (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