3.7 to 3.8 upgrade fails - ezcontent_language problem?

Friday 16 February 2007 2:39:00 pm

Hi all,

I finally found the time to bring our install up to snuff, and so made a few copies of the site to play with. The first step was to get us to 3.8 from 3.7.2. The db upgrade was fine, and the update multilingual appeared to work:

Step 1/6: Removing the drafts:
Step 2/6: Identifying languages used on the site:
  language: eng-GB (id 2)
Step 3/6: Fixing the ezcontentclass table.
Step 4/6: Fixing the ezcontentobject_name table.
Step 5/6: Fixing content object versions and attributes. Please be patient, this might take a while...
  done
Step 6/6: Fixing content objects. Please be patient, this might take a while...
  done
Done.
-bash-3.00$ /usr/local/covalent/ers/php4.4/bin/php update/common/scripts/updaterssimport.php -s nitle
Using siteaccess nitle for rss import update
Starting object re-indexing

done

and the ezcontent_language table is empty

mysql> select * from ezcontent_language;
Empty set (0.00 sec)

which seems to make the website unhappy. It errors out, and the code says:

SELECT id, name, locale, disabled
FROM   ezcontent_language
ORDER BY name ASC

Warning: eZContentLanguage::prioritizedLanguages 	Feb 16 2007 16:33:46

Language 'eng-GB' does not exist or is not used!

Notice: eZMySQLDB::query(0 rows, 0.612 ms) query number per page:4 	Feb 16 2007 16:33:46

SELECT ezcontentobject.*,
                       ezcontentobject_tree.*,
                       ezcontentclass.name as class_name,
                       ezcontentclass.identifier as class_identifier
                       , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                FROM ezcontentobject_tree,
                     ezcontentobject,
                     ezcontentclass
                     , ezcontentobject_name 
                WHERE node_id IN ( 108 ) AND
                      ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
                      ezcontentclass.version=0  AND
                      ezcontentclass.id = ezcontentobject.contentclass_id
                       AND 
 ezcontentobject.language_mask & 1 > 0 

                       and  ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
                                  ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
 )

Error: error/view.php 	Feb 16 2007 16:33:46

Error ocurred using URI: /ez38/index.php/nitle_admin/

Any thoughts on where in the world this is coming from?

Thursday 27 March 2008 4:15:04 am

Hi Łukasz,

This morning I was trying to upgrade 3.6.0 to 3.8.0, 3.8.0 to 3.9.0 and 3.9.0 to 3.10.0.

3.6.0 to 3.8.0 -> no problems, worked fine.

3.8.0. to 3.9.0

Error while running
update/common/scripts/3.9/updateclasstranslations.php -s <site_name> --languge=eng-GB

Error:
Language "eng-GB" doesn't exit.

I checked the script, the value for the language is empty. Checked the database, there is nothing in the table named as ezcontent_language.

I have already updated site.ini.append.php in public and admin siteaccess which is as follows:

For <site>_admin

[Regional Settings]
Locale=eng-GB
ContentObjectLocale=eng-GB
TextTranslation=disabled
SiteLanguageList[]
SiteLanguageList[]=eng-GB
ShowUntranslatedObjects=enabled

For public siteaccess

[Regional Settings]
Locale=eng-GB
ContentObjectLocale=eng-GB
TextTranslation=disabled
SiteLanguageList[]
SiteLanguageList[]=eng-GB
ShowUntranslatedObjects=disabled

Am I missing something???