Ready to get started?Download WordPress


[resolved] WP-Spotify Duplicate entry '' for key 1 (7 posts)

  1. blitz999
    Posted 3 years ago #

    Once actiated, if you make more than one post, you get this error on saving the post:

    Duplicate entry '' for key 1

    It messes up the post save/edit/trash.

    Great idea though!

  2. cjraven
    Posted 3 years ago #

    Same happening for me. One of the wp-spotify tables in the db needs to auto-increment, problem is, knowing which one!
    Using phpMyAdmin I can browse table structure, but it's a hit 'n miss effort to figure out WHICH is the primary key, and should therefore auto-increment.

    If I find out (more by sheer luck than knowledge) I'll post the result.

  3. KATREyuk
    Posted 2 years ago #

    A solution for WordPress 3.x database problems can be found at:

    As plugin developer was not fixing that, I found someone that had fixed it, and I'm sharing the fix on my site.

  4. cjraven
    Posted 2 years ago #

    Matt Davies has updated this plugin to fix the issue. You can download the replacement (wp-spotify 1.1) here: http://www.mattdavies.gb.net/?p=141 or from @KATREyuk who also kindly made it available on his site http://www.peorparaelsol.com/2011/10/09/solucion-a-problemas-con-wp-spotify-en-wordpress-3-x-wp-spotify-fix/

    A huge thanks to Matt Davies for fixing this!!!!

  5. cjraven
    Posted 2 years ago #

    Now this topic needs to be marked SOLVED, 'cos it is! :D

  6. doctorcilantro
    Posted 2 years ago #

    I'm using 1.1 and I get the same error. Just installed and using WP 3.2.1

  7. cjraven
    Posted 2 years ago #

    @doctorcilantro: Are you sure you emptied ("truncated" if working from the command line) the db table wp_spotify before you installed the fixed plugin? It sounds as if there's still something in that table.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic