1054 issue

[rfcalloway]

When a customer tries to retrieve his/her payment history, they're receiving this error (or one similar)

 

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

 

select products_manufacturer, orders_products_id, products_name, products_model, products_price, products_tax, products_quantity, final_price from orders_products where orders_id = '288'

 

[TEP STOP]

 

__________________

 

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

 

select products_manufacturer, orders_products_id, products_name,

products_model, products_price, products_tax, products_quantity, final_price

from orders_products where orders_id = '1'

 

[TEP STOP]

 

Thanks!

[wizardsandwars]

You are missing the field in your database that this SQL is trying to access. Try creating a 'products_manufacturer' column in the 'orders_products' table.