vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)
-   -   Data Base error (https://vborg.vbsupport.ru/showthread.php?t=190708)

dave9720 09-12-2008 03:35 AM
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

Kinneas 09-12-2008 07:27 AM
Have you tried repairing the table?

dave9720 09-12-2008 08:17 AM
Quote:
Originally Posted by Kinneas (Post 1620367)
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.:confused: Thanks Dave

Opserty 09-12-2008 08:24 AM
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


All times are GMT. The time now is 08:20 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.01035 seconds
  • Memory Usage 1,725KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete