Jump to content

problems after update mySQL


Recommended Posts

Hallo

Ik have done en update of PHP and MySGL versions and now the front office appears to work but no products are shown. Also the back office vieuw is normal but when you click on orders or products the wrror appears

When I put debug on I get:

PrestaShopDatabaseException]

Expression #1 of ORDER BY clause is not in SELECT list, references column 'xxxxxx_knl.c.level_depth' which is not in SELECT list; this is incompatible with DISTINCT

I enclose the complete error message

Webshop is running on PS version 1.5.4.1

MySQL was 5.5.62 now 5.7.27

What can this be?

Thanks for your help !

debug error.png

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...