Im lost =(

[johnkiax]

Hello all. Like allways, sorry for my bad english.

 

Yesterday i dont know why my site give me the error:

 

1054 - Unknown column 'pa.attribute_sort' in 'order clause'

 

select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from products_attributes pa, products_options_values pov where pa.products_id = '202' and pa.options_id = '2' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '3' order by pa.attribute_sort

 

[TEP STOP]

 

this error are show up of atributes. I cant see the box atributes =( i dont know why and im not an php expert.

 

Thanks in advance

 

=)

[spooks]

Well, this is sql query, so it don't matter how bad your php is.

 

attribute_sort does not exist in the products_attributes table by default, have you added it?

[johnkiax]

Sam: Thanks for your answer.

 

Look, im newbe. How can i do to add this tables ?

 

Thanks and sorry for my bad english =)

[♥FWR Media]

Sam: Thanks for your answer.

 

Look, im newbe. How can i do to add this tables ?

 

Thanks and sorry for my bad english =)

 

No I think you may have misunderstood.

 

Sam was saying that your script is requesting the field attribute_sort

 

and that field does not exist as standard in table products_attributes table.

 

What this probably means is that you have installed a contribution but have not applied the relevant SQL changes.