Everything should be back in order. Thanks for all the email, I hate using my cell phone for replying to emails, takes way too long. I need a crackberry or iphone. Not sure what happened but a table of the DB became corrupt.
/ nerd content on
Looks like the phpbb_topics_watch.myi file became corrupt and the header of the phpbb_post.myi header was missing.
I was getting 22 when fixing table errors when running repair from phpmyadmin.
Had to run a some mysql command manually.
Here is a good tutorial on corrupt mysql db's.
http://www.databasejournal.com/features ... -MySQL.htm
/ nerd content off
Now off to my bathroom painting... I would much rather do this
May 22, 2009 Database issues
Moderator: Moderators
- mrlayance
- Tragically Rich
- Posts: 3203
- Joined: Sun Jun 09, 2002 6:40 pm
- Location: Halifax, NS
May 22, 2009 Database issues
I need 2 Kingston Tickets, please help.
-
- Groupie In Training
- Posts: 69
- Joined: Sat Dec 11, 2004 3:28 pm
Re: May 22, 2009 Database issues
Thanks for fixing it!
- chris
- The Last Recluse
- Posts: 8673
- Joined: Fri Sep 13, 2002 8:04 am
Re: May 22, 2009 Database issues
Did any data get lost?
- mrlayance
- Tragically Rich
- Posts: 3203
- Joined: Sun Jun 09, 2002 6:40 pm
- Location: Halifax, NS
Re: May 22, 2009 Database issues
No data was lost. The table was fine, just the file that basically one of the files that links all the other tables together was corrupt. Only affecting one part of the database. That is why you could still read the posts just not add to or create new posts.chris wrote:Did any data get lost?
I need 2 Kingston Tickets, please help.
- chris
- The Last Recluse
- Posts: 8673
- Joined: Fri Sep 13, 2002 8:04 am
Re: May 22, 2009 Database issues
Here's what I was seeing:
You do not have the required permissions to view the files attached to this post.
- mrlayance
- Tragically Rich
- Posts: 3203
- Joined: Sun Jun 09, 2002 6:40 pm
- Location: Halifax, NS
Re: May 22, 2009 Database issues
Ok, do you still see that?chris wrote:Here's what I was seeing:
I need 2 Kingston Tickets, please help.
- chris
- The Last Recluse
- Posts: 8673
- Joined: Fri Sep 13, 2002 8:04 am
Re: May 22, 2009 Database issues
No. Now it's fine. Just wanted you to have a record of it.