mysql backup mess up in multiserver setup
changes in #4760 (closed) released with 3.1.7 version mess up mysql backup in multiserver setup where web server are separated from db server.
All backup done are saved in /var/backup/web0 and are not diplayed in website backup list.
Eg. website in server1 access db remotely from server2
server1 have only web service enabled
server2 have only db service enabled
This query in install/sql/incremental/upd_dev_collection.sql when running in a db server set all parent_domain_id to 0 because web_domain table not have any data.
as d LEFT JOINweb_domain
as w ON (w.domain_id = d.parent_domain_id) SET d.parent_domain_id = 0 WHERE w.domain_id IS NULL AND d.parent_domain_id != 0;
Temporary manual workaround: in each website backup tab change, save and change-back and save again a value. Note that an ISPConfig update will re-apply the wrong behaviour.