Multiple language import fails in 5.2.0

Skip to first unread message

Alexander Obuhovich

May 3, 2012, 7:04:24 AM5/3/12
to In-Portal Bugs
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 tnraslatable 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.


May 3, 2012, 8:44:16 AM5/3/12
as an heavy language tools user, I'd like to say "nice catch" :)

Envoyé avec Sparrow

You received this message because you are subscribed to the Google Groups "In-Portal Bugs Team" group.
To post to this group, send email to
To unsubscribe from this group, send email to
For more options, visit this group at

Alexander Obuhovich

May 5, 2012, 3:55:01 AM5/5/12
Both "Pack Name" and "Local Name" fields of language record are written into language pack during export. But most likely "Local Name" field would contain some non-latin symbols, like "Русский" for language, which "Pack Name" is "Russian".

This is not a problem for In-Portal, but if you will edit that language pack in external XML editor, then you'll get into situation, when these non-latin symbols get corrupted because we're missing XML header on top of a file:

<?xml version="1.0" encoding="utf-8"?>

I'm also attaching language pack, that would demonstrate several problems:
  1. one, discovered in my previous post: translatable columns are not created when new language is imported and it would became 6+ language
  2. new one: having language with not translated phrase and 2 languages where this phrase is translated imported from same language pack file

Alexander Obuhovich

May 5, 2012, 11:05:39 AM5/5/12

Ready for testing.
Reply all
Reply to author
0 new messages