SJ_the_Bartender
Perma-Newbie
So, I'm sure many of you came to the site yesterday and were wondering why nothing was working.
I still don't have all the details myself, but from the nearest I can figure, our host decided it would be a good idea to upgrade our database software. However, they did it in such a fashion as to cause us significant pain and suffering.
Fortunately, it appears that no data was lost. We are back up and running.
You can expect some slowness in the next day or so while the bugs are ironed out, but by the end of the weekend, we should be back to normal operating speed.
The rest of this is just technical jargon, which I'm posting for my own references.
I still don't have all the details myself, but from the nearest I can figure, our host decided it would be a good idea to upgrade our database software. However, they did it in such a fashion as to cause us significant pain and suffering.
Fortunately, it appears that no data was lost. We are back up and running.
You can expect some slowness in the next day or so while the bugs are ironed out, but by the end of the weekend, we should be back to normal operating speed.
The rest of this is just technical jargon, which I'm posting for my own references.
Database error in vBulletin 3.6.7:
Invalid SQL:
SELECT COUNT(*) AS count
FROM vb_attachment AS attachment
INNER JOIN vb_post AS post USING (postid)
WHERE attachment.visible = 0;
MySQL Error : Table './moraldelima_1/vb_post' is marked as crashed and should be repaired
Error Number : 145
Date : Thursday, August 16th 2007 @ 09:10:20 AM
Script : http://newayenee.org/forum/notouch/index.php?do=home
Referrer : http://newayenee.org/forum/notouch/index.php?do=nav
IP Address : <Removed>
Username : SJ_the_Bartender
Classname : vB_Database
The important thing seems to be the vb_post table. It got corrupted somehow. REPAIR TABLE Command didn't work to restore it.
http://dev.mysql.com/doc/refman/5.0/en/repair.html seems to have the solution.
Invalid SQL:
SELECT COUNT(*) AS count
FROM vb_attachment AS attachment
INNER JOIN vb_post AS post USING (postid)
WHERE attachment.visible = 0;
MySQL Error : Table './moraldelima_1/vb_post' is marked as crashed and should be repaired
Error Number : 145
Date : Thursday, August 16th 2007 @ 09:10:20 AM
Script : http://newayenee.org/forum/notouch/index.php?do=home
Referrer : http://newayenee.org/forum/notouch/index.php?do=nav
IP Address : <Removed>
Username : SJ_the_Bartender
Classname : vB_Database
The important thing seems to be the vb_post table. It got corrupted somehow. REPAIR TABLE Command didn't work to restore it.
http://dev.mysql.com/doc/refman/5.0/en/repair.html seems to have the solution.