1054 - Unknown column 'products_options_id' in 'fi

[nkientoff]

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'

 

[TEP STOP]

 

This error happens when I try to view an order.

 

TIA

[bluepony]

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?

[nkientoff]

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.

[nkientoff]

What file is creating this error? product_info.php?