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` )
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...)
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.