Sapher Posted November 26, 2009 Share Posted November 26, 2009 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now