Wednesday 03 September 2003 2:13:31 am
Hi Jan ... its easy to check the sql debug, but i don`t think any1 can know which query is the needed debug, i got more than 4 page sql debug :( any way, when i cjange the 'RegionalSettings' to eng-GB I got the data, but I got black listing with any another language, and from the dubeg i get just this query with 0 rows :
---------------
Notice: eZMySQLDB::query(0 rows, 2.571 ms) query number per page:1 Mar 04 2004 12:03:47
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.name as class_name
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
, ezcontentobject_name
WHERE md5_path = '22016f8fa5b336a09c3b20c0d2a02262' AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 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.content_translation = 'hu' ----------------------------
Notice: eZMySQLDB::query(0 rows, 3.489 ms) query number per page:6 Mar 04 2004 12:03:47
SELECT id, collaboration_id, message_id, message_type, participant_id, created, modified
FROM ezcollab_item_message_link
WHERE collaboration_id='1' -----------------------------------
Notice: eZMySQLDB::query(0 rows, 2.992 ms) query number per page:12 Mar 04 2004 12:03:47
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.name as class_name
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
WHERE ezcontentobject_tree.contentobject_id=127 AND
ezcontentobject_tree.main_node_id = ezcontentobject_tree.node_id AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id --------------------------------------
Notice: eZMySQLDB::query(0 rows, 23.086 ms) query number per page:13 Mar 04 2004 12:03:47
SELECT ezcontentobject_attribute.* from ezcontentobject_attribute, ezcontentclass_attribute
WHERE
ezcontentclass_attribute.version = '0' AND
ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
ezcontentobject_attribute.version = '1' AND
ezcontentobject_attribute.contentobject_id = '127' AND
ezcontentobject_attribute.language_code = 'hu'
ORDER by ezcontentclass_attribute.placement ASC ------------------------------
SELECT
ezcontentobject.* , ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM
ezcontentobject,
ezcontentobject_link
, ezcontentobject_name
WHERE
ezcontentobject.id=ezcontentobject_link.to_contentobject_id AND
ezcontentobject_link.from_contentobject_id='127' AND
ezcontentobject_link.from_contentobject_version='1'
and ezcontentobject.id = ezcontentobject_name.contentobject_id and
ezcontentobject.current_version = ezcontentobject_name.content_version and ezcontentobject_name.content_translation = 'hu' ;; ###------------ why here is 2 ';;' above ------------ ## is this bug or I have some mistake here with the template, or with the data insertion ? thx alot !!
|