NicoC Posted December 6, 2017 Share Posted December 6, 2017 Hi, from the back office/ catalog/ product - I can not see my products , all I get is an error message : Bad SQL query Expression #12 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'easydeal_98x.sav.quantity' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by' from the shop front end, I can see categories but no products either. Asked web hosting, they said there is no SQL changes recently and is more likely to be prestashop issue. Can someone show me a light, please? Link to comment Share on other sites More sharing options...
FutureLED Posted October 14, 2018 Share Posted October 14, 2018 did you ever get a resolution for this? I have same problem Link to comment Share on other sites More sharing options...
musicmaster Posted October 14, 2018 Share Posted October 14, 2018 This is a MySql problem - that doesn't happen with MariaDb. MySql has introduced a year or so ago a kind of strict mode that gives this kind of errors. Prestashop disables that with the command 'SET SESSION sql_mode = \'\'' in dbPDO.php. It could be that you start your own session of MySql and that that misses this query. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now