Jump to content

Module statscatalog


Recommended Posts

Bonjour,
Je suis sur la version 1.2.1.0 et je viens de m'apercevoir d'un bug pour le module statscatalog.
L'erreur MySQL retournée est :

Unknown column 'p.id_product' in 'on clause'

       SELECT SUM(od.`product_quantity`) AS bought
       FROM `ps_orders` o
       LEFT JOIN `ps_order_detail` od ON o.`id_order` = od.`id_order`
       LEFT JOIN `ps_category_product` cp ON cp.`id_product` = p.`id_product`
       WHERE o.valid = 1
       AND cp.`id_category` = 2



La table products n'est pas jointe à la requete donc il ne comprend pas le p.id_product c'est normal.
ça se passe dans la fonction getTotalBought().

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...