Created
March 9, 2015 15:14
-
-
Save SylvainGuittard/943c8f392e29959dafca to your computer and use it in GitHub Desktop.
Upgrade 5.4
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
fixed version:
[..]
FROM
ezcontentobject,
ezcontentobject_link,
ezcontentobject_name,
ezcontentclass
INNER JOIN ezcontentclass_name
[..]