Guest Posted February 24, 2007 Share Posted February 24, 2007 Sorry if this is cross posted from main category, got confused with new forum layout. Been away a while. 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 Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.