In-Portal Issue Tracker - In-Portal CMS
Viewing Issue Advanced Details
ID: Category: Type: Reproducibility: Date Submitted: Last Update:
1045 [In-Portal CMS] Admin Interfaces bug report always 2011-04-26 20:17 2012-07-25 05:33
Reporter: phil Platform:  
Assigned To: alex OS:  
Priority: normal OS Version:  
Status: closed Product Version: 5.1.2  
Product Build: Resolution: fixed  
 
ETA: none Fixed in Version: 5.2.0-B1  
Reference: https://groups.google.com/d/topic/in-portal-bugs/s65ZuACDBYY/discussion
Change Log Message: Fixed sorting by ID in form submissions grid
Estimate Points: 1
Summary: 0001045: Sorting by ID is broken in Form Submissions grid
Description: In admin, when you click on ID column to sort forms submitted by ID, it'll will try to sort by a non-existing FormFieldId column in FormsSubmissions table, and at this point grid display is broken with only 1 empty line as result.
Steps To Reproduce:
Additional Information: Plan:

1. fix column name in corresponding unit config.
2. create SQL in install/upgrades.sql, that will delete broken sorting records in PersistentSessionData table (where that wrong field is listed for corresponding unit config prefix)
------
0.5 h
Relationships
Attached Files: patch formsubs_sorting_broken_1045.patch (1,816) 2011-09-30 07:45
http://tracker.in-portal.org/file_download.php?file_id=1170&type=bug
patch formsubs_sorting_broken_1045.2.patch (1,974) 2011-10-04 09:36
http://tracker.in-portal.org/file_download.php?file_id=1204&type=bug
Issue History
Date Modified Username Field Change
2012-07-25 05:33 alex Note Added: 0005103
2012-07-25 05:33 alex Status resolved => closed
2011-10-22 05:31 alex Estimate Points => 1
2011-10-05 07:36 alex Changeset attached 5.2.x r14636
2011-10-05 07:36 alex Note Added: 0004017
2011-10-05 07:36 alex Status reviewed and tested => resolved
2011-10-05 07:36 alex Fixed in Version => 5.2.0-B1
2011-10-05 07:36 alex Resolution open => fixed
2011-10-05 07:36 alex Assigned To !COMMUNITY => alex
2011-10-05 07:36 alex Assigned To alex => !COMMUNITY
2011-10-05 07:36 alex Status needs testing => reviewed and tested
2011-10-04 09:37 erik Note Added: 0004003
2011-10-04 09:37 erik Assigned To erik => alex
2011-10-04 09:37 erik Status needs work => needs testing
2011-10-04 09:36 erik File Added: formsubs_sorting_broken_1045.2.patch
2011-10-04 09:36 erik File Deleted: save_config_message_1118.2.patch
2011-10-04 09:35 erik File Added: save_config_message_1118.2.patch
2011-10-03 12:19 alex Note Added: 0003980
2011-10-03 12:19 alex Assigned To alex => erik
2011-10-03 12:19 alex Status needs testing => needs work
2011-09-30 07:45 erik Time Estimate Removed 1 =>
2011-09-30 07:45 erik Note Added: 0003943
2011-09-30 07:45 erik Assigned To erik => alex
2011-09-30 07:45 erik Developer => erik
2011-09-30 07:45 erik Status needs work => needs testing
2011-09-30 07:45 erik File Added: formsubs_sorting_broken_1045.patch
2011-09-26 04:19 alex Time Estimate Added 1
2011-09-26 04:19 alex Additional Information Updated bug_revision_view_page.php?rev_id=837#r837
2011-09-24 22:28 Dmitry Note Added: 0003904
2011-09-24 22:28 Dmitry Assigned To => erik
2011-09-24 22:28 Dmitry Status active => needs work
2011-09-24 22:28 Dmitry Target Version Icebox => 5.2.0
2011-04-26 20:17 Dmitry Reporter Dmitry => phil
2011-04-26 20:17 Dmitry New Issue
2011-04-26 20:17 Dmitry Reference => https://groups.google.com/d/topic/in-portal-bugs/s65ZuACDBYY/discussion
2011-04-26 20:17 Dmitry Change Log Message => Fixed sorting by ID in form submissions grid

Notes
(0003904)
Dmitry   
2011-09-24 22:28   
Problem is confirmed in 5.1.3
(0003943)
erik   
2011-09-30 07:45   
Patch uploaded - needs testing
(0003980)
alex   
2011-10-03 12:19   
1. When duplicate sorting config setting is enabled, then wrong sorting field could be also stored under "...Sort2" name in PersistentSessionData table. Please check that case and adjust upgrades.sql script accordingly.
(0004003)
erik   
2011-10-04 09:37   
formsubs_sorting_broken_1045.2.patch attached - needs testing
(0004017)
alex   
2011-10-05 07:36   
Fix committed to 5.2.x branch. Commit Message:

Fixes 0001045: Sorting by ID is broken in Form Submissions grid
Commit on behalf of Erik
(0005103)
alex   
2012-07-25 05:33   
Since 5.2.0 version was released.