Skip to content

Instantly share code, notes, and snippets.

@SylvainGuittard
Created March 9, 2015 15:14
Show Gist options
  • Save SylvainGuittard/943c8f392e29959dafca to your computer and use it in GitHub Desktop.
Save SylvainGuittard/943c8f392e29959dafca to your computer and use it in GitHub Desktop.
Upgrade 5.4
Query error (1054): Unknown column 'ezcontentclass.id' in 'on clause'. Query: SELECT ezcontentobject_link.contentclassattribute_id,
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
, ezcontentclass_name.name AS contentclass_name
FROM
ezcontentclass,
ezcontentobject,
ezcontentobject_link,
ezcontentobject_name
INNER JOIN ezcontentclass_name ON (ezcontentclass.id = ezcontentclass_name.contentclass_id AND
ezcontentclass.version = ezcontentclass_name.contentclass_version AND
( ezcontentclass_name.language_id & ezcontentclass.language_mask > 0 AND
( ( ezcontentclass.language_mask - ( ezcontentclass.language_mask & ezcontentclass_name.language_id ) ) & 1 )
+ ( ( ( ezcontentclass.language_mask - ( ezcontentclass.language_mask & ezcontentclass_name.language_id ) ) & 65536 ) >> 15 )
+ ( ( ( ezcontentclass.language_mask - ( ezcontentclass.language_mask & ezcontentclass_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentclass_name.language_id & 1 )
+ ( ( ezcontentclass_name.language_id & 65536 ) >> 15 )
+ ( ( ezcontentclass_name.language_id & 2 ) << 1 )
)
)
WHERE
ezcontentclass.id=ezcontentobject.contentclass_id AND
ezcontentclass.version=0 AND
ezcontentobject.status=1 AND
( relation_type & 7 ) <> 0
AND ezcontentobject.id=ezcontentobject_link.to_contentobject_id AND
ezcontentobject_link.from_contentobject_id='1982' AND
ezcontentobject_link.from_contentobject_version='3'
AND
ezcontentobject.id = ezcontentobject_name.contentobject_id AND
ezcontentobject.current_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 ) ) & 65536 ) >> 15 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 65536 ) >> 15 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
)
ORDER BY contentclass_name ASC, ezcontentobject_name.name ASC
@damianz5
Copy link

fixed version:
[..]
FROM
ezcontentobject,
ezcontentobject_link,
ezcontentobject_name,
ezcontentclass
INNER JOIN ezcontentclass_name
[..]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment