|
Thursday 06 May 2010 8:46:18 am
From this line "sql" query when the query is empty brings, such as repair it, is some language settings that I may be missing?.
He clarified that previously realized the steps from the 4.0.1 update to version 4.3
greetings and I hope some help. This is the sql:
SELECT
ezcontentclass.serialized_name_list AS class_serialized_name_list,
ezcontentclass.identifier as contentclass_identifier,
ezcontentclass.is_container as is_container,
ezcontentobject.* , ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM
ezcontentclass,
ezcontentobject,
ezcontentobject_link
, ezcontentobject_name
WHERE
ezcontentclass.id=ezcontentobject.contentclass_id
AND ezcontentclass.version=0
AND ezcontentobject.status=1
AND ezcontentobject_link.op_code='0'
AND ( relation_type & 7 ) <> 0
AND ezcontentobject.id=ezcontentobject_link.to_contentobject_id
AND ezcontentobject_link.from_contentobject_id='2214'
AND ezcontentobject_link.from_contentobject_version='10'
AND ezcontentobject.id = ezcontentobject_name.contentobject_id
AND ezcontentobject.current_version = ezcontentobject_name.content_version
AND ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0
*/If you remove this last part brings the right data ... */
AND ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
< ( ezcontentobject_name.language_id & 1 ) )
|