Help with account_history_info.php

[camellia]

help!

i get this error message when i try to access catalog/account_history_info.php

all other pages are fine, i can place order, read account history, untill i click account history info.

i've been playing on some contribution and i guess i altered the database before i back it up.

what should i do??

 

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

 

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

 

[TEP STOP]

 

please help

 

thanks in advance

[dahui]

help!

i get this error message when i try to access catalog/account_history_info.php

all other pages are fine, i can place order, read account history, untill i click account history info.

i've been playing on some contribution and i guess i altered the database before i back it up.

what should i do??

 

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

 

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

 

[TEP STOP]

 

please help

 

thanks in advance

 

first Idea as ususal to me would be test with a vanilla file and see what happens

 

second ther seems to be something wrong with the query, as it cannot find a the ... as error

but could be as well a corrupted table.

 

so the first thing I would checkis the vanilla file and/or the query in ther confronted to what yr file chows now

 

dahui