购物车为空

Aftersales Email Module: Satisfaction Survey


This plugin allows you to send an automated email to your customers several days after they have purchased something from your store. The email will list products they have purchased and will ask your customer if everything was OK, if they're satisfied and will let them know they can contact you in case of problems.


插件版本: 1.1

该商品加入分类的日期为 2015年 01月 03日

1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'zencart.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
in:
[select p.products_id, p.products_image from z138a_orders_products opa, z138a_orders_products opb, z138a_orders o, z138a_products p where opa.products_id = '12882' and opa.orders_id = opb.orders_id and opb.products_id != '12882' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = 1 group by p.products_id order by o.date_purchased desc limit 6]