In-Portal Issue Tracker - In-Portal CMS
Viewing Issue Advanced Details
314 [In-Portal CMS] Admin Interfaces bug report always 2009-09-22 12:02 2009-10-03 07:56
Dmitry  
alex  
normal  
closed 5.0.1  
fixed  
 
none 5.0.1  
0
0000314: Add Case-Insensitive Field to Phrases table for storing Labels
Need to add new Case insensitive column to Phrases table for 2 cases:

1. Language Pack Upgrade fails since we can't properly compare all NEW phrases when Label cases doesn't match.

2. MySQL INDEX is not working when any operation as done with the Field in WHERE clause. By adding a separate field we guarantee that Field will be selected using INDEX and will improve loading time.
parent of 0000246closed  (5.0.2)alex Database index not used, when quering phrases by name 
parent of 0000324closed  (5.0.1)alex Language synchronizer gives fatal error 
Issue History
2009-10-03 07:56 administrator Note Added: 0000722
2009-10-03 07:56 administrator Status resolved => closed
2009-09-27 05:57 alex Fixed in Version => 5.0.1
2009-09-27 05:57 alex Note Added: 0000566
2009-09-27 05:57 alex Status needs feedback => resolved
2009-09-27 05:57 alex Fixed in Version 5.0.1 =>
2009-09-27 05:57 alex Resolution reopened => fixed
2009-09-27 05:57 alex Changeset attached 5.0.x r12614
2009-09-26 23:22 Dmitry Note Added: 0000559
2009-09-26 23:22 Dmitry Note Added: 0000558
2009-09-26 23:22 Dmitry Status resolved => needs feedback
2009-09-26 23:22 Dmitry Resolution fixed => reopened
2009-09-25 08:00 alex Relationship added parent of 0000324
2009-09-23 12:25 alex Relationship added parent of 0000246
2009-09-22 15:58 alex Fixed in Version => 5.0.1
2009-09-22 15:58 alex Note Added: 0000512
2009-09-22 15:58 alex Status reviewed and tested => resolved
2009-09-22 15:58 alex Resolution open => fixed
2009-09-22 15:58 alex Changeset attached 5.0.x r12591
2009-09-22 15:57 alex Summary Add Case-Sensitive Field to Phrases table for storing Labels => Add Case-Insensitive Field to Phrases table for storing Labels
2009-09-22 15:57 alex Description Updated bug_revision_view_page.php?rev_id=241#r241
2009-09-22 15:52 alex Summary Add Case-Sencetive Field to Phrases table for storing Labels => Add Case-Sensitive Field to Phrases table for storing Labels
2009-09-22 12:02 Dmitry New Issue
2009-09-22 12:02 Dmitry Status active => reviewed and tested
2009-09-22 12:02 Dmitry Assigned To => alex

Notes
(0000512)
alex   
2009-09-22 15:58   
Fix committed to 5.0.x branch. Commit Message:

Fixes 0000314: Add Case-Insensitive Field to Phrases table for storing Labels
(0000558)
Dmitry   
2009-09-26 23:22   
All NEWly added phrases don't have "PhraseKey" field populated and not replaced with language values.
(0000559)
Dmitry   
2009-09-26 23:22   
Reminder sent to: alex

Please look into this - important
(0000566)
alex   
2009-09-27 05:57   
Fix committed to 5.0.x branch. Commit Message:

Fixes 0000314: Add Case-Insensitive Field to Phrases table for storing Labels
(0000722)
administrator   
2009-10-03 07:56   
Closing issues from 5.0.1 version, because version was already released.