A moment for joy and thanksgiving has arrived, in a very geeky sense– I was able to FIX the mySQL error which was causing comments to not work on my WordPress blog! I wrote about this last Wednesday in a “plea for help” post. Last week as I spent some time googling for answers, I came across a post (similar to this one) which explained how WordPress mySQL databases over time can develop “overhead” and need to be repaired using phpMyAdmin. This is similar to defragmenting a hard drive, evidently. It is apparently natural for “overhead” to develop, and just a part of “normal” maintenance to repair/remove it periodically.
As I wrote about in my post last week, the problem I was having when people tried to leave comments on my blog they could not and were presented with a generic 404 (page not found) error. As I looked into this, I noticed that in my WordPress dashboard it showed I did not have ANY comments in my blog, even though there should be a bunch. mySQL showed the table records for comments were there in the wp_comments table, but the dashboard did not:
Now that I’ve finished this repair, comments again show up numbered correctly in my WordPress dashboard:
I referred to my error log for my site and found that there was a duplicate comment number, which was causing the problem. When I tried to delete the offending table row, however, a “key field” error was reported. I was stumped.
The solution, it turns out, was using the “repair” option in phpMyAdmin. To do this, when you select your database in phpMyAdmin select the tables which have overhead shown in the last column. Then at the bottom, choose “repair table.” This is the course of action suggested my phpMyAdmin, but since I had never done this or encountered this situation previously I wasn’t sure exactly how to proceed.
When I did this for my wp_comments table, my problem was fixed!
The repair results show that the number of table rows was incorrect and the repair procedure fixed this. That was it!
I am overjoyed to have this problem resolved, but this situation overall has pointed out my need to do a more complete and thorough maintenance cleanup of my WordPress mySQL database. I need to go through my error logs line by line (something I definitely don’t relish) and figure out how to fix the problems which are being reported there. Possibly some of my past problems will be fixed by this overhead repair procedure, but I’m not sure. I’m considering posting a request for a quote on getafreelancer.com or guru.com similar to this one, to let a WordPress guru (in another country, most likely) working for a smaller fee take care of this for me. Outsourcing IT support needs like this makes sense and can be affordable. I might just give this a try.
For now, I’m just pleased this commenting issue has been resolved. This situation highlights the value of people using a hosted/managed blogging solution like Edublogs, WordPress.com, Blogger, Typepad, etc. instead of self-hosting WordPress as I am. I’m still glad to be self-hosting, but dealing with these sorts of troubleshooting situations CAN cause some stress. Thankfully, in situations like these, we have Google.
Did you know Wes has published 3 eBooks, and 1 of them is available free? Check them out!
If you're trying to listen to a podcast episode and it's not working, check this status page. (Wes is migrating his podcasts to Amazon S3 for hosting.) Remember to follow Wesley Fryer on Twitter (@wfryer), Facebook and Google+. Also "like" Wesley's Facebook pages for "Speed of Creativity Learning" and his eBook, "Playing with Media." Don't miss Wesley's latest technology integration project, "Mapping Media to the Common Core / Curriculum."
On this day..
- Family Oral History and Smartphones (May 2014) - 2014
- Server Alerts Via SMS Gateway or GSM Modem: Unique Identifier Question - 2012
- Lessons Learned From An Immediate Social Network Sharing Button - 2012
- Why was Osama Bin Laden Buried at Sea? - 2011
- NCLB was designed to define public schools as failures - 2010
- PodStock09 Stories - 2009
- Podcasts and Intellectual Property by Glenn Wiebe - 2009
- Students as Self-Advocates: Why/How Learners Should Craft Their Own Digital Footprints by Ginger Lumen - 2009
- Using Digital Technologies and Personal Learning Networks to Enhance Learning by Clif Mims - 2009
- links for 2008-05-02 - 2008