MySQL error under Support > Send Message
DB::query(SELECT sys_user.userid, CONCAT(sys_user.username,' :: ',client.company_name,' :: ',client.contact_name) as contactname FROM sys_user, client WHERE sys_user.userid != 1 AND sys_user.client_id = client.client_id AND ((sys_userid = 2 AND sys_perm_user like '%r%') OR (sys_groupid IN (2) AND sys_perm_group like '%r%') OR sys_perm_other like '%r%') ORDER BY sys_user.username) -> mysqli_query Column 'sys_userid' in where clause is ambiguous#0 db->query(SELECT sys_user.userid, CONCAT(sys_user.username,' :: ',client.company_name,' :: ',client.contact_name) as contactname FROM sys_user, client WHERE sys_user.userid != 1 AND sys_user.client_id = client.client_id AND ((sys_userid = 2 AND sys_perm_user like '%r%') OR (sys_groupid IN (2) AND sys_perm_group like '%r%') OR sys_perm_other like '%r%') ORDER BY sys_user.username) called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:111] #1 (closed) db->queryAllRecords(SELECT sys_user.userid, CONCAT(sys_user.username,' :: ',client.company_name,' :: ',client.contact_name) as contactname FROM sys_user, client WHERE sys_user.userid != 1 AND sys_user.client_id = client.client_id AND ((sys_userid = 2 AND sys_perm_user like '%r%') OR (sys_groupid IN (2) AND sys_perm_group like '%r%') OR sys_perm_other like '%r%') ORDER BY sys_user.username) called at [/usr/local/ispconfig/interface/lib/classes/tform.inc.php:257] #2 (closed) tform->getDatasourceData(Array ([datatype] => INTEGER,[formtype] => SELECT,[default] => ,[datasource] => Array ([type] => SQL,[querystring] => SELECT sys_user.userid, CONCAT(sys_user.username,' :: ',client.company_name,' :: ',client.contact_name) as contactname FROM sys_user, client WHERE sys_user.userid != 1 AND sys_user.client_id = client.client_id AND {AUTHSQL} ORDER BY sys_user.username,[keyfield] => userid,[valuefield] => contactname),[validators] => Array ([0] => Array ([type] => ISINT,[errmsg] => recipient_id_is_not_integer)),[value] => Array ([1] => Administrator)), Array ()) called at [/usr/local/ispconfig/interface/lib/classes/tform.inc.php:507] #3 (closed) tform->getHTML(Array (), message, NEW) called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:516] #4 (closed) tform_actions->onShowNew() called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:471] #5 (closed) tform_actions->onShow() called at [/usr/local/ispconfig/interface/web/help/support_message_edit.php:50] #6 (closed) page_action->onShow() called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:70] #7 (closed) tform_actions->onLoad() called at [/usr/local/ispconfig/interface/web/help/support_message_edit.php:69] Column 'sys_userid' in where clause is ambiguous