In-Portal Issue Tracker - In-Portal CMS
Viewing Issue Advanced Details
503 [In-Portal CMS] Data Management bug report always 2009-12-25 05:37 2010-05-11 03:00
alex  
Dmitry  
normal  
closed 5.0.2-B2  
fixed  
 
none 5.0.3-B1  
http://groups.google.com/group/in-portal-bugs/browse_thread/thread/c20bd212ba574a78#
0
0000503: Unable to create new language as copy of other language
I'm unable to create new language as copy of other language using "Copy Labels from this Language" option. Always getting this SQL fatal error:

Fatal Error: Column count doesn't match value count at row 1 (1136)
SQL:
    INSERT INTO bf_ses_890716989_6_edit_bf_Phrase
    SELECT Phrase, Translation, PhraseType, 0-PhraseId, 3, 1261740647, "", Module
    FROM bf_Phrase
    WHERE LanguageId=1
patch 503-Unable_ to_create_new_language_as_copy_of_other_language-Dmitry-20100129-v1.patch (964) 2010-01-29 17:23
http://tracker.in-portal.org/file_download.php?file_id=256&type=bug
Issue History
2010-05-11 03:00 alex Note Added: 0002150
2010-05-11 03:00 alex Status resolved => closed
2010-03-15 16:29 Dmitry Note Added: 0001615
2010-03-15 16:29 Dmitry Status reviewed and tested => resolved
2010-03-15 16:29 Dmitry Fixed in Version => 5.0.3-B1
2010-03-15 16:29 Dmitry Resolution open => fixed
2010-03-15 16:29 Dmitry Changeset attached 5.0.x r13224
2010-02-26 17:00 Dmitry Assigned To !COMMUNITY => Dmitry
2010-02-26 17:00 Dmitry Developer => Dmitry
2010-02-03 14:27 alex Note Added: 0001457
2010-02-03 14:27 alex Status needs testing => reviewed and tested
2010-02-03 14:23 alex Note Added: 0001456
2010-01-29 17:25 Dmitry Note Added: 0001443
2010-01-29 17:25 Dmitry Assigned To => !COMMUNITY
2010-01-29 17:25 Dmitry Status active => needs testing
2010-01-29 17:23 Dmitry File Added: 503-Unable_ to_create_new_language_as_copy_of_other_language-Dmitry-20100129-v1.patch
2010-01-06 06:18 alex Target Version Icebox => 5.0.3
2009-12-25 05:53 alex version 5.0.2-B1 => 5.0.2-B2
2009-12-25 05:53 alex Target Version => Icebox
2009-12-25 05:39 alex Reference => http://groups.google.com/group/in-portal-bugs/browse_thread/thread/c20bd212ba574a78#
2009-12-25 05:37 alex New Issue

Notes
(0001443)
Dmitry   
2010-01-29 17:25   
Patch attached - please test and review.

Issue was related to recently added PhraseKey field.

NOTE: Copy operation took about 50sec. which means it's close to timeout, but in 5.1.0 we'll have this changed so there 1 record for all translations.
(0001456)
alex   
2010-02-03 14:23   
50 seconds is not coping alone. Most of it is total database scan for need to create new columns associated with this language.
(0001457)
alex   
2010-02-03 14:27   
ok
(0001615)
Dmitry   
2010-03-15 16:29   
Fix committed to 5.0.x branch. Commit Message:

Fixes 0000503: Unable to create new language as copy of other language
(0002150)
alex   
2010-05-11 03:00   
Closing all tasks from released versions.