sql error on mysql user selection
DB::query(SELECT client.contactname, client.name, client.client_id FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = 2) -> mysqli_query Unknown column 'client.contactname' in 'field list'#0 db->query(SELECT client.contactname, client.name, client.client_id FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = 2) called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:125] #1 (closed) db->queryOneRecord(SELECT client.contactname, client.name, client.client_id FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = 2) called at [/usr/local/ispconfig/interface/web/sites/database_user_edit.php:69] #2 (closed) page_action->onShowEnd() called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:513] #3 (closed) tform_actions->onShow() called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:70] #4 (closed) tform_actions->onLoad() called at [/usr/local/ispconfig/interface/web/sites/database_user_edit.php:222] DB::query(SELECT sys_group.groupid, sys_group.name, CONCAT(client.company_name,' :: ',client.contact_name) as contactname FROM sys_group, client WHERE sys_group.client_id = client.client_id AND client.parent_client_id = ORDER BY sys_group.name) -> mysqli_query You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY sys_group.name' at line 1#0 db->query(SELECT sys_group.groupid, sys_group.name, CONCAT(client.company_name,' :: ',client.contact_name) as contactname FROM sys_group, client WHERE sys_group.client_id = client.client_id AND client.parent_client_id = ORDER BY sys_group.name) called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:111] #1 (closed) db->queryAllRecords(SELECT sys_group.groupid, sys_group.name, CONCAT(client.company_name,' :: ',client.contact_name) as contactname FROM sys_group, client WHERE sys_group.client_id = client.client_id AND client.parent_client_id = ORDER BY sys_group.name) called at [/usr/local/ispconfig/interface/web/sites/database_user_edit.php:73] #2 (closed) page_action->onShowEnd() called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:513] #3 (closed) tform_actions->onShow() called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:70] #4 (closed) tform_actions->onLoad() called at [/usr/local/ispconfig/interface/web/sites/database_user_edit.php:222] DB::query(SELECT groupid FROM sys_group WHERE client_id = ) -> mysqli_query You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1#0 db->query(SELECT groupid FROM sys_group WHERE client_id = ) called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:125] #1 (closed) db->queryOneRecord(SELECT groupid FROM sys_group WHERE client_id = ) called at [/usr/local/ispconfig/interface/web/sites/database_user_edit.php:74] #2 (closed) page_action->onShowEnd() called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:513] #3 (closed) tform_actions->onShow() called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:70] #4 (closed) tform_actions->onLoad() called at [/usr/local/ispconfig/interface/web/sites/database_user_edit.php:222]