Harleypete40 Posted October 18, 2005 Share Posted October 18, 2005 (edited) Hi, I have just installed the price break contribution, and when I try to access the store front as well as the admin section, I get the error below. Can anybody please help me out here? I did add all the columns in to the database with phpMyAdmin. At least I think I did as I am not that good with PhP. Thanks 1054 - Unknown column 'p.products_price1' in 'field list' select pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_qty, p.products_qty_blocks, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '44' order by pd.products_name limit 0, 20 [TEP STOP] Edited October 18, 2005 by Harleypete40 Quote Link to comment Share on other sites More sharing options...
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.