Update Error -->

Discussion in 'Installation/Configuration' started by maho, Jun 15, 2011.

  1. maho

    maho New Member


    I've a Multi-Server Environment with:
    - Master with Web, FTP, MySQL, DNS
    - Slave 1 with MySQL, DNS
    - Slave 2 with Mail, DNS

    Running the updatescript on Slave 1 works fine.
    Then running the Script on Slave 2 get some SQL-Errors
    And last, running the script on the Master works fine

    Starting incremental database update.
    Loading SQL patch file: /tmp/ispconfig3_install/install/sql/incremental/upd_0002.sql
    ERROR 1060 (42S21) at line 1: Duplicate column name 'package_remote_functions'
    ERROR 1060 (42S21) at line 2: Duplicate column name 'customer_no'
    Loading SQL patch file: /tmp/ispconfig3_install/install/sql/incremental/upd_0003.sql
    ERROR 1091 (42000) at line 4: Can't DROP 'document_root_www'; check that column/key exists
    Loading SQL patch file: /tmp/ispconfig3_install/install/sql/incremental/upd_0004.sql

    How I can fix it?

  2. till

    till Super Moderator Staff Member ISPConfig Developer

    But every slave uses its own local mysql database as required by ispconfig? Or did you try to install the system with a shared mysql database for masters and slaves?
  3. maho

    maho New Member

    yes - every slave use its own local mysql db - I used your installguide for Multiserver (the update from to works fine)
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    According to the error messages, the database of the server where the update was applied was already up to date.
  5. maho

    maho New Member

    ok - Danke.

    Nothing to do and hope the next time it works ;)

Share This Page