WordPress.org

Support

Support » Plugins and Hacks » Subscribe2 » [Resolved] Version 8.6 Breaks MySQL Replication

[Resolved] Version 8.6 Breaks MySQL Replication

  • 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/

Viewing 3 replies - 1 through 3 (of 3 total)
  • @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?

    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

    @ed,

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘[Resolved] Version 8.6 Breaks MySQL Replication’ is closed to new replies.
Skip to toolbar