WordPress.org

Ready to get started?Download WordPress

Forums

Twitter Tools
WordPress database error - Duplicate entry for key 2 for quer (3 posts)

  1. phinx
    Member
    Posted 2 years ago #

    I have recently started getting the following error, would appreciate any assistance in resolving it, Thanks!

    [22-Sep-2011 15:37:27] WordPress database error Duplicate entry '116898073128607744' for key 2 for query
    INSERT
    INTO wp_ak_twitter
    ( tw_id
    , tw_text
    , tw_reply_username
    , tw_reply_tweet
    , tw_created_at
    , modified
    )
    VALUES
    ( '116898073128607744'
    , 'Troy Davis and the state of American justice | Megan Carpentier http://t.co/9AKqsZmI via @guardian'
    , ''
    , ''
    , '2011-09-22 15:34:07'
    , NOW()
    )
    made by shutdown_action_hook, do_action, call_user_func_array, aktt_update_tweets, aktt_tweet->add

    http://wordpress.org/extend/plugins/twitter-tools/

  2. staze
    Member
    Posted 2 years ago #

    This isn't an issue, it's just mysql throwing the error.

    Used to be, Twitter Tools would grab duplicate tweets in the DB, and you'd end up with crap in there several times. To fix it, Alex just turned on the unique value for the tweet ID, so it throws this error whenever it tries to put in the same tweet again.

    While not the cleanest want to do it, it was the easiest. =/ You can safely ignore the error... as annoying as it is.

  3. phinx
    Member
    Posted 2 years ago #

    Staze, really appreciate the explanation, thanks so much!

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic