sql error, sorting websites after servers, after selected a server
Hello,
If a show all websites, and then select a webserver on server list, and then choose sort servers, ISPConfig show's me following error.
#0 db->query(SELECT web_domain.* FROM web_domain LEFT JOIN server as s ON web_domain.server_id = s.server_id WHERE type = 'vhost' AND parent_domain_id = '0' and server_id = '14' ORDER BY s.server_name, domain LIMIT 0, 15) called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:158] #1 (closed) db->queryAllRecords(SELECT web_domain.* FROM web_domain LEFT JOIN server as s ON web_domain.server_id = s.server_id WHERE type = 'vhost' AND parent_domain_id = '0' and server_id = '14' ORDER BY s.server_name, domain LIMIT 0, 15) called at [/usr/local/ispconfig/interface/lib/classes/listform_actions.inc.php:88] #2 (closed) listform_actions->onLoad() called at [/usr/local/ispconfig/interface/web/sites/web_domain_list.php:57]