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]>