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.

Popularity: 9% [?]

Share and Enjoy:These icons link to social bookmarking sites where readers can share and discover new web pages.
  • del.icio.us
  • digg
  • NewsVine
  • Reddit
  • TailRank


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 software, blogging.

Tagged with: No Tags

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 »

Read More

Related Reading:

Latest Posts:

2 Responses to “Optimize Wordpress Tables with Fix Database Plugin”



Leave a Reply

Note: Any comments are permitted only because the site owner is letting you post, and any comments will be removed for any reason at the absolute discretion of the site owner.