Data Base error

[dave9720]

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

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

[Kinneas]

Have you tried repairing the table?

[dave9720]

Originally Posted by Kinneas

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

[Opserty]

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.

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