I lost all comments!

Thu, May 17, 2007

Software

Wordpress Comments Deleted

After a lot of days of work… I was barely able to post anything here. And had it on for some time with the comments table corrupted. The comment box that appeared said:

WordPress database error: [Table './*****/wp_comments' is marked as crashed and last (automatic?) repair failed]
SELECT * FROM wp_comments WHERE comment_post_ID = ‘**’ AND comment_approved = ’1′ ORDER BY comment_date

So all comments were broken. And even after doing several MySQL repairs. I did not get it fixed. And I just decided to drop the wp_comments table and make a new one to fix it. So everyone that placed comments, some date back to 2005. Sorry they are gone. And I guess the best comment I liked out there was the comment on the .htaccess code for the 301 redirects that also prevent looping of the index page for SEO domain canocalization purposes. Oh well, at least I still have all post alive. Aside from that I got WP2.2 with the subdomain plugin running fine, so everything is still relatively good.

Popularity: 1% [?]

Share and Enjoy:
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks

This post was written by:

Benj Arriola - who has written 142 posts on action online.

Started a career as a chemist. Worked in the industry and academe and pursued a master's degree in chemistry. Then one day, here I go, start a computer shop, then web company in 1999, won a few awards and just started a web career working on websites of various companies and making sure the websites work for them.

Contact the author

2 Comments For This Post

  1. Mike Lopez Says:

    Here’s your first comment in your newly found life… Hehehehehe…

    Lesson for you – backup backup backup backup

  2. Weng Says:

    Here’s another and thanks for dropping by my site. Seems we both had WordPress woes these past few days.

Leave a Reply