Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

1054 - Unknown column 'products_options_id' in 'fi


Recommended Posts

I have done a search for this error and understand what the problem is but I don't know what table to look in. How do I know what table to look in for this error. I have looked at products_options and products_options_id is listed so if that was the correct table then can someone give me some more insight on this problem?


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


select products_options_id, products_options, products_options_values_id, products_options_values, options_values_price, price_prefix from orders_products_attributes where orders_id = '1' and orders_products_id = '1'




This error happens when I try to view an order.



Link to comment
Share on other sites

It is looking for the field 'products_options_id' in the table 'orders_products_attributes'. That field does not exist in that table. Neither does 'products_options_values_id'. Those fields exist in 'products_options_values' and 'products_options_values_to_products_options' tables. Was this a contribution that you installed?

I'd rather be flying!

Link to comment
Share on other sites

I don't know when it happened. It has been a few days since I tried looking at an order and have done alot of changes since then.


I have added header tag controller - paypal shopping cart IPN - xsell - easy populate - a couple more I can't think of right now.


Plus alot of playing with the code in an attempt to learn how to change the look of my store.

Link to comment
Share on other sites


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

  • Create New...