In-Portal Issue Tracker

Welcome to the In-Portal Open Source CMS Issue Tracker! This is a central management / tracking tool for all types of tasks / issues / bugs for the In-Portal Project. Before reporting any issues, please make sure to read the Guide into Issue Tracker and How to Properly Test and Report Bugs!

Viewing Issue Simple Details Jump to Notes ] Wiki ]  Related Changesets ] View Advanced ] Issue History ] Print ]
ID Category Type Reproducibility Date Submitted Last Update
0000314 [In-Portal CMS] Admin Interfaces bug report always 2009-09-22 12:02 2009-10-03 07:56
Reporter Dmitry View Status public Project Name In-Portal CMS
Assigned To alex Developer
Priority normal Resolution fixed Fixed in Version 5.0.1
Status closed Product Version 5.0.1 Target Version 5.0.1
Time EstimateNo estimate
Summary 0000314: Add Case-Insensitive Field to Phrases table for storing Labels
Description 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.
Additional Information
Tags No tags attached.
Reference
Change Log Message
Estimate Points 0
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
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 

-  Notes
User avatar (0000512)
alex (manager)
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
User avatar (0000558)
Dmitry (manager)
2009-09-26 23:22

All NEWly added phrases don't have "PhraseKey" field populated and not replaced with language values.
User avatar (0000559)
Dmitry (manager)
2009-09-26 23:22

Reminder sent to: alex

Please look into this - important
User avatar (0000566)
alex (manager)
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
User avatar (0000722)
administrator (administrator)
2009-10-03 07:56

Closing issues from 5.0.1 version, because version was already released.

- Related Changesets
In-Portal CMS: 5.0.x r12614
Timestamp: 2009-09-27 05:57:42
Author: alex
Details ] Diff ]
Fixes 0000314: Add Case-Insensitive Field to Phrases table for storing Labels
mod - /in-portal/branches/5.0.x/core/units/phrases/phrases_config.php Diff ] File ]
mod - /in-portal/branches/5.0.x/core/units/phrases/phrases_event_handler.php Diff ] File ]
In-Portal CMS: 5.0.x r12591
Timestamp: 2009-09-22 15:58:35
Author: alex
Details ] Diff ]
Fixes 0000314: Add Case-Insensitive Field to Phrases table for storing Labels
mod - /in-portal/branches/5.0.x/core/install/install_schema.sql Diff ] File ]
mod - /in-portal/branches/5.0.x/core/install/upgrades.sql Diff ] File ]
mod - /in-portal/branches/5.0.x/core/kernel/languages/phrases_cache.php Diff ] File ]
mod - /in-portal/branches/5.0.x/core/units/helpers/language_import_helper.php Diff ] File ]

- Issue History
Date Modified Username Field Change
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 View Revisions
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



Web Development by Intechnic
In-Portal Open Source CMS
In-Portal Open Source CMS
Copyright © 2000 - 2009 MantisBT Group

Powered by Mantis Bugtracker