Magento Column 'position' in order clause is ambiguous

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