Update Error 3.0.3.2 --> 3.0.3.3

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

  1. maho

    maho New Member

    Hi,

    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

    Errors:
    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?

    Marc
     
    maho, Jun 15, 2011
    #1
  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?
     
    till, Jun 15, 2011
    #2
  3. maho

    maho New Member

    yes - every slave use its own local mysql db - I used your installguide for Multiserver (the update from 3.0.3.1 to 3.0.3.2 works fine)
     
    maho, Jun 15, 2011
    #3
  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.
     
    till, Jun 15, 2011
    #4
  5. maho

    maho New Member

    ok - Danke.

    Nothing to do and hope the next time it works ;)
     
    maho, Jun 15, 2011
    #5

Share This Page