Database errors after WP2DB upgrade

  • Resolved Polk011

    (@polk011)


    11 years, 9 months ago

    I just upgraded to version 1.5 and get these error messages at the top when I click on the WP2DP tab:

    WordPress database error: [Duplicate entry ‘oauth_state’ for key ‘PRIMARY’]
    INSERT INTO wp_wpb2d_options (name,value) VALUES (‘oauth_state’,’access’)

    WordPress database error: [Duplicate entry ‘request_token’ for key ‘PRIMARY’]
    INSERT INTO wp_wpb2d_options (name,value) VALUES (‘request_token’,”)

    WordPress database error: [Duplicate entry ‘request_token_secret’ for key ‘PRIMARY’]
    INSERT INTO wp_wpb2d_options (name,value) VALUES (‘request_token_secret’,”)

    WordPress database error: [Duplicate entry ‘access_token’ for key ‘PRIMARY’]
    INSERT INTO wp_wpb2d_options (name,value) VALUES (‘access_token’,’ppi9n5v5ofh1c48′)

    WordPress database error: [Duplicate entry ‘access_token_secret’ for key ‘PRIMARY’]
    INSERT INTO wp_wpb2d_options (name,value) VALUES (‘access_token_secret’,’rcjflhumczmrkpe’)

    I haven’t tried a back-up yet but any idea what these errors are for and how to fix them?

    https://www.ads-software.com/extend/plugins/wordpress-backup-to-dropbox/

Viewing 7 replies - 1 through 7 (of 7 total)

  • I have a massive php error log full of what looks to be exactly the same type of errors.

    Massive list

    Plugin Contributor Michael De Wildt

    (@michaeldewildt)

    Gday,

    Hmm… this is not good. I am looking into it.

    Cheers,
    Mikey

    Plugin Contributor Michael De Wildt

    (@michaeldewildt)

    I have just pushed a fix for this.

    It was to do with this feature that must have been off on my testing boxes and on for yours.

    https://codex.www.ads-software.com/Class_Reference/wpdb#Show_and_Hide_SQL_Errors

    I plan to do a formal 1.5.1 release tonight, in the meantime you can re install the plugin to get the changes.

    Let me know how you go.

    Cheers,
    Mikey

    I downgraded to the previous version. I had gotten it to work without any issues for my ~250mb backup, so I’m just going to sit tight for the next release ??

    Thanks for all your hard work!

    Plugin Contributor Michael De Wildt

    (@michaeldewildt)

    1.5.1 has been released. Please let me know if there are any more issues.

    Cheers,
    Mikey

    Thread Starter Polk011

    (@polk011)

    Just downloaded 1.5.1 and no more issues. Thanks for the hard work on getting this fixed so quickly!

    I tried to update (as opposed to re-install) and came up with the 500 internal server error message. Luckily I had copied my folder and switched the names around just in case so it wasn’t a big deal. Any thoughts? Should I do a full re-install?
    It mentions access levels. Is there certain file permissions I should double check?

    500 error

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Database errors after WP2DB upgrade’ is closed to new replies.