Forums

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

  1. blitz999
    Member
    Posted 12 months 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
    Member
    Posted 10 months 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
    Member
    Posted 7 months ago #

    A solution for WordPress 3.x database problems can be found at:
    http://www.peorparaelsol.com/2011/10/09/solucion-a-problemas-con-wp-spotify-en-wordpress-3-x-wp-spotify-fix/

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

  4. cjraven
    Member
    Posted 7 months 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
    Member
    Posted 7 months ago #

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

  6. doctorcilantro
    Member
    Posted 7 months ago #

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

  7. cjraven
    Member
    Posted 7 months 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.

Reply

You must log in to post.

About this Plugin

About this Topic

Tags