Magento - Sort by price broken after Magento Connect upgrade to 1.2.0.1 - Magento 1.2.0 Upgrade Issues - eCommerce Software for Growth

Log In

Username or Email

Password:

Forgot Password

or
Register

Skip to site navigation »
Skip to main content »
Skip to footer content »

Magento Forum

Sort by price broken after Magento Connect upgrade to 1.2.0.1

ServWise Total Posts: 17 Joined: 2008-12-10 Ignore user	I can confirm this is a bug also in 1.2.1.2, after adding products the sort by function will be wrong again. you have to go into the cache management and refresh the “Layered Navigation Indices” for the sorting to be corrected. Signature Sam ServWise Advanced hosting - Better, Smarter, Faster Windows Hosting, Linux Hosting, Magento Hosting, Domain Name and SSL certificates
	Posted: April 1 2009 \| top \| # 16

mudpie Total Posts: 6 Joined: 2009-03-07 Ignore user	I’m using 1.3.0. Refreshed ‘Layered Navigation Indices’ under Cache management and sort by price works. Thank you!
	Posted: April 6 2009 \| top \| # 17

kaamiljj Total Posts: 125 Joined: 2009-03-15 Kapaa Ignore user	Refreshing / deleting all cache didn’t help me fix it. Any other ideas? 1.3.0 Signature http://www.jewelofthelotus.com - Exotic pearls, antique jewelry, antiques, artifacts, Buddha statues, Thangka paintings, crystal art and oriental carpets.
	Posted: April 10 2009 \| top \| # 18

DavorNo Total Posts: 21 Joined: 2008-07-26 Ignore user	Hitch - 19 March 2009 09:02 AM We have an issue on a site, the product list shows all the products but reports only one item in the count and so the paging (Page count) does not show. You can see on this page which has 16 products, shows 9 but the count only says 1 and no paging in the bar/ http://www.williamcurley.co.uk/shopping/chocolate-bars-william-curley?mode=grid&limit;=9 Running Magento V1.2.0.1 Can anyone advise a fix? I would rather not have to upgrade as the rest of the site is working as expected and an upgrade is sure to break something else. I have the same problem. I try to edit List.php, but there is no solution. How to fix this? Refreshing the cache not solving the problem, and this problem show up when I refresh “Layered Navigation Indices”.
	Posted: July 6 2009 \| top \| # 19

Mage Guru Total Posts: 79 Joined: 2009-07-07 Ignore user	My sort by position isnt working in version 1.3.2.1. Can anyone advise a fix. Thank you
	Posted: September 3 2009 \| top \| # 20

Track 23 Total Posts: 50 Joined: 2008-03-19 Ignore user	mudpie - 06 April 2009 09:41 AM I’m using 1.3.0. Refreshed ‘Layered Navigation Indices’ under Cache management and sort by price works. Thank you! That worked for me in 1.3.0. Thanks!
	Posted: September 30 2009 \| top \| # 21

kuikui Total Posts: 4 Joined: 2009-12-02 Ignore user	my Magento ver. 1.3.2.3 but the price sorting is not work :( I have checked the system I use different template not work I change the price attribute setting not work I add new products in new category not work..... no idea why :( who can give me advice ?
	Posted: December 5 2009 \| top \| # 22

blitux Total Posts: 8 Joined: 2009-12-15 Ignore user	I’ve noticed that sorting by price works when any user is logged in, and it’s not working when you’re viewing the store as an anonymous user. Is there a way to set permissions, like “anonymous users can sort by price” or something like that? Using Magento v1.3.2.3
	Posted: December 16 2009 \| top \| # 23

Yannis Baritakis Total Posts: 2 Joined: 2009-02-01 Ignore user	Same with me! It works only if a user is loged in! Any help? I run 1.3.2.4
	Posted: December 23 2009 \| top \| # 24

jandyguan Total Posts: 3 Joined: 2009-07-31 Ignore user	The same problem Any updates? Thanks.
	Posted: December 24 2009 \| top \| # 25

giggler Total Posts: 70 Joined: 2009-05-02 Ignore user	using 1.3.2.4 Been trying to get the sort by price to work and you’re right..if you’re logged in it works but not for anonymous users!! Anyone know of a fix?
	Posted: December 29 2009 \| top \| # 26

kuikui Total Posts: 4 Joined: 2009-12-02 Ignore user	First I try to upgrade from 1.3.2.3 to 1.3.2.4 is not work under not login second: I try to install 1.3.2.4 and copy all setting, my custom module, category, skin from 1.3.2.3 and import all products using CSV it fixed.... but used me a whole days to do it ="=
	Posted: December 30 2009 \| top \| # 27

blap Total Posts: 14 Joined: 2008-09-28 Ignore user	Refreshing ‘Layered Navigation Indices’ under Cache management on v 1.3.2.2 worked for me, this takes some time to complete…
	Posted: January 7 2010 \| top \| # 28

shmk Total Posts: 292 Joined: 2009-10-28 Ignore user	I’ve cleared the cache and re-edited my products, but the sort by price still broken. I’ve also noticed that the price is no more displayed in the navigation search box (the “range price” box is missing), while the “special price” is available. Anyone has any tips?
	Posted: January 20 2010 \| top \| # 29

miromedia Total Posts: 8 Joined: 2009-04-08 Kenilworth UK Ignore user	Hi Guys, If Layered Navigation Indices rebuilding doesn’t work then why not try the following: `App\code\core\mage\catalog\model\resource\eav\mysql4\product\collection.php line:1155` change this: `$this->getSelect()->joinLeft( array('_price_order_table'=>$this->getTable('catalogindex/price')), "{$entityCondition} AND {$storeCondition} AND {$groupCondition} AND {$attributeCondition}", array() );` to: `$this->getSelect()->joinLeft( array('_price_order_table'=>$this->getTable('catalogindex/price')), "{$entityCondition} AND {$storeCondition} AND {$attributeCondition}", array() );` This resolved all the problems with the price sorting for me. Regards, Roland Signature web developer Miromedia Ltd. http://www.miromedia.co.uk
	Posted: January 22 2010 \| top \| # 30

Magento Community

Magento Community

Back to top

Best Value (position) searches stopped working after upgrade to 1.2.0.1 from 1.1.8

SQLSTATE[42S22]: Column not found: 1054 Unknown column ’cat_index.visibility’ in ’where clause’ after upgrade to 1.2.0.1