Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

MYSQL 5.7 and advanced search, pb sql


Recommended Posts

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

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

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...