Optimize Wordpress Tables with Fix Database Plugin
I've been seeing an unusual number of spam comments awaiting moderation lately. Normally, Akismet does a great job keeping them out of the moderation queue. The ones that do make it to the queue, I usually let expire automatically. This new crop, I decided to delete manually. When I did, I got this error:
Unknown column 'pingback_views' in 'field list' on line: 532
A quick websearch -- with few results, which is why I am leaving this crumb -- hinted that my Wordpress database tables needed optimizing.
I don't run phpAdmin on my servers so that solution was out, and even with the MySQL Query Browser, figuring out the target table was proving to be a pain. So another quick search turned up Slapyo's Database Fix WP plugin. This solution fixed my problem perfectly.
Thank you for reading this post. You can now Read Comments (2) or Leave A Trackback.
Post Info
This entry was posted on Thursday, June 7th, 2007 and is filed under blogging, software.You can follow any responses to this entry through the Comments Feed. You can Leave A Comment, or A Trackback.
Previous Post: Googler Writes Facebook Sneaky Crush App? »
Next Post: Click.TV Player Will Be Shut Down »
- How to Get MagicJack and Lifecam Cinema Working on Windows 7 64-bit
- Fix for Error Installing do_mysql Datamapper Adapter on Ubuntu
- Amazon Packages and Ships OEM Hard Drives Loose in Box with Two Air Pillows and Bubble Wrap ONLY
- Devious New Targeted Financial Phishing Scam Strikes Your Cellphone
- Errata for Programming Collective Intelligence
- Yelp Battles Supporters of the Meier Family
- Pictures of Lori Drew
- Picture of Curt Drew
- Brandon Antron Rolle Goes on Trial Today
- Fixing Spurious Rails Routing Error




June 28th, 2007 14:31
[...] me. And on line 532 to boot! Some nerve. Googling that error message suggested that maybe my MySQL tables had become corrupted. The tables were probably boozing it up and watching too much [...]
June 3rd, 2008 10:47
I just started getting the same error. Thanks for posting the possible solution, I will look in to that plugin.