Guest Posted May 5, 2008 Share Posted May 5, 2008 I have other problem, and i need help me. 1052 - Column 'attributte_sort' in order clause is ambiguous select * from products_attributes as pa INNER JOIN products_options po ON pa.options_id=po.products_options_id where products_id = '39' AND language_id=3 order by attributte_sort [TEP STOP] Simply rename the column - attribute_sort - in the products_options table to options_sort_order as it probably isnt used much in your admin. Check for new errors and solve them by changing the appropriate module to match the above change. There are dozens of parts of the live website that use the products_attributes attribute_sort column - so dont do a global find and replace! However, there are probably only one or two places, and only in the admin, that use the options_sort one so it is easier to fix. Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.