WordPress.org

Ready to get started?Download WordPress

Forums

Subscribe2
[resolved] Version 8.6 Breaks MySQL Replication (4 posts)

  1. Ed
    Member
    Posted 1 year ago #

    Hi,

    Still in the debugging phase but thought I'd throw it out there incase I was right, I updated Subscribe2 on our Multisite install about an hour ago and since then we're getting MySQL errors that is breaking replication between servers.

    Last_SQL_Errno: 1060
    Last_SQL_Error: Error 'Duplicate column name 'conf_ip'' on query. Default database: 'bla_36'. Query: 'ALTER TABLE wp_1081_subscribe2 ADD conf_ip char(64) AFTER conf_time'

    Is this a problem with the plugin?

    Cheers,

    Ed

    http://wordpress.org/extend/plugins/subscribe2/

  2. mattyrob
    Member
    Plugin Contributor

    Posted 1 year ago #

    @Ed,

    That SQL statement is called by the WordPress core function maybe_add_column() so the code should bail out if the column already exists.

    Strange that this isn't happening on your install, have you seen the same before?

  3. Ed
    Member
    Posted 1 year ago #

    No, this is the first time. For the time being I've just added 1060 to the ignored slave errors. Just thought I'd let you know.

    Cheers,
    Ed

  4. mattyrob
    Member
    Plugin Contributor

    Posted 1 year ago #

    @Ed,

    Thanks Ed, I'll check on my own sites but I haven't see this before in all of the beta testing.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.