I dont know how many people get this error but it took me very long time to resolve this:
The one who know the answer will say its a task of 5 mins but who dont know it will be very very difficult to get rid of this problem, the only thing that you need to do is go to this page
magentoroot/app/code/core/Mage/Catalogue/Model/Layer.php
Search for "function getFilterableAttributes()"
comment the following code
"->setOrder('position', 'ASC') "
your problem is solved
The one who know the answer will say its a task of 5 mins but who dont know it will be very very difficult to get rid of this problem, the only thing that you need to do is go to this page
magentoroot/app/code/core/Mage/Catalogue/Model/Layer.php
Search for "function getFilterableAttributes()"
comment the following code
"->setOrder('position', 'ASC') "
your problem is solved
