Just Finished Some Fixes at my Comment Database

This post is intended to share some fixes that I have Done.

I have seen this comment in yellow at my database : See Pictures below

More than one INDEX key was created for column `comment_approved’

Problem : When Commenting in my blog it will redirect you to 404 Page then after refreshing the page it will again go back to the page but sometime comments are not shown.

Solution : I went to Database PHP My Admin then drop the [ comment_approved_date_gmt ] & [ comment_approved ] from the following Indexes as shown in below as part of your Database wp_comments.More than one INDEX key was created for column `comment_approved

I am not expert in this database thing but I tried to delete one of them and there are still problems. And when I delete all index, My dashboard acts strange so as per my trial and error, dropping { or deleting } [ comment_approved_date_gmt ] & [ comment_approved ] is the best solution. If you encounter error while commenting please let me know and I will try to resolve it.

BTW I have WordPress 2.6 in my system. I believed this is some issues with some of my plug-ins. I don’t know well, at least it is fix for now.

Dexter Panganiban https://techathand.net/about-2/

Dexter is a person who loves technology,new gadget, SEO, Social Media and Christianity. Follow him at twitter via @techathand and add him @ Google+ and contact us at [email protected]

You May Also Like

More From Author

11Comments

Add yours
  1. 1
    Slow MySQL fix | Fearless Us

    […] the majority of the data for the site comes from MySQL, this was the first place I looked.  This post shows what my comments table looked like exactly.  Since there is already an index for comment_approved and comment_date_gmt, the index […]

  2. 2
    Steve

    FYI, I tried doing as you suggested, but it did not help. I dropped just the [ comment_approved_date_gmt ] & [ comment_approved ] indexes and I still get the 404 page. 🙁

  3. 5
    timmy77

    “went to Database PHP My Admin then drop the [ comment_approved_date_gmt ] & [ comment_approved ]”

    Ok.. but doesn’t this affect moderation of comments. Can you still moderate comments after you droped them?!

  4. 8
    Dexter | Tech At Hand Dot Net

    @ Did You Know?

    Oo nga at last he he he, One good thing happen I was able to understand how this database things work..

    @ Amy,

    When I tried to reply on the comments I saw this error that is why I immediately search for the errors..

    and luckily I found it..

+ Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.