In-Portal Issue Tracker - In-Portal CMS
Viewing Issue Advanced Details
1247 [In-Portal CMS] Database bug report always 2012-04-03 06:09 2012-07-25 05:31
alex  
alex  
normal  
closed 5.2.0-B2  
fixed  
 
none 5.2.0-B3  
https://groups.google.com/d/topic/in-portal-bugs/l2YvgxSZTK0/discussion
Fixes sql error on priority recalculation
1
0001247: Sql error on priorities recalculation for list without parent constrain
In 5.2.0-B2 version we've introduced PriortyEventHandler class, that allows to sort items in list like it's done for categories.

Key differences from what previous implementations:

* buttons MoveUp/MoveDown in toolbar really move selected list items one position up and down and not just change Priority column value to +1 or -1 resulting items with duplicate priorities
* no need to guess what priority to set, since now it's a dropdown from all available priorities and you can easily select that a specific item must at Nth position in list
* easy to use dropdown filter in list (instead of just a textbox)

In default installation there is no place, where this is implemented except for Categories and Promo Blocks. However there is not "Recalculate Priorities" toolbar button in promo blocks. If there was a such button, then clicking on it would produce an SQL error.
child of 0000856closed  (5.2.0)alex Add PriorityEventHandler to Core 
patch priority_eh_without_constrain_fix.patch (1,359) 2012-04-03 06:09
http://tracker.in-portal.org/file_download.php?file_id=1594&type=bug
Issue History
2012-07-25 05:31 alex Note Added: 0004935
2012-07-25 05:31 alex Status resolved => closed
2012-04-03 06:12 alex Note Added: 0004558
2012-04-03 06:12 alex Status reviewed and tested => resolved
2012-04-03 06:12 alex Fixed in Version => 5.2.0-B3
2012-04-03 06:12 alex Resolution open => fixed
2012-04-03 06:12 alex Assigned To !COMMUNITY => alex
2012-04-03 06:12 alex Changeset attached 5.2.x r15262
2012-04-03 06:12 alex Note Added: 0004557
2012-04-03 06:12 alex Status needs testing => reviewed and tested
2012-04-03 06:12 alex Reference => https://groups.google.com/d/topic/in-portal-bugs/l2YvgxSZTK0/discussion
2012-04-03 06:10 alex Assigned To => !COMMUNITY
2012-04-03 06:10 alex Developer => alex
2012-04-03 06:10 alex Status active => needs testing
2012-04-03 06:10 alex Relationship added child of 0000856
2012-04-03 06:09 alex New Issue
2012-04-03 06:09 alex File Added: priority_eh_without_constrain_fix.patch
2012-04-03 06:09 alex Change Log Message => Fixes sql error on priority recalculation
2012-04-03 06:09 alex Estimate Points => 1

Notes
(0004557)
alex   
2012-04-03 06:12   
Will test all together later.
(0004558)
alex   
2012-04-03 06:12   
Fix committed to 5.2.x branch. Commit Message:

Fixes 0001247: Sql error on priorities recalculation for list without parent constrain
(0004935)
alex   
2012-07-25 05:31   
Since 5.2.0 version was released.