strange error during upgrade

Discussion in 'General' started by maumar, Aug 23, 2014.

  1. maumar

    maumar New Member HowtoForge Supporter

    hello

    I am upgrading ispconfig from 3.0.5.3 to last stabel 3.0.5.4.p3
    This is a multi-server
    On main server cp, no error.
    I am getting this error on all other servers

    Code:
    
    Starting incremental database update.
    Loading SQL patch file: /tmp/ispconfig3_install/install/sql/incremental/upd_0056.sql
    Loading SQL patch file: /tmp/ispconfig3_install/install/sql/incremental/upd_0057.sql
    Loading SQL patch file: /tmp/ispconfig3_install/install/sql/incremental/upd_0058.sql
    Loading SQL patch file: /tmp/ispconfig3_install/install/sql/incremental/upd_0059.sql
    Loading SQL patch file: /tmp/ispconfig3_install/install/sql/incremental/upd_0060.sql
    Loading SQL patch file: /tmp/ispconfig3_install/install/sql/incremental/upd_0061.sql
    Loading SQL patch file: /tmp/ispconfig3_install/install/sql/incremental/upd_0062.sql
    Loading SQL patch file: /tmp/ispconfig3_install/install/sql/incremental/upd_0063.sql
    Loading SQL patch file: /tmp/ispconfig3_install/install/sql/incremental/upd_0064.sql
    Loading SQL patch file: /tmp/ispconfig3_install/install/sql/incremental/upd_0065.sql
    Loading SQL patch file: /tmp/ispconfig3_install/install/sql/incremental/upd_0066.sql
    Loading SQL patch file: /tmp/ispconfig3_install/install/sql/incremental/upd_0067.sql
    ERROR 1062 (23000) at line 1: Duplicate entry '0-' for key 'serverdomain'
    Loading SQL patch file: /tmp/ispconfig3_install/install/sql/incremental/upd_0068.sql
    Loading SQL patch file: /tmp/ispconfig3_install/install/sql/incremental/upd_0069.sql
    Loading SQL patch file: /tmp/ispconfig3_install/install/sql/incremental/upd_0070.sql
    Loading SQL patch file: /tmp/ispconfig3_install/install/sql/incremental/upd_0071.sql
    Loading SQL patch file: /tmp/ispconfig3_install/install/sql/incremental/upd_0072.sql
    Loading SQL patch file: /tmp/ispconfig3_install/install/sql/incremental/upd_0073.sql
    Loading SQL patch file: /tmp/ispconfig3_install/install/sql/incremental/upd_0074.sql
    Loading SQL patch file: /tmp/ispconfig3_install/install/sql/incremental/upd_0075.sql
    Loading SQL patch file: /tmp/ispconfig3_install/install/sql/incremental/upd_0076.sql
    Loading SQL patch file: /tmp/ispconfig3_install/install/sql/incremental/upd_0077.sql
    ERROR 1091 (42000) at line 1: Can't DROP 'serverdomain'; check that column/key exists
    Loading SQL patch file: /tmp/ispconfig3_install/install/sql/incremental/upd_0078.sql
    
    
    what is this "Duplicate entry '0-' for key 'serverdomain' "?
    and
    ERROR 1091 (42000) at line 1: Can't DROP 'serverdomain'; check that column/key exists


    Edit:

    here
    Code:
    grep -r serverdomain *
    incremental/upd_0068.sql:ALTER TABLE  `web_domain` ADD UNIQUE  `serverdomain` (  `server_id` ,  `domain` );
    incremental/upd_0078.sql:ALTER TABLE  `web_domain` DROP INDEX `serverdomain`, ADD UNIQUE  `serverdomain` (  `server_id` , `ip_address`, `domain` );
    ispconfig3.sql:  UNIQUE KEY `serverdomain` (  `server_id` , `ip_address`,  `domain` )
    
    
     
    Last edited: Aug 23, 2014
  2. maumar

    maumar New Member HowtoForge Supporter

    I have a bunch of domains (webdomain) 10 domains, with serverid = 0 and domain name null, as you can see in snapshot
    This is very strange as one cannot insert a new domain without entering the name in the form, and I have no script to create new domain by api (not yet...)
     

    Attached Files:

  3. till

    till Super Moderator Staff Member ISPConfig Developer

    Thats a database index

    The server_id may not be 0 for a domain and also type and domain may not be null. I guess you used some kind of custom script to add them as the ispconfig interface never allowed the insertion of empty domain names and it would not set server_id to 0 or type to 0.
     

Share This Page