SOAP API "dns_templatezone_add" error "Column 'xfer' cannot be null"

short description

The SOAP API process "dns_templatezone_add" is not working in the latest version of ISPConfig

the file:

interface/lib/classes/remote.d/dns.inc.php

line 132

correct behaviour

Small code modification.

environment

• Server OS: CentOS
• Server OS version: 7.6
• ISPConfig version: 3.1.5

proposed fix

Change the line:

			$xfer = $vars['xfer'];

to

			$xfer = '';

log entries

MySQL error output:

MariaDB [dbispconfig]> INSERT INTO `dns_soa` (`sys_userid`,`sys_groupid`,`sys_perm_user`,`sys_perm_group`,`sys_perm_other`,`server_id`,`origin`,`ns`,`mbox`,`serial`,`refresh`,`retry`,`expire`,`minimum`,`ttl`,`active`,`xfer`,`also_notify`,`update_acl`) VALUES ('2','2','riud','riud','','1','plusdedevis.com.','ns1.plusdedevis.com.','support.plusdedevis.com.','2019012501','7200','540','604800','3600','3600','Y',NULL,NULL,NULL);

ERROR 1048 (23000): Column 'xfer' cannot be null
MariaDB [dbispconfig]>