|
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
|
