♥Gyakutsuki Posted August 1, 2016 Share Posted August 1, 2016 Hello, I want know if you have the same pb like me on mysql 5.7 and on the file advanced_search_result.php #1055 - Expression #66 of SELECT list is not in GROUP BY clause and contains nonaggregated column 's.status' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by My sql is more restricted and seems there is a problem on that ? tk Regards ----------------------------------------- Loïc Contact me by skype for business Contact me @gyakutsuki for an answer on the forum Link to comment Share on other sites More sharing options...
MrPhil Posted August 2, 2016 Share Posted August 2, 2016 MySQL has, from time to time, tightened up its code to better match the formal SQL definition. It is possible that 5.7 has done this, again causing problems with osC code. If you would list the offending SQL query, perhaps someone could see if a behavioral difference can be expected with MySQL 5.7. Is this vanilla code, an add-on, or otherwise non-standard code? Link to comment Share on other sites More sharing options...
♥Gyakutsuki Posted August 2, 2016 Author Share Posted August 2, 2016 I found a solution to remove product_sort_order than I inserted in order by clause but it's customization I think. ! Regards ----------------------------------------- Loïc Contact me by skype for business Contact me @gyakutsuki for an answer on the forum Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.