GitLab

MariaDB server version for the right syntax to use near '= 'my.domain' LIMIT 0,1' at line 1```

I get this when clicking the SSL-tab for an XMPP-Domain. I dug a little through /usr/local/ispconfig/interface/web/mail/xmpp_domain_edit.php and found the following in line 405: 

```php
$soa = $app->db->queryOneRecord("SELECT id AS zone, sys_userid, sys_groupid, sys_perm_user, sys_perm_group, sys_perm_other FROM dns_soa WHERE active = 'Y' AND  = ?", $this->dataRecord['domain'].'.');

As you can see the AND part is missing a domain field, which seems to be "origin", so changing the line to

$soa = $app->db->queryOneRecord("SELECT id AS zone, sys_userid, sys_groupid, sys_perm_user, sys_perm_group, sys_perm_other FROM dns_soa WHERE active = 'Y' AND  origin = ?", $this->dataRecord['domain'].'.');

fixes the error. However I have no idea about XMPP and if the SSL-Tab there makes sense as it is or if I interpret the code the right way, so I'd be glad if someone more experienced with this could take a look.