Posted by Mitch Mitchell on Sep 7, 2011
I’m writing this a couple of days removed, but hopefully I can help you out so you don’t go through what I went through. Of course, not everyone will be able to do this, but at least the information might be helpful.
On Sunday I heard from our friend Brian Hawkins on Twitter. He was telling me that he was having problems posting a comment to this blog. He thought something was missing, so I went to take a look and said everything looked fine. I even checked on 3 different browsers. So he tried it on a couple of browsers and it just wasn’t coming up properly for him. He said he’d try it at his brother’s the next day.
Monday morning I looked at comments and wondered why I wasn’t seeing any new ones. Remembering Brian’s comment the day before, and seeing that he’d sent me the comment he had wanted to post, I decided to go to one of those other browsers to post it myself. It took me to a 404 page. That was freaky, so I came into this admin panel to try to post a quick comment of my own; that wasn’t happening either, as it just kept disappearing.
Now it was panic and research time. From 8:30 in the morning until around 8:30 in the evening, with a few breaks to eat, I tried as many things as I could. Nothing was working. I even called my hosting company to see what they had to offer. They gave me some erroneous information that it had to be that my databases had gone beyond capacity. I went in and cleared one, which was really huge, and that didn’t get it done; I’m going to come back to that one in a minute.
During this time a couple other people had tried to help me, but without success. I finally went to the WordPress.org forum, because my host said it had to be their issue, and I posted the question, telling everything that I’d tried. Someone came on and started making suggestions. Some I’d already tried, but others were somewhat interesting.
They involved going into the control panel of my account on my host and getting into the PHPmyAdmin area, something I forget about because it’s not a place I have to go often; matter of fact, it’s probably been a couple of years. It was also where the hosting company had said to go and delete some files, so I was a bit skeptical.
His recommendation was to run a repair on the files I was having problems with. There were two files dedicated to comments, so I checked the box next to both of them then ran repair. It went pretty fast and gave me a positive report. I came back to the blog, posted a test comment, and all was right with the world once again; whoo hoo! 🙂
I’m writing this post because the information wasn’t anywhere else until I asked the question. Even though someone else who might end up with this issue might find that post in the forum, I figured why not write it up here as well; might save a lot of time later on. And I take this time to thank both Brian and Dan Lovell and someone called Esmi on the forum for helping me on this.
Now, back to the file I emptied. That file was related to the Count Per Day plugin I added last September. It seems that it collects tons of information and never gets rid of any of it. It had collected information to the post where the file had grown to 88MB; that’s huge. When compared to the next largest text file being only 5MB, you can tell it was out of kilter.
Many hosts don’t allow the data within an account to get larger than 100MB, and mine was around 147MB. So, clearing that file out freed up tons of space for me. Just something else to consider if you start having some issues with databases.