[Plugin: Twitter Tools] WordPress database error – Duplicate entry for key 2 for quer

  • phinx

    (@phinx)


    12 years, 7 months 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/

Viewing 2 replies - 1 through 2 (of 2 total)
  • staze

    (@staze)

    12 years, 6 months 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.

    Thread Starter phinx

    (@phinx)

    12 years, 6 months ago

    Staze, really appreciate the explanation, thanks so much!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘[Plugin: Twitter Tools] WordPress database error – Duplicate entry for key 2 for quer’ is closed to new replies.