Guest Posted February 24, 2007 Posted February 24, 2007 Fresh install of 2.2, fresh upload of latest Margin Report. If db managed with phpMyAdmin 2.2.3 no problem. If managed with 2.9.1 following error occurs: 1054 - Unknown column 'p.products_id' in 'on clause' select count(*) as total from products p, products_to_categories p2c, categories c, products_description pd left join specials s on p.products_id = s.products_id where pd.language_id = '1' and p.products_id = pd.products_id and p2c.products_id = p.products_id and c.categories_id = p2c.categories_id Tks Oh. Always was a great contrib. Now may be better. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.