mysql backup mess up in multiserver setup
Hello,
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.
UPDATE
web_databaseas d LEFT JOIN
web_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.