How to change language of mis-configured 3.8 site?

Author Message

Matthew Carroll

Sunday 18 June 2006 2:48:09 pm

Hi, I'm in the process of converting all the ezpublish sites on our server to 3.8. One of the sites was misconfigured when it was set up, and the language code of all the content is eng-GB even though the site is really in German. I only realised because when I migrated to 3.8 and added the new language settings:

SiteLanguageList[]=ger-DE
ShowUntranslatedObjects=disabled

...most of the content dissapeared. Changing the setting to ShowUntranslatedObjects=enabled has provided a 'fix', but the underlying issue is still there.

I did some searching in the database and found 'eng-GB' in the following locations:

ezcontent_language (1)
ezcontentobject_attribute.language_code (1730)
ezcontentobject_name.content_translation / .real_translation (368)
ezimagefile.filepath (317)
ezsession(30)

I also found some info on changing the database before installation here:

http://ez.no/doc/ez_publish/technical_manual/3_7/installation/manual_installation/manual_configuration_of_ez_publish

...but that is specific to 3.7, and even with the comments there I'm not sure exactly how to go about making the changes I'm after. Also, I'm confused by what effect using sql to change the languages would have on the image file paths.

Could someone who knows the internals of the new multilingual system (and mysql!) better than I do provide any guidance? All I want to do is convert this uni-lingual 'english' site (where the content is german) into a unilingual ger-DE site throughout. I could downgrade back to 3.7 quite easily if that would make it any easier.

Thanks
Matthew

http://carroll.org.uk

Kristof Coomans

Sunday 18 June 2006 11:59:47 pm

Hi Matthew

Don't forget about the language id's stored in the db: ezcontentobject_attribute.language_id, ezcontentobject_version.initial_language_id and the language mask: ezcontentobject_version.language_mask. You will find more info about the new fields for the improved multilingual support for 3.8 in http://pubsvn.ez.no/nextgen/trunk/doc/features/3.8/multi-language_features.txt . It also contains info on how the language masks are calculated.

If you didn't have to do too much work to upgrade this site to 3.8, I would recommend downgrading first and correcting the language on a 3.7 site. At first sight this will be more simple.

You will have to modify the paths of the files and images because they indeed use the language code. Maybe a shell script can do this job for you.

Good luck!

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.