Page 1 of 1

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

Posted: Sat Sep 15, 2018 3:39 am
by elglorioso1907
Hola,

Estoy pasando mi tienda de un vps a un dedicado, la migraci'on fue correcta y sin ningun error, pero me muestra el siguiente error en pagina principal:

---------------
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
-------------------

Alguien me puede ayudar por favor... llevo dos dias sin dormir y no doy con la soluci'on, la tienda offline....

Gracias...

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

Posted: Wed Dec 12, 2018 7:23 am
by cofran
Lo pudiste solucionar, parece ser un error en la versión del SQL que esta instalada en tu servidor. Si lo has solucionado, comenta que era en lo posible para otros usuarios que puedan tener tu mismo error

Éxitos!