MYSQL ERROR
Error:Expression #9 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'truckaur_site.T2.Username' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Query:SELECT DISTINCT `T1`.*, `T2`.`Username`, `T2`.`First_name`, `T2`.`Last_name`, `T2`.`Photo`, `T3`.`Name`, IF(`T1`.`From` = '', `T1`.`To`, `T1`.`From`) AS `From` FROM `au_messages` AS `T1` LEFT JOIN `au_accounts` AS `T2` ON IF(`T1`.`From` = '', `T1`.`To`, `T1`.`From`) = `T2`.`ID` LEFT JOIN `au_admins` AS `T3` ON IF(`T1`.`From` = '', `T1`.`To`, `T1`.`From`) = `T2`.`ID` WHERE (`T1`.`To` = '' OR `T1`.`From` = '') AND ( FIND_IN_SET('from', `T1`.`Remove`) = 0 AND FIND_IN_SET('to', `T1`.`Remove`) = 0 ) GROUP BY `T1`.`ID` ORDER BY `ID` DESC
Function:getAll
Class:rlDb
File:/home/truckaurbus/public_html/includes/classes/rlMessage.class.php (line# 88)