Version 8.6 Breaks MySQL Replication

  • Resolved Ed

    (@coopeh)


    11 years, 4 months 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/

Viewing 3 replies - 1 through 3 (of 3 total)
  • mattyrob

    (@mattyrob)

    11 years, 4 months 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?

    Thread Starter Ed

    (@coopeh)

    11 years, 4 months 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

    mattyrob

    (@mattyrob)

    11 years, 4 months ago

    @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 ‘Version 8.6 Breaks MySQL Replication’ is closed to new replies.