Sort by position does not work

[sreichel]

Preconditions (*)

1. 1.9.4.x-dev
2. flat product tables enabed

Steps to reproduce (*)

        $collection = Mage::getResourceModel('catalog/product_collection')
            ->addCategoryFilter(Mage::getModel('catalog/category')->load(3))
            ->addAttributeToSort('position')
            ->load();
        var_dump($collection->getFirstItem()->getData());

Column not found: 1054 Unknown column 'cat_index.position' in 'order clause' ...

This works only for flat tables turned off.

There is a PR that fix this, but it does not work for me. See #1815

[elidrissidev]

From my testing, this error happens only when flat tables are ON and category filter is either not applied or category not found. Can you try commenting out the 3 lines below and see if your issue is resolved? Then I can create a PR.

magento-lts/app/code/core/Mage/Catalog/Model/Resource/Product/Collection.php

Lines 1535 to 1537 in 32d1591

	if ($this->isEnabledFlat()) {
	$this->getSelect()->order("cat_index_position {$dir}");
	}

[sreichel]

When i comment these line the error disappears ... not tested anything more.

[elidrissidev]

Why do you close this? The fix is not merged yet

[addison74]

It is most likely the way in which Sven expresses his dissatisfaction with how this project is managed. Unfortunately, I cannot hide the fact that such actions which are repeated periodically affect me emotionally, especially since I still believe in OpenMage. I think that others are in the same situation.

[sreichel]

@elidrissidev i closed it b/c i dont we to see it anymore when viewing https://github.com/issues. Sorry.