Skip to content

Instantly share code, notes, and snippets.

@dpobel
Created May 11, 2012 12:40
Show Gist options
  • Select an option

  • Save dpobel/2659386 to your computer and use it in GitHub Desktop.

Select an option

Save dpobel/2659386 to your computer and use it in GitHub Desktop.
[ May 11 2012 14:37:42 ] [127.0.0.1] eZPostgreSQLDB:
Error: error executing query: SELECT
count( DISTINCT ezcontentobject_tree.node_id ) as count
FROM
ezcontentobject_tree
INNER JOIN ezcontentobject
INNER JOIN ezcontentclass
INNER JOIN ezcontentobject_name
WHERE ezcontentobject_tree.parent_node_id = 2 and
ezcontentclass.version=0 AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id AND
ezcontentclass.id = ezcontentobject.contentclass_id 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 ) ) & 16 ) >> 3 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 3 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 16 ) >> 3 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 3 )
)
AND
ezcontentobject.language_mask & 31 > 0
: ERREUR: erreur de syntaxe sur ou près de « WHERE »
LINE 11: WHERE ezcontentobject_tree.parent_node_id ...
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment