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

[Guest]

Hi all,

 

getting this error when I try to edit an order in admin.

 

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

 

select products_options, products_options_values, options_values_price, price_prefix from orders_products_attributes where orders_id = '7' and orders_products_id = '8'

 

Any ideas

 

TIA

[Mark Evans]

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

 

Any ideas

 

Check the database to make sure this field exists??

 

Have you made any changes to the database or admin/orders.php??

[Guest]

no i haven't done anything to site for ages and it was working fine back then.

 

I didn't change anything... where shall I start looking to find 1054 - Unknown column 'options_values_price' in 'field list'

[Mark Evans]

where shall I start looking to find 1054 - Unknown column 'options_values_price' in 'field list'

 

First check the databasein the orders_products_attributes table to see if this field exists.

 

If not create it

 

ALTER TABLE `orders_products_attributes` ADD `options_values_price` decimal(15,4) NOT NULL AFTER `products_options_values`;

[Guest]

Cheers, checked table and found a typo... had calues not values... I hadn't touched it but anyway..

 

Another problem I seem to have lost my ?0.00 it just shows 0 in products????

[Guest]

there's more...

 

had a look at admin prods. If price of product is say?10.00 when preview it shows 0 ??

[Mark Evans]

had a look at admin prods. If price of product is say?10.00 when preview it shows 0 ??

 

Make sure you have the currency configured properly.

 

When did you download the snapshot??

[grumster]

Hi,

 

My site has went live and when I go to view an order I get the following error:

 

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

 

select banktransfer_prz, banktransfer_status, banktransfer_owner, banktransfer_number, banktransfer_name, banktransfer_blz, banktransfer_fax, customers_name, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, comments, currency, currency_value, date_purchased, orders_status, last_modified from orders where orders_id = '13'

 

I have checked admin/orders.php and there is no mention of the banktransfer fields etc for the query. All the standard fields exist in the database. Where can I ammed the query to resolve this.

 

Please help-I need to update my orders!

 

Thanks

 

Graham