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.
Technorati Tags:
wordpress, error, mysql, comment, duplicate
If you enjoyed this post and found it useful, subscribe to Wes’ free newsletter. Check out Wes’ video tutorial library, “Playing with Media.” Information about more ways to learn with Dr. Wesley Fryer are available on wesfryer.com/after.
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