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
0001270 [In-Portal CMS] Localization bug report always 2012-05-05 10:02 2012-07-25 05:30
Reporter alex View Status public Project Name In-Portal CMS
Assigned To alex Developer
Priority normal Resolution fixed Fixed in Version 5.2.0-RC1
Status closed Product Version 5.1.3 Target Version 5.2.0
Time EstimateNo estimate
Summary 0001270: Multiple language import fails
Description Problem #1:

If you have 1 language and you import language pack, that has 5 new languages, then it will fail with SQL error, that no l6_Translation column exists.

This happens, because there are only columns for first 5 languages after clean In-Portal installation.

I think, that after new record is created in Languages database table we should also create corresponding new columns in all database tables, that have translatable fields in them. Not sure if this happens already (maybe after language import was finished) or after each new language is created (as I would like it to work).


It seems, that problem was there right after we changed how phrases/e-mail events are stored in 5.1.0.


Problem #2:
If you have language pack that has 1 language with not translated phrase and 2 languages where this phrase is translated then you'll get "Column count doesn't match value count" sql error during import.

Problem #3:
<?xml version="1.0" encoding="utf-8"?> is not being added to language pack.
Additional Information
Tags No tags attached.
Reference https://groups.google.com/d/topic/in-portal-bugs/CrJMZCnQ6Go/discussion
Change Log Message Fixes inability to import multiple languages from 1 language pack
Estimate Points 1
Attached Files ? file icon language_pack_import_breaker.lang [^] (2,705 bytes) 2012-05-05 10:02
patch file icon missing_phrase_breaks_multiple_language_import_513.patch [^] (8,136 bytes) 2012-05-05 10:03 [Show Content]
patch file icon missing_phrase_breaks_multiple_language_import_520.patch [^] (10,950 bytes) 2012-05-05 10:04 [Show Content]
patch file icon language_data_not_imported_520.patch [^] (1,186 bytes) 2012-05-16 09:34 [Show Content]
patch file icon htmlspecialchars_breaks_down_language_pack.patch [^] (1,082 bytes) 2012-05-27 14:59 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
User avatar (0004614)
alex (manager)
2012-05-05 10:04

Patch "missing_phrase_breaks_multiple_language_import_513.patch" fixes only problem #1.

Patch "missing_phrase_breaks_multiple_language_import_520.patch" fixes all described problems.
User avatar (0004615)
alex (manager)
2012-05-05 10:06

Will test all together later.
User avatar (0004616)
alex (manager)
2012-05-05 10:07

Fix committed to 5.2.x branch. Commit Message:

Fixes 0001270: Multiple language import fails
User avatar (0004632)
alex (manager)
2012-05-16 09:36

Patch "missing_phrase_breaks_multiple_language_import_520.patch" had a bug in it and because of it language data (phrases, e-mail events, countries) were not imported at all.

Patch "language_data_not_imported_520.patch" fixes it.
User avatar (0004663)
alex (manager)
2012-05-27 15:01

Patch "htmlspecialchars_breaks_down_language_pack.patch" fixes problem, that "htmlspecialchars" function (prior to PHP 5.4) by default encoded it's output to "ISO-8859-1" encoding instead of "UTF-8". This resulted in broken XML during language pack import in plain encoding.
User avatar (0004891)
alex (manager)
2012-07-25 05:30

Since 5.2.0/1.2.0 versions was released.

- Related Changesets
In-Portal CMS: 5.2.x r15359
Timestamp: 2012-05-27 15:04:02
Author: alex
Details ] Diff ]
Bug 0001270: Multiple language import fails
1. Fixes problem, that "htmlspecialchars" function (prior to PHP 5.4) by default encoded it's output to "ISO-8859-1" encoding instead of "UTF-8". This resulted in broken XML during language pack import in plain encoding.
mod - /in-portal/branches/5.2.x/core/units/helpers/language_import_helper.php Diff ] File ]
In-Portal CMS: 5.2.x r15334
Timestamp: 2012-05-16 09:37:11
Author: alex
Details ] Diff ]
Bug 0001270: Multiple language import fails
1. language data wasn't imported
mod - /in-portal/branches/5.2.x/core/units/helpers/language_import_helper.php Diff ] File ]
In-Portal CMS: 5.2.x r15327
Timestamp: 2012-05-05 10:07:19
Author: alex
Details ] Diff ]
Fixes 0001270: Multiple language import fails
mod - /in-portal/branches/5.2.x/core/units/helpers/language_import_helper.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/helpers/multilanguage_helper.php Diff ] File ]

- Issue History
Date Modified Username Field Change
2012-07-25 05:30 alex Note Added: 0004891
2012-07-25 05:30 alex Status resolved => closed
2012-05-27 15:04 alex Changeset attached 5.2.x r15359
2012-05-27 15:01 alex Note Added: 0004663
2012-05-27 14:59 alex File Added: htmlspecialchars_breaks_down_language_pack.patch
2012-05-16 09:37 alex Changeset attached 5.2.x r15334
2012-05-16 09:36 alex Note Added: 0004632
2012-05-16 09:34 alex File Added: language_data_not_imported_520.patch
2012-05-05 10:07 alex Changeset attached 5.2.x r15327
2012-05-05 10:07 alex Note Added: 0004616
2012-05-05 10:07 alex Status reviewed and tested => resolved
2012-05-05 10:07 alex Fixed in Version => 5.2.0-RC1
2012-05-05 10:07 alex Resolution open => fixed
2012-05-05 10:07 alex Assigned To !COMMUNITY => alex
2012-05-05 10:06 alex Note Added: 0004615
2012-05-05 10:06 alex Status needs testing => reviewed and tested
2012-05-05 10:04 alex Assigned To => !COMMUNITY
2012-05-05 10:04 alex Developer => alex
2012-05-05 10:04 alex Status active => needs testing
2012-05-05 10:04 alex File Added: missing_phrase_breaks_multiple_language_import_520.patch
2012-05-05 10:04 alex Note Added: 0004614
2012-05-05 10:03 alex File Added: missing_phrase_breaks_multiple_language_import_513.patch
2012-05-05 10:02 alex New Issue
2012-05-05 10:02 alex File Added: language_pack_import_breaker.lang
2012-05-05 10:02 alex Reference => https://groups.google.com/d/topic/in-portal-bugs/CrJMZCnQ6Go/discussion
2012-05-05 10:02 alex Change Log Message => Fixes inability to import multiple languages from 1 language pack
2012-05-05 10:02 alex Estimate Points => 1



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

Powered by Mantis Bugtracker