Post by elglorioso1907 » Sat Sep 15, 2018 3:39 am

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


Posts

Joined
Sat Sep 15, 2018 1:06 am

Post by cofran » Wed Dec 12, 2018 7:23 am

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!

User avatar
Active Member

Posts

Joined
Thu Oct 01, 2009 7:37 am
Location - Córdoba, Argentina
Who is online

Users browsing this forum: No registered users and 2 guests