WordPress.org

Ready to get started?Download WordPress

Forums

Cannot save - strange database error message - please help. (5 posts)

  1. cyrillsneer
    Member
    Posted 6 years ago #

    This is happening 75% of the time now as opposed to a much much less frequently a month ago.

    When trying to save edits or publish a new story I sometimes get the following error.

    When going back to the story after seeing this message sometimes the edits are saved sometimes they are not.

    Any ideas would be greatly appreciated.

    WordPress database error: [Duplicate entry " for Key 2]
    INSERT INTO wp_terms (name, slug, term_group) VALUES ('', '', '0')
    
    Wordpress database error: [Duplicate entry '0-post_tag' for key 2]
    INSERT INTO wp_term_taxonomy (term_id, taxonomy, description, parent, count) VALUES ('0', 'post_tag', '', '0', '0')
    
    Warning: Cannot modify header information - headers already sent by (output started at /xxx/xxxx/xxxx/xxxxx/domains/domainname/html/wp-includes/wp-db.php:160) in
    /xxx/xxxx/xxxx/xxxxx/domains/domainname/html/wp-includes/pluggable.php on line 391
  2. MichaelH
    Member
    Posted 6 years ago #

    Wonder if something hasn't happened to the indexes on you tables.

    See if your tables have the correct indexes using phpMyAmdin.

    Here's what my 2.3.1 indexes look like for the 3 terms related tables.
    http://i162.photobucket.com/albums/t249/wpphotobucket/term_indexes.png
    http://i162.photobucket.com/albums/t249/wpphotobucket/term_taxonony_indexes.png
    http://i162.photobucket.com/albums/t249/wpphotobucket/term_relationships_indexes.png

  3. cyrillsneer
    Member
    Posted 6 years ago #

    Thanks for the reply but to be honest I am not really sure what I am looking for or how to correct it, any chance of a link that could explain it, it is getting to the point where people cannot post new stories.

    Sorry.

  4. cyrillsneer
    Member
    Posted 6 years ago #

    I was looking around some forums and some suggested I "drop " all the plugin tables.

    I am thinking about backing up and repopulating the database but I have no idea if this will help.

    I would say 85% of new posts now get this error.

    --------------------------------------------------------
    WordPress database error: [Duplicate entry '' for key 2]
    INSERT INTO wp_terms (name, slug, term_group) VALUES ('', '', '0')

    WordPress database error: [Duplicate entry '0-post_tag' for key 2]

    INSERT INTO wp_term_taxonomy (term_id, taxonomy, description, parent, count) VALUES ('0', 'post_tag', '', '0', '0')

    Warning: Cannot modify header information - headers already sent by (output started at /xxx/xxxx/xxxxxx/xxxxx/domains/xxxxxxx.com/html/wp-includes/wp-db.php:160) in/xxx/xxxx/xxxxxx/xxxxx/domains/xxxxxxx.com//html/wp-includes/pluggable.php on line 391

  5. cyrillsneer
    Member
    Posted 6 years ago #

    bump.

    Is there are any other resources someone could point me in the direction of, our blog is basically crippled until I fix this.

Topic Closed

This topic has been closed to new replies.

About this Topic