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 09-12-2008, 03:35 AM
dave9720 dave9720 is offline
 
Join Date: Dec 2007
Posts: 57
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Data Base error

I am unable to open a sub forum post with a attachment. When open post I get data base error! Enclosed is recent email.

Code:
This message was created automatically by mail delivery software.

A message that you sent could not be delivered to one or more of its
recipients. This is a permanent error. The following address(es) failed:

  dbmaster@example.com
    retry time not reached for any host after a long failure period

------ This is a copy of the message, including all the headers. ------

Return-path: <be*****e@serv01.siteground218.com>
Received: from localhost ([1**.0.0.1]:51794 helo=serv01.siteground218.com)
by serv01.siteground218.com with smtp (Exim 4.69)
(envelope-from <be*****e@serv01.siteground218.com>)
id 1Kdzhd-0006fX-HL
for dbmaster@example.com; Thu, 11 Sep 2008 22:52:13 -0500
X-SG-User: be*****e
To: dbmaster@example.com
Subject: vBulletin Database Error!
From: "dbmaster@example.com" <dbmaster@example.com>
Message-ID: <20080912035213.aef5c0944635@be****8****os.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit
X-Priority: 3
X-Mailer: vBulletin Mail via PHP

Database error in vBulletin 3.7.3:

Invalid SQL:

SELECT dateline, thumbnail_dateline, filename, filesize, visible, attachmentid, counter,
postid, IF(thumbnail_filesize > 0, 1, 0) AS hasthumbnail, thumbnail_filesize,
attachmenttype.thumbnail AS build_thumbnail, attachmenttype.newwindow
FROM attachment
LEFT JOIN attachmenttype AS attachmenttype USING (extension)
WHERE postid IN (-1,4693)
ORDER BY attachmentid;

MySQL Error   : Table './bestsate_vb/attachment' is marked as crashed and last (automatic?) repair failed
Error Number  : 144
Request Date  : Thursday, September 11th 2008 @ 10:52:13 PM
Error Date    : Thursday, September 11th 2008 @ 10:52:13 PM
Script        : http://be****8****os.com/showthread.php?p=4693
Referrer      : http://be****8***os.com/forum.php
IP Address    : 7*.*2.**1.84
Username      : Dave
Classname     : vB_Database
MySQL Version : 5.0.45-community-log
Reply With Quote
  #2  
Old 09-12-2008, 07:27 AM
Kinneas's Avatar
Kinneas Kinneas is offline
 
Join Date: Dec 2005
Location: Nottingham, UK
Posts: 282
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Have you tried repairing the table?
Reply With Quote
  #3  
Old 09-12-2008, 08:17 AM
dave9720 dave9720 is offline
 
Join Date: Dec 2007
Posts: 57
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Kinneas View Post
Have you tried repairing the table?
Thank you for your quick response. Yes I run the repair for the forum daily. Thats how it happened during the repair for attachments. I had to shut the site down and disable all the plugins. Still trying to fiqure this out. Thanks Dave
Reply With Quote
  #4  
Old 09-12-2008, 08:24 AM
Opserty Opserty is offline
 
Join Date: Apr 2007
Posts: 4,103
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You only be repairing tables when an error message tells you to do. Otherwise you risk creating more problems if you do it to a normal, functioning table.

Quote:
MySQL error code 145: Table was marked as crashed and should be repaired

These error codes all have the same solution. They specify that something has gone wrong with your data. You should run optimize & repair on your database tables. You can upload the tools.php file from the vbulletin .zip file do_not_upload/ folder into your forumdir/admincp/ directory and run it through the browser, there's a switch there to run optimize and repair. Run it a few times for best result.

For more information on repairing your database please view the MySQL documentation at:
http://dev.mysql.com/doc/refman/5.0/en/repair.html
Common MySQL Error Messages
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 04:17 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05653 seconds
  • Memory Usage 2,189KB
  • Queries Executed 13 (?)
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)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (4)postbit
  • (4)postbit_onlinestatus
  • (4)postbit_wrapper
  • (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_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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • 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