Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

1054 - Unknown column 'p.products_image_med' in 'field list'


Recommended Posts

I received this error after adding contributions quantity for product attributes and ez quickbooks. I'm a newbie and have most of the store up and operational. (not a public site yet) I needed the quantity product attributes as I am selling children's clothing. (Need it especially for the sizes and want to have quantity by size). I have spent the past 18 hours looking through the posts, trying to solve it myself and can't find this exact issue. Oh by the way, I am using the latest version of osCommerce v2.2 RC2a. Here is the entire error:


1054 - Unknown column 'p.products_image_med' in 'field list'


select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, p.products_image_med, p.products_image_lrg, p.products_image_sm_1, p.products_image_xl_1, p.products_image_sm_2, p.products_image_xl_2, p.products_image_sm_3, p.products_image_xl_3, p.products_image_sm_4, p.products_image_xl_4, p.products_image_sm_5, p.products_image_xl_5, p.products_image_sm_6, p.products_image_xl_6, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from products p, products_description pd where p.products_status = '1' and p.products_id = '31' and pd.products_id = p.products_id and pd.language_id = '1'




I would really appreciate one of the gurus assistance.


Thanks in advance. :blush:

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...