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

  1. blitz999
    Posted 4 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. Captain Bogwash
    Posted 4 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 4 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. Captain Bogwash
    Posted 4 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. Captain Bogwash
    Posted 4 years ago #

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

  6. doctorcilantro
    Posted 4 years ago #

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

  7. Captain Bogwash
    Posted 4 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

  • WP-Spotify
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic