Ah, these are the moments I wish I had my own IT staff. If you’re a WordPress or mySQL guru perhaps you can help me!
I am running WordPress on my main blog (“Moving at the Speed of Creativity”) and the blog has stopped accepting comments for some reason, as of Monday night (April 27, 2009) around 8 pm CST. That’s when my last comment came in successfully. I can post new entries to the blog, but no new comments can be received. I’m running WP 2.7.1. I haven’t installed or updating the blog or plug-ins lately, so I don’t think the source is a recent change I’ve made. I tried disabling all plug-ins except Akismet, but the error persisted. I think the problem is in my mySQL database.
I checked my WordPress directory error_log file and this is the last entry. It is a “WordPress database error Duplicate entry” message:
The other strange symptom is that in my WordPress dashboard, it shows that I don’t have any comments on my blog, even though there are almost 7000 approved.
The comments are still there, when I click the “comments” sidebar link they show up. Something is messed up with the auto-incrementing and I think it needs to be reset in mySQL. I’ve never done that, however.
I did a full mySQL database backup using phpMyAdmin. I considered reinstalling WordPress 2.7.1, but since this appears to be a mySQL problem I don’t think that would help. I haven’t (to date) done a good job monitoring and managing my error and access logs, and I’ve got some other issues and problems that it looks like I need to fix. (Some big ones with PodPress.) Overall I know I need to clean up my mySQL database, but never having done that before I am not sure where to begin. At least I have a new backup, I know that’s always a good idea…
Do you have any suggestions or tips for me that could help? Since my blog isn’t accepting comments (isn’t that ironic) I’ve cross-posted this to our Learning Signs blog (where commenting is working) or you can Tweet me an idea or link as an @reply or direct message.
Many, many thanks. Yuk. I really don’t like technical glitches like this which can often consume LARGE amounts of troubleshooting time.
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..
- Robotics, Stories, Stopmotion, Enhanced eBooks, Coding & More at PLAYDATE OKC May 10th - 2014
- Create YouTube Channel with Custom URL (April 2013) - 2013
- Checking Algebra and Geometry Problems with WolframAlpha - 2012
- Hide FarmVille Status Updates on Facebook - 2010
- Visualizing Twitter - 2009
- Continuing dialog about creativity in schools, student technology skills and content filtering - 2008
- links for 2008-04-29 - 2008
- Collaboration in schools: More reasons we need it - 2007
- Import Garageband Audio at 44.1 - 2006
- Site visit UT College of Education: Year 3 of One to One Computing - 2005