Guest Posted January 6, 2008 Share Posted January 6, 2008 Folks, I have gone trough most of my files, which is kind of a pain since I have been going with oscommerce since 2002, have a lot of contributions installed, which gives me additional head aches. I have implemented all forum advise and bug fix on the '1054 - Unknown column' issue, replaced p.products_id = s.products_id with p2c.products_id = s.products_id Still I am having this error when I go to individual products: 1054 - Unknown column 'p.products_price5' in 'field list' select pd.products_name, p.products_model, p.products_image, p.products_id, p.manufacturers_id, p.products_price, p.products_weight, p.products_quantity, 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 from products p left join specials s on p.products_id = s.products_id, products_description pd where p.products_status = '1' and pd.products_id = p.products_id and p.products_id = '586' and pd.language_id = '1' [TEP STOP] I know you all have gone over this already before, but I floored. 15 hours of search and going...... Thanks so much. Wolfgang Link to comment Share on other sites More sharing options...
♥Vger Posted January 6, 2008 Share Posted January 6, 2008 The database field 'products_price5' does not exist in the 'product table in the database. Vger Link to comment Share on other sites More sharing options...
Guest Posted January 6, 2008 Share Posted January 6, 2008 Rhea, Thanks soooo much, that will get me going, I probably missed importing that table in a recent contribution. Thanks again. Wolfgang Link to comment Share on other sites More sharing options...
Guest Posted January 6, 2008 Share Posted January 6, 2008 The database field 'products_price5' does not exist in the 'product table in the database. Vger One more time, thanks, the fix was laughable easy, I am up and running. Test transaction worked and I have a new contribution in the process 'Quantity Price Breaks Per Product'. Take care, Wolfgang Link to comment Share on other sites More sharing options...
none_uk Posted January 6, 2008 Share Posted January 6, 2008 One more time, thanks, the fix was laughable easy, I am up and running. Test transaction worked and I have a new contribution in the process 'Quantity Price Breaks Per Product'. Take care, Wolfgang hey how did u fix this? i'm currently testing a template and it gives me that error. just delete 'products_price5' from database? Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted January 6, 2008 Share Posted January 6, 2008 No the exact opposite in fact. You have installed a contribution which requires this field, unfortunately you have not run the sql included with the contribution to create the field. My advice is start checking all the contribution installation, probably in reverse order Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.