eZ Publish Developer/Specialist / Blog / eZ Publish: switching from primary language to another.

blog

A blog about developing websites with the eZ Publish Content Management System. It contains material such as news, how-to articles, tutorials, template and PHP code, and specific solutions.

Stay up-to-date and subscribe to the blog's RSS feed.

maingfx

eZ Publish: switching from primary language to another.

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' );

Comments