Just Finished Some Fixes at my Comment Database

You are invited to have my FREE RSS Feeds or you may Subscribe to me via email for latest information in this website.

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

Email This Post Email This Post

; Filed Under Wordpress

If you are new here, and you would like be updated on the things happening on this site, Try to Subscribe to my FREE RSS Feeds  and Subscribe to me via email


Next post in category: WordPress 2.6.1 Download »

« Previous post in category: WordPress 2.6 is out, Is it Stable ?

Tags: ,

Trackback Links

del.icio.us |Digg it |Furl |ma.gnolia |Maple.nu |Netscape |reddit |Scuttle |Shadows |Simpy |Spurl |StumbleUpon |Wink |Yahoo MyWeb |

Permalink : Just Finished Some Fixes at my Comment Database

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

Comments

6 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]

Leave a Reply




Subscribe to RSS feed

Subscribe to RSS feed

Enter your email address:

Other Topic