Fatal error: Uncaught exception 'ErrorException' with message 'Error: Expression #1 of ORDER BY

Hi, I'm migrating my store from a vps to a dedicated one, the migration was without errors, but on the main page I get an error, I searched the entire forum, but I can not find anything, the error is as follows:

-------------
Fatal error: Uncaught exception 'ErrorException' with message 'Error: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column '.pd.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by<br />Error No: 1055<br />SELECT DISTINCT ps.product_id, (SELECT AVG(rating) FROM oc_review r1 WHERE r1.product_id = ps.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating FROM oc_product_special ps LEFT JOIN oc_product p ON (ps.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND ps.customer_group_id = '8' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) GROUP BY ps.product_id ORDER BY LCASE(pd.name) ASC, LCASE(pd.name) ASC LIMIT 0,5' in /home in /home/user/public_html/system/database/mysql.php on line 40
----------------------

Help please, thanks...

mysql.php
Before you do anything else, change your both config.php File
Lines from:
define('DB_DRIVER', 'mysql');
to:
define('DB_DRIVER', 'mysqli');
and try again.
Ernie

Thanks Ernie, I have changed the path to mysqli as you indicate and it remains the same, I think it is the same error, in the link you can see it live...

Thanks,
Fco Javier Medina

Well, I am an fullpro UnPro, when it comes to such, but at least,
it's so not related with the outdated mysql Setting. But I assume,
that some Pro will have a usable answer on this anyway!
It's related with this: pigeonsp_tiendapigeons.pd.name
so, is this pigeonsp really your db_prefix , and that
tiendapigeons a valid DB Table/Column Name ?
Good Luck!
Ernie

It can be by some module or extension of php?...

is valid, is the database, and is a user, .pd.name I do not know where it comes from ...

Hello,
I would be happy to help. Please mail me at: gabriel.cisin20@gmail.com and add me on skype: gabriel@cisinlabs.com to discuss more.
Looking forward to hearing you soon.
Regards
Gabriel

instead of it do this I hope that will solve your problem. If you are unable to do that please contact me at md@anaisystechnologies.com

shivankagrawal wrote: ↑

Sat Sep 15, 2018 2:40 pm

instead of it

Code: Select all

GROUP BY ps.product_id ORDER BY LCASE(pd.name) ASC, LCASE(pd.name)

do this

Code: Select all

GROUP BY ps.product_id, pd.name ORDER BY LCASE(pd.name) ASC, LCASE(pd.name)

I hope that will solve your problem. If you are unable to do that please contact me at md@anaisystechnologies.com

Can you mention the file or tpl for him as well

Thank you very much Shivank, the line is in database / table or file?... file name please...

it should be in catalog/model product class

This is the Commercial Support forum, so please if you're posting here it is to pay for a developer to fix this for you, not for free support.

You can ask for free support in the General Support forum.

If you'd like one of our developers to fix this for you, please email info@antropy.co.uk with all the details for a quote.