Jump to content
Sign in to follow this  
tmckee

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

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×