Invalid SQL Syntax in XMPP-Domain => SSL
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.