Home > Wordpress > Just Finished Some Fixes at my Comment Database

Just Finished Some Fixes at my Comment Database

Posted by : Dexter Panganiban on July 28, 2008 | ; Filed Under Wordpress

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.

Related Posts
  • WordPress 2.8.4 Released to Fix Admin Password Reset Exploit
    If you don't want hackers to reset your passwords better do the upgrade immediately : Yesterday a vulnerability was discovered: a specially crafted URL could be requested that would allow an attacker to bypass a security check to verify a user requested a password reset. As a result, the first acco...
  • WordPress 2.6 Beta 2
    What after a week of releasing Beta 1 there is now Beta 2, Again this make me think if we need to install WordPress updated version whenever it available. Here are the changes as specified by Boren Insert image and edit image fixes SSL fixes i18n fixes Lots of new inline documentation Improved...
  • WordPress 2.5.1 is out
    I am busy this past 2 days that is why I was not able to blog about the released of WordPress 2.5.1 well i saw at Matt Cutts Blog. You can read about WordPress 2.5.1 and you can download the new version here. WordPress  2.5.1 fixes lots of bugs and Here are some highlights: Performance improveme...
Related Posts Plugin for WordPress, Blogger...

Enter your email address:

Tags: Commenting, Database Error, Redirect, Solution

About the author

Dexter is a person that love technology,new gadget, SEO, Social Media and Christianity. Follow him at twitter via @techathand and add him @ Google+ and contact us at admin@techathand.net

Sign up for PayPal and start accepting credit card payments instantly.

Interesting Comments

10 Responses to “Just Finished Some Fixes at my Comment Database”

  1. Did You Know? on July 28th, 2008 6:27 pm

    congratz at nafixed mo na..hehe. God bless!

    Reply


  2. Amy on July 28th, 2008 9:39 pm

    kaya pala kahapon nag error 404 nung nag comment ako :)

    Amys last blog post..WordCamp Philippines 2008

    Reply


  3. Dexter | Tech At Hand Dot Net on July 28th, 2008 9:43 pm

    @ 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..

    Reply


  4. 2008 Beijing Olympics - Medal Tally Updates and Results on July 29th, 2008 3:04 am

    congratz kuya dexter, pedeng pede kna maging programmer o database administrator – or you’re already one, hehhe, ;)

    - it’s gusher

    2008 Beijing Olympics – Medal Tally Updates and Resultss last blog post..SEO Makes More Money

    Reply


  5. Did You Know? on July 29th, 2008 7:24 am

    uu nga. Programmer yan c kuya dexter. hehe

    Reply


  6. Dexter | Tech At Hand Dot Net on July 29th, 2008 8:04 am

    @ Gusher,

    How I wish I can be a programmer pero mukhang mahirap na yan sa stage ko ha ha ha.. medyo may edad na.

    @ Did You Know?

    Anong klaseng programmer.. Programmer ….hhmm.. television he he he

    Reply


  7. timmy77 on February 14th, 2009 1:26 am

    “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?!

    Reply


  8. Dexter Panganiban on February 14th, 2009 6:23 am

    @timmy77

    You can only dropped the comments if its duplicated. But if not you must not drop it.. As of now Akismet is still doing fine.. and comments can also be moderated

    Reply


  9. Steve on March 10th, 2010 3:51 pm

    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. :(

    Reply

    Dexter Panganiban Reply:
    March 10th, 2010 at 4:54 pm

    @Steve,

    This solution is for wordpress 2.6 it might not work thru your present WP version

    Reply


1 pingsLinks To This Post

  1. Slow MySQL fix | Fearless Us on July 28th, 2011 4:34 am

    [...] 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 [...]


Leave a Reply




My Sponsors

Help My Father's Kidney Dialysis Expenses

Help in My Father’s Kidney Dialysis by Contributing Articles and/or Being Our Link Builder

Subscribe to RSS feed

Subscribe to RSS feed

Enter your email address:

Categories