Empty ezcontentobject_name table after upgrade.

Tuesday 21 August 2007 5:24:40 am

Hi all,

I've been attempting to upgrade (a copy of) our site from 3.6.11 to 3.9.2.

After trying to follow all of the schema updates and upgrade scripts in order, I've ended up with a broken development site. The error I get is this:

Object is unavailable

The object you requested is not currently available.

Possible reasons for this are:

    * The id or name of the object was misspelled, try changing it.
    * The object is no longer available on the site.

With debug output turned on, the error seems to be occuring due to this query returning no rows:

Notice: eZMySQLDB::query(0 rows, 0.247 ms) query number per page:32  	Aug 21 2007 21:58:31

SELECT ezcontentobject.*,
                       ezcontentobject_tree.*,
                       ezcontentclass.serialized_name_list as class_serialized_name_list,
                       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 ( 2 ) AND
                      ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
                      ezcontentclass.version=0  AND
                      ezcontentclass.id = ezcontentobject.contentclass_id
                       AND 
 ezcontentobject.language_mask & 15 > 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.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) >> 2 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 2 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
   + ( ( ezcontentobject_name.language_id & 4 ) )
   + ( ( ezcontentobject_name.language_id & 2 ) << 2 )
 )

Error: error/view.php 	Aug 21 2007 21:58:31

Error ocurred using URI: /

Experimentation reveals that the query fails because ezcontentobject_name is empty. I'm guessing this happened when update_multilingual.php was run.

Questions!

a) is there a sensible/correct way of rebuilding this table?

b) If not, how do I avoid this happening again? What might I have done wrong?

--John Dalton