Remote-API sites_web_domain_update not working and returns invalid SOAP response
I'm using ispconfig 3.0.5.4p8 and a master / slave environment (both apache 2.2 / php 5.4).
When I try to update some fields using the remote api on the slave, I get the following error when I do this soap call $client->sites_web_domain_update:
PHP Fatal error: Uncaught SoapFault exception: [Client] looks like we got no XML document in ...myScriptName
Inspecting the soap response, it seems like ispconfig errored out and returned a broken mysql querystring instead of a valid soap response.
The response looked like this:
#0 db->query(UPDATE `web_domain` SET `server_id` = '2', ...(I shortened the string)...,
`added_by` = 'X-Coder', `sys_userid` = , `sys_groupid` = WHERE domain_id = 10)
called at [/usr/local/ispconfig/interface/lib/classes/remoting.inc.php:3368]
#1 remoting->updateQueryExecute(UPDATE `web_domain` SET `server_id` = '2', ...
You can see sys_userid
= , sys_groupid
= which is wrong syntax (missing quotes), it should not be empty after the equal sign.
And why is sys_userid and sys_groupid both empty anyway at the update? I have ids in the table columns, and the array I initialized with $client->sites_web_domain_get contained the data for sys_userid and sys_groupid too. But somewhere during the update it got lost.
I used this example code: https://git.ispconfig.org/ispconfig/ispconfig3/blob/stable-3.0.5/remoting_client/examples/sites_web_domain_update.php The only difference to the example code is, I tried to change the ssl_key, ssl_cert, ssl_bundle, ssl_action fields instead of the ones from example.