For couple of days I encountered some technical problems while I was doing my daily blogging. Now everything works well and back to normal The incidence reminds me of the importance of technical support by the web hosting company especially a 24/7 round the clock support service. My sincere thanks to the support service team.
I have below the detailed exchange of messages between me and the support service of Pair Networks,
2011/09/07
I login my blog
http://millionbabyboomers.com
I wrote a post then when I tried to save it an error message came
as below:
Quote
Saving Entry failed: Failed to execute INSERT INTO mt_trackback
(trackback_blog_id, trackback_category_id, trackback_created_by,
trackback_created_on, trackback_description, trackback_entry_id,
trackback_is_disabled, trackback_modified_by, trackback_modified_on,
trackback_passphrase, trackback_rss_file, trackback_title,
trackback_url) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) with
blog_id, category_id, created_by, created_on, description, entry_id,
is_disabled, modified_by, modified_on, passphrase, rss_file, title,
url: DBD::mysql::st execute failed: Table './davidau_mt/mt_trackback'
is marked as crashed and should be repaired.
Unquote
I could not publish the post. I also have other problems such as
cannot manage entries and comments.
Kindly advice what is the problem. I would appreciate your help fixing
it as soon as possible.
Thank you and regards.
David Au
aushukan@rogers.com
Hello,
It looks like this indicates there is a corrupt table within your database.
You will be able to do a check and repair on your database tables with
phpMyAdmin.
Please follow the simple instructions below to check and repair a MySQL
table using phpMyAdmin:
1. Log into the Account Control Center (https://my.pair.com/)
2. Click "Advanced Features"
3. Click "Database Administration"
4. Select Your Database
5. Click "Manage Using phpMyAdmin"
6. Login into phpMyAdmin
7. Check the box to the left of the table that you'd like to check
8. Select "Check table" (from the "With selected:" drop down box under
the table listing)
If a corrupt table reports an error, the table needs to be repaired.
If you need to repair a table using phpMyAdmin, follow these instructions:
1. Login into phpMyAdmin
2. Check the box next to the table that you'd like to repair
3. Select "Repair Table" from the "With selected:" drop down box
(under the table listing)
If MySQL reports Status OK, the table is now repaired. If any errors
still persist for the table, please do not hesitate to contact us again.
Thank you and have a great day.
pair Networks Support
support@pair.com
2011/09/08
Hi,
I tried to follow your instruction per the following email. I failed
as I could not login the phpMyAdmin. I don't have the password.
By the way, more problems are found as follows:
all Movable Type templates are gone all Movable Type widgets are gone
Today during the day, there are lots of comments coming in, Tonight
all comments are gone.
Would you fix the problem for me as I am not a techie.
Email me if you need more info from me
Thank you and would most appreciate your help.
David Au
aushukan@rogers.com
I've gone ahead and checked and repaired your database davidau_mt, all
tables were repaired without error.
You'll need to know the database password to log into PHPMyAdmin. If you're
not sure of this password, you can reset it via the Database Management
section. After resetting the password, you'll need to update your MT and WP
config.php or equivalant files with that new password as well.
Best regards,
pair Networks, Inc.
support@pair.com
2011/09/09
Hello,
The web site appears to load with out any errors showing. Please
send in the steps to recreate the issue/errors encountered.
Include the user name and password to login into the MT site if
needed to recreate the issue.
Thank you,
pair Networks, Inc.
support@pair.com
Hi,
Here below for your login into my blog
my username:
password:
The most current problem I have:
1. login with above username and password
2. error message came out:
Quote
Status: 200
Set-Cookie: mt_commenter=kEuJElAB3hWC9NaJaW9dR7fW5wQ6Gs4SulqJdN6w; path=/; expires=Sat, 10-Sep-2011 00:07:04 GMT
Set-Cookie: commenter_name=David%20Au; path=/; expires=Sat, 10-Sep-2011 00:07:04 GMT
Set-Cookie: mt_user=admin%3A%3AlLgvw0h5X5F50zaUqvvGIQTW7MzgmTPYfuGmlPzn%3A%3A0; path=/cgi-sys/cgiwrap/davidau/managed-mt/
Date: Fri, 09 Sep 2011 20:07:05 GMT
Pragma: no-cache
Content-Type: text/html; charset=utf-8
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "DTD/xhtml1-transitional.dtd">
<html xmlns:fb="http://www.facebook.com/2008/fbml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>An error occurred | Movable Type Pro</title>
<link rel="icon" href="/mt-static/images/favicon.ico" type="image/ico" />
<link rel="stylesheet" href="/mt-static/css/simple.css?v=4.261" type="text/css" />
<!--[if IE]>
<link rel="stylesheet" href="/mt-static/css/hacks/ie.css?v=4.261" type="text/css" />
<![endif]-->
<script type="text/javascript" src="/mt-static/js/common/Core.js?v=4.261"></script>
<script type="text/javascript" src="/mt-static/js/tc.js?v=4.261"></script>
<script type="text/javascript" src="/mt-static/mt.js?v=4.261"></script>
<script language="javascript" type="text/javascript">
/* <![CDATA[ */
function showByID(id) {
var el = getByID(id);
if (el) el.style.display = "block";
}
function hideByID(id) {
var el = getByID(id);
if (el) el.style.display = "none";
}
/* ]]> */
</script>
</head>
<body id="" class="chromeless chromeless-wide dialog">
<div id="container">
<div id="container-inner">
<div id="ctl"></div>
<div id="ctr"></div>
<div id="header" class="pkg">
<div id="brand"></div>
<div id="nav">
</div>
</div>
<div id="content">
<div id="content-inner" class="inner pkg">
<div id="main-content"><div id="main-content-inner" class="inner pkg">
<h1 id="page-title">An error occurred</h1>
<div
id="generic-error" class="msg msg-error"><a
href="javascript:void(0)"
onclick="javascript:hide('generic-error');return false;"
class="close-me"><span>close</span></a>
DBD::mysql::st execute failed: Incorrect key file for table './davidau_mt/mt_asset_meta.MYI'; try to repair it
</div>
<div class="actions-bar">
<div class="actions-bar-inner pkg actions right">
<button
onclick="history.back()"
type="submit"
accesskey="s"
class="primary-button"
>Go Back</button>
<button
id="close-button"
onclick="if ( window.opener ) { window.close(); } else { window.parent.closeDialog(); }"
type="submit"
accesskey="x"
class="hidden"
title="Close (x)"
>Close</button>
<script type="text/javascript">
/* <![CDATA[ */
// show the close button if error is in modal or popup
if ( window != window.parent || window.opener )
document.getElementById("close-button").className = "";
/* ]]> */
</script>
</div>
</div>
</div>
</div>
</div>
</div>
<div id="cbl"></div>
<div id="cbr"></div>
<div id="footer">
<div class="inner">
</div>
</div>
</div><!-- container-inner-->
</div><!--container-->
</body>
</html>
Unquote
Prior to this, early in this morning
1. I login successfully with my username and password
2. I wrote a post then saved and published, it seemed there was no problem
3. I checked the homepage, then I found the comments are still the old comments
There was no new undated comments.
4. I highlights the new comments and published them again.
5. A long error message came similar to the one I quote above
6. Comments on the homepage were updated.
7. As from that moment, I failed repeatedly to login my blog. Every time I login to
my blog, I get the error message as quote above.
8. Under the blog section, the latest posts as well as the more recent ones were missing.
I hope the above info is useful for you solving the problem of my blog.
Thank you and look forward to hearing good news from you.
David Au
2011/09/10
Hello,
Your issue has been referred to the pair Networks staff for
examination. A response shall be forth coming and will be
delivered as a reply to this ticket.
Thank you,
pair Networks, Inc.
support@pair.com2011/09/10Above problem solved as my blog is back to work.
I therefore post here a follow up report about the incidence.
My sincere thank you to Pair Networks,