Group by statement has ASC attached and can give syntax error

OldNGreyBMR / export_shipping_information

Export Shipping Information

0 stars 1 forks source link

Group by statement has ASC attached and can give syntax error #4

Closed OldNGreyBMR closed 8 months ago

OldNGreyBMR commented 8 months ago

SELECT COUNT( * ) AS max_num_of_products FROM (orders o LEFT JOIN orders_products op ON o.orders_id = op.orders_id), orders_total ot WHERE o.orders_id = ot.orders_id AND ot.class = 'ot_shipping' GROUP BY o.orders_id ASC ORDER BY max_num_of_products DESC error in the code has been there since v1.2.2 with zc1.3.7. Zen cart forum link https://www.zen-cart.com/showthread.php?75406-Export-Shipping-amp-Order-Information&p=1399125#post1399125

OldNGreyBMR commented 8 months ago

resolved with v1.5.0.a for both zc157 and zc158

OldNGreyBMR commented 8 months ago

resolved in v1.5.1