Error Message in Admin - Can't See My Orders!

[Guest]

All of a sudden....I get the following error message when I take a look in admin to see/print/ship any orders that might have come in.

 

1054 - Unknown column 'o.payment_method' in 'field list'

select o.orders_id, o.customers_name, o.customers_group_id, o.customers_company, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '1' and o.customers_group_id = '0' and ot.class = 'ot_total' order by o.orders_id DESC limit 0, 20

[TEP STOP]
 

What happened?

 

Thanks in advance.

 

Greg

[Jack_mcs]

The error is saying a field in the database is missing. That particular field was not in all versions of oscommerce so it might be that you upgraded your version and the database wasn't converted correctly. The field will need to be added to the database but if that is what happened, then there are probably others that are missing too.