
This is just reminder for me which SQL queries execute on eZ Publish database when switching for example from eng-GB to nor-NO language.
// Check language ID in ezcontent_language table // eng-GB -> 2 // eng-GB -> 3 - always available 2+1 // nor-NO -> 256 // nor-NO -> 257 - always available 256+1 // ezcontentobject realted UPDATE ezcontentobject SET initial_language_id = '256' WHERE initial_language_id = '2'; UPDATE ezcontentobject SET language_mask = '256' WHERE language_mask = '2'; UPDATE ezcontentobject SET language_mask = '257' WHERE language_mask = '3'; UPDATE ezcontentobject_attribute SET language_code='nor-NO' WHERE language_code='eng-GB'; UPDATE ezcontentobject_attribute SET language_id = '256' WHERE language_id = '2'; UPDATE ezcontentobject_attribute SET language_id = '257' WHERE language_id = '3'; UPDATE ezcontentobject_version SET initial_language_id = '256' WHERE initial_language_id = '2'; UPDATE ezcontentobject _version SET language_mask = '256' WHERE language_mask = '2'; UPDATE ezcontentobject_version SET language_mask = '257' WHERE language_mask = '3'; UPDATE ezcontentobject_name SET content_translation='nor-NO' WHERE content_translation='eng-GB'; UPDATE ezcontentobject_name SET real_translation='nor-NO' WHERE real_translation='eng-GB'; UPDATE ezcontentobject_name SET language_id = '256' WHERE language_id = '2'; UPDATE ezcontentobject_name SET language_id = '257' WHERE language_id = '3'; // ezurlalias_ml realted UPDATE ezurlalias_ml SET lang_mask = '256' WHERE lang_mask = '2'; UPDATE ezurlalias_ml SET lang_mask = '257' WHERE lang_mask = '3'; // ezcontentclass realted UPDATE ezcontentclass SET language_mask = '257' WHERE language_mask = '3';"; UPDATE ezcontentclass_name SET language_locale = 'nor-NO' WHERE language_locale = 'eng-GB';"; UPDATE ezcontentclass_name SET language_id = '257' WHERE language_id = '3';"; UPDATE ezcontentclass SET initial_language_id = '256' WHERE initial_language_id = '2'; UPDATE ezcontentclass SET serialized_name_list = REPLACE( serialized_name_list, 'eng-GB', 'nor-NO' ); UPDATE ezcontentclass_attribute SET serialized_name_list = REPLACE( serialized_name_list, 'eng-GB', 'nor-NO' );

Didn't work on 4.1
Tuesday 21 April 2009 4:43:16 pm
Ly
FYI, I too had to change the default language. I ran your command lines and it messed up my objects. I couldn't find them on the admin site anymore. Maybe there's other tables to modify...