ISPcofig removing newly added database column causes SQL Replicate error

Discussion in 'Plugins/Modules/Addons' started by Ucha, Mar 24, 2014.

  1. Ucha

    Ucha New Member

    Recently, I added a "mongo_plugin" column into mysql on my IspConfig server. But after not having achieved the intended goal, I removed the "mongo_plugin" column from each table.

    And the error showing up at Monitor error messages is the following:

    Replication failed. Error: (web_domain) in MySQL server: (localhost) Unknown column    'mongo_plugin' in 'field list' # SQL: REPLACE INTO web_domain
    Here Serverfault thread :
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    The error means that your modifications caused the databases to be out of sync. ensure that the column is removed from all tables on all servers and that you remove it on the mastre first, then wait until no jobs show up as pending in the jobqueue and thenr emove it on all slaves.
  3. Ucha

    Ucha New Member

    Thank you Till, you helped me a lot.. I'v done exactly as you said and it worked ! :D Thanks man you saved my day

Share This Page