1054 - Unknown column 'image_display' in 'field list'

[Guest]

Whenever I attempt to add or update a product to the website I receive the following error:

 

1054 - Unknown column 'image_display' in 'field list'

 

update products set products_quantity = '999999', products_model = 'EW5304-55L', image_display = '', products_price = '295.00', products_date_available = null, products_height = '12.00', products_length = '12.00', products_width = '12.00', products_ready_to_ship = '', products_status = '1', products_tax_class_id = '0', manufacturers_id = '5', products_weight = '1', products_image = 'ext/EW5304-55L.jpg', products_last_modified = now() where products_id = '1059'

 

[TEP STOP]

 

I'm not sure what cause the problem so I don't know what the solution is. Any ideas?

 

 

osCommerce 2.3.1

PHP 5.2

mySQL 5

Apache

[Guest]

I think it might have been caused when I have added the UPSXML,dimensional support. I solved it by placing this into the database ALTER TABLE `products` ADD `image_display` VARCHAR( 64 ) NULL

and of course that fixed it.

[Guest]

THANK YOU!!! I had this exact issue when updating my USPS module which required me to add the UPSxml contribution.

Phew. Didn't realize I'd have to install all this other stuff!

[MrPhil]

Presumably Tom missed a step in the original install where you update the database to add the new field. I don't think that's exactly the same as Kristin's problem. (Is UPSxml a prereq for USPS? That would be odd, as UPS and USPS are competitors. Or is that "USPSxml"?) But, if it fixed it, it fixed it.