Hi, I can successfully create a DNS SOA using the API. However when I try to create an A record for that zone I get the below error. I am using the pre-build file from the remoting_client\examples folder (dns_ds_add.php) Code: <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><SOAP-ENV:Body><SOAP-ENV:Fault><faultcode>database_error</faultcode><faultstring>Incorrect integer value: '' for column `dbispconfig`.`dns_rr`.`sys_userid` at row 1 INSERT INTO `dns_rr` (`server_id`, `zone`, `name`, `type`, `data`, `ttl`, `active`, `stamp`, `serial`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`) VALUES ('1', '10', 'test.uk', 'a', '192.168.1.88', '3600', 'y', '2023-03-01 16:59:49', '1', '', '', 'riud', 'riud', '')</faultstring></SOAP-ENV:Fault></SOAP-ENV:Body></SOAP-ENV:Envelope> SOAP Error: Incorrect integer value: '' for column `dbispconfig`.`dns_rr`.`sys_userid` at row 1 INSERT INTO `dns_rr` (`server_id`, `zone`, `name`, `type`, `data`, `ttl`, `active`, `stamp`, `serial`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`) VALUES ('1', '10', 'test.uk', 'a', '192.168.1.88', '3600', 'y', '2023-03-01 16:59:49', '1', '', '', 'riud', 'riud', '') My Parameters: Code: //* Set the function parameters. $client_id = 1; $params = array( 'server_id' => 1, 'zone' => '10', 'name' => 'test.uk.', 'type' => 'a', 'data' => '192.168.1.88', 'aux' => '0', 'ttl' => '3600', 'active' => 'y', 'stamp' => '2023-03-01 16:59:49', 'serial' => '1', ); The error seems to point to sys_userid not being specified. I have tried adding this field to the parameters with the value of 0 but the error persists. Any Ideas to point me in the right direction would be much appreciated? Kindest Regards Colin
Do not specify sys_userid. The issue is that there seems to be no client with client_id = 1 on your system.