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

mogua Total Posts: 2 Joined: 2009-01-09 Ignore user	The sort by price function no longer produces a properly “paged” layout. The official Magento demo store exhibits the same behaviour as can be seen at this link: http://demo.magentocommerce.com/bed-and-bath/living-room?order=price&dir;=asc The sorting itself works but notice how it only says “1 item” on the top left. In my case it no longer pagenates my list of products. How do I fix this? Thanks.
	Posted: January 10 2009 \| top

lemax Total Posts: 314 Joined: 2008-04-03 Nantes, France Ignore user	Seems to be a BUG ! Not yet reported ??? Signature eBusiness Atlantique : Spécialiste en création de sites e-commerce Magento en Loire Atlantique. Ambient Lounge : Fauteuils lounge pour l’intérieur et l’extérieur. Billes de polystyrene.com : Billes de polystyrène pour garnissage de poufs ou fauteuils, isolation, neige artificielle, décors…
	Posted: January 12 2009 \| top \| # 1

mogua Total Posts: 2 Joined: 2009-01-09 Ignore user	Just submitted it after seeing that it’s still not fixed in 1.2.0.2
	Posted: January 12 2009 \| top \| # 2

cathyb Total Posts: 5 Joined: 2008-11-17 Ignore user	I’m seeing this error as well.
	Posted: January 12 2009 \| top \| # 3

Smokersroom Total Posts: 63 Joined: 2007-09-04 Ignore user	Same error here… S. Signature Buy Watches Online Low Energy PCs & Laptops
	Posted: January 17 2009 \| top \| # 4

ben_marks Total Posts: 448 Joined: 2008-10-09 Charleston, SC Ignore user	http://www.magentocommerce.com/bug-tracking/issue?issue=4808 Seems to be fixed, but slated for the 1.2.1 release Signature Ben Marks, MCD+ (@benmarks) • Blue Acorn, a Magento Gold Partner • eCommerce Consulting • New Magento StackExchange site proposal - follow & vote! I do not respond to PMs.
	Posted: January 21 2009 \| top \| # 5

Michael Total Posts: 826 Joined: 2007-08-31 Ignore user	Fixed and released in 1.2.1
	Posted: February 5 2009 \| top \| # 6

charliechen Total Posts: 4 Joined: 2008-08-21 Ignore user	this is still not fixed for 1.2.1 and it seems to be worse. Now i think best value is broken as well not just the price.
	Posted: February 13 2009 \| top \| # 7

UnfinishedWebsite Total Posts: 5 Joined: 2009-02-12 Ignore user	I’m very new to this Magento thing, so take this all with a grain of salt. I quickly ran across this sorting bug. There seems to be a quick fix, although it did require changing the Magento core, so there could be consequences now or with an upgrade. In this class Mage_Catalog_Block_Product_List aka \app\code\core\Mage\Catalog\Block\Product\List.php I’ve changed this: `if ($sortField = $this->getSortBy()) { $sortOrder = 'asc'; if (strtolower($this->getSortOrder()) == 'desc') {` to this: `$toolbar = $this->getToolbarBlock(); if ($sortField = $toolbar->getCurrentOrder()) { $sortOrder = 'asc'; if (strtolower($toolbar->getCurrentDirection()) == 'desc') {` Obviously this solution is not well tested, but it’s worked for me so far…
	Posted: February 13 2009 \| top \| # 8

AngelEyes Total Posts: 74 Joined: 2008-02-25 Ignore user	Any news on this bug, as mentioned it is not fixed in 1.2.1 Thanks, Adam
	Posted: February 13 2009 \| top \| # 9

erwanpia Total Posts: 41 Joined: 2008-02-16 Locronan, Brittany Ignore user	Hi, there is a way to implement the bugfix without compromising future updates : create you own module , example below I now have one question for magento gurus : the subclass below works fine but the add to cart button returned from the product collection is now in english instead of french (default language). Why is this language information lost ? 1. create a new class here, with the new _getProductCollection function app\code\local\PoleOuest\Catalog\Block\Product\List.php class PoleOuest_Catalog_Block_Product_List extends Mage_Catalog_Block_Product_List 2. declare the new class app\code\local\PoleOuest\Catalog\etc\config.xml `<?xml version="1.0"?> <config> <global> <blocks> <catalog> <rewrite> <product_list>PoleOuest_Catalog_Block_Product_List</product_list> </rewrite> </catalog> </blocks> </global> </config>` 3 declare your module in app\etc\modules\PoleOuest_All.xml `<?xml version="1.0"?> <config> <modules> <PoleOuest_Catalog> <active>true</active> <codePool>local</codePool> </PoleOuest_Catalog> </modules> </config>` Signature -------------------------------------------------------- ErwanPia @ POLEOUEST
	Posted: February 19 2009 \| top \| # 10

j2tdesign Total Posts: 208 Joined: 2008-07-17 France Ignore user	Hello everyone, Thanks for your posts. I managed to get everything working, but I am still having trouble with sorting product by price in search mode. Does anyone know how to fix this? I tried everything, but nothing works. Best regards, Jon Signature J2T - Extensions & Magento creation http://www.j2t-design.net (to download new versions of modules and get a professionnal installation) Don’t hesitate to contact us on our contact page.
	Posted: February 25 2009 \| top \| # 11

Paaaaa Total Posts: 49 Joined: 2008-10-30 Ignore user	Update all your cache. This happens when u sort, and after add couple of products, then sort again, and it is “broken”.
	Posted: March 2 2009 \| top \| # 12

Hitch Total Posts: 1 Joined: 2009-02-26 Ignore user	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.
	Posted: March 19 2009 \| top \| # 13

Boaz Total Posts: 5 Joined: 2008-09-17 Ignore user	It may sound strange but while trying to debug this problem over 1.2.0.2 I add call to getSize() to the end of _getProductCollection() function in code\core\Mage\Catalog\Block\Product\List.php and the problem was solved! Just changed in code from `return $this->_productCollection; }` to `$this->_productCollection->getSize(); return $this->_productCollection; }` Good luck.
	Posted: March 22 2009 \| top \| # 14

Calum Brodie Total Posts: 9 Joined: 2008-06-21 Ignore user	I can confirm the above^^^^^^^ Works for me in resolving this bug. Edit - Magento 1.2.0.1
	Posted: March 26 2009 \| top \| # 15

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