after the upgrade creating new domains on the client side throws an error first : #0 db->query(SELECT server_id, server_name FROM server WHERE server_id IN () called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:158] #1 db->queryAllRecords(SELECT server_id, server_name FROM server WHERE server_id IN () called at [/usr/local/ispconfig/interface/web/dns/dns_wizard.php:137] second : error_no_server_id sorry my English
I've tested the dns wizard whilelogged in as client and it works fine. I guess that the clinet that you used to create the dns zone has no default dns server set in its limits or that the dns server that is set there has been removed. go to the client limits, ensure that a dns server is set and press save.
are former users with functional configurations ... dns_wizard.php ispconfig 3.0.5.4p1 SELECT dns_servers FROM sys_group ? something is not right I comment else { // $error .= $app->lng('error_no_server_id').'<br />'; } fix ugly but functional.
You refer to this code? $client = $app->db->queryOneRecord("SELECT default_dnsserver FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = $client_group_id"); The query is correct. There must be a problem with your user database if this query fails. What you posted as a fix above causes the system to create invalid dns records as thy were missing the mandatry server_id. I tested this now on Ubuntu, Debian, Centos and on single and multiserver systems as admin, client and reseller, it always works correctly.
I just checked the code line number of the error that you posted above. In iSPConfig 3.0.5.4p1, there is no sql query in line 137 in file /usr/local/ispconfig/interface/web/dns/dns_wizard.php.Line 137 is: $_POST['domain'] = $app->functions->idn_encode($_POST['domain']); which is not related to a database query at all. so the wizard code that yu run on your server seems not to be the code that we releasedas ispconfig 3.0.5.4p1.
