Forums / Install & configuration / Collected Information not Displaying Anything

"Please Note:

At the specific request of Ibexa we are changing this projects name to "Exponential" or "Exponential (CMS)" effective as of August, 11th 2025.
This project is not associated with the original eZ Publish software or its original developer, eZ Systems or Ibexa".

Collected Information not Displaying Anything

Previous topic

Install & configuration

Next topic

Author	Message
John Laux	Wednesday 14 December 2005 4:39:11 pm ez version = 3.6.4 When I go to the "Setup" tab and then click on "Collected Information" all I see is one collection like this: First collection Last Collection Collections 12/31/1969 07:00 pm 12/31/1969 07:00 pm 1 When I view the SQL Debug info this is what I get: Module start 'infocollector' Query error: You have an error in your SQL syntax near 'OFFSET 0' at line 1. Query: SELECT DISTINCT ezinfocollection.contentobject_id, ezcontentobject.name, ezcontentobject_tree.main_node_id, ezcontentclass.name AS class_name, ezcontentclass.identifier AS class_identifier FROM ezinfocollection, ezcontentobject, ezcontentobject_tree, ezcontentclass WHERE ezinfocollection.contentobject_id=ezcontentobject.id AND ezcontentobject.contentclass_id=ezcontentclass.id AND ezinfocollection.contentobject_id=ezcontentobject_tree.contentobject_id LIMIT 25 OFFSET 0 This is what the error log says: [ Dec 14 2005 20:27:14 ] [68.112.247.238] Timing Point: Module start 'infocollector' [ Dec 14 2005 20:27:14 ] [68.112.247.238] Query error: You have an error in your SQL syntax near 'OFFSET 0' at line 1. Query: SELECT DISTINCT ezinfocollection.contentobject_id, ezcontentobject.name, ezcontentobject_tree.main_node_id, ezcontentclass.name AS class_name, ezcontentclass.identifier AS class_identifier FROM ezinfocollection, ezcontentobject, ezcontentobject_tree, ezcontentclass WHERE ezinfocollection.contentobject_id=ezcontentobject.id AND ezcontentobject.contentclass_id=ezcontentclass.id AND ezinfocollection.contentobject_id=ezcontentobject_tree.contentobject_id LIMIT 25 OFFSET 0 [ Dec 14 2005 20:27:14 ] [68.112.247.238] Query error: You have an error in your SQL syntax near '' at line 1. Query: SELECT * FROM ezinfocollection WHERE contentobject_id= When I click to view the collection this is what I get: The requested object is not available. Debug: Error ocurred using URI: /infocollector/collectionlist It won't let me remove it either! It says: 0 collection will be removed. I have been working on the Feedback Form and have looked at the tables: ezinfocollection_attribute and ezinfocollection and I have about 90 or so entries in those tables, but I can't find the 0 collection. Does anyone have a clue about this...It's driving me mad! Thanks

Author

Message

John Laux

Wednesday 14 December 2005 4:39:11 pm

ez version = 3.6.4

When I go to the "Setup" tab and then click on "Collected Information" all I see is one collection like this:

First collection Last Collection Collections
12/31/1969 07:00 pm 12/31/1969 07:00 pm 1

When I view the SQL Debug info this is what I get:

Module start 'infocollector'

Query error: You have an error in your SQL syntax near 'OFFSET 0' at line 1. Query: SELECT DISTINCT ezinfocollection.contentobject_id, ezcontentobject.name, ezcontentobject_tree.main_node_id, ezcontentclass.name AS class_name, ezcontentclass.identifier AS class_identifier FROM ezinfocollection, ezcontentobject, ezcontentobject_tree, ezcontentclass WHERE ezinfocollection.contentobject_id=ezcontentobject.id AND ezcontentobject.contentclass_id=ezcontentclass.id AND ezinfocollection.contentobject_id=ezcontentobject_tree.contentobject_id LIMIT 25 OFFSET 0

This is what the error log says:

[ Dec 14 2005 20:27:14 ] [68.112.247.238] Timing Point: Module start 'infocollector'
[ Dec 14 2005 20:27:14 ] [68.112.247.238] Query error: You have an error in your SQL syntax near 'OFFSET 0' at line 1. Query: SELECT DISTINCT ezinfocollection.contentobject_id, ezcontentobject.name, ezcontentobject_tree.main_node_id, ezcontentclass.name AS class_name, ezcontentclass.identifier AS class_identifier FROM ezinfocollection, ezcontentobject, ezcontentobject_tree, ezcontentclass WHERE ezinfocollection.contentobject_id=ezcontentobject.id AND ezcontentobject.contentclass_id=ezcontentclass.id AND ezinfocollection.contentobject_id=ezcontentobject_tree.contentobject_id LIMIT 25 OFFSET 0
[ Dec 14 2005 20:27:14 ] [68.112.247.238] Query error: You have an error in your SQL syntax near '' at line 1. Query: SELECT * FROM ezinfocollection WHERE contentobject_id=

When I click to view the collection this is what I get:

The requested object is not available.
Debug: Error ocurred using URI: /infocollector/collectionlist

It won't let me remove it either! It says: 0 collection will be removed.

I have been working on the Feedback Form and have looked at the tables: ezinfocollection_attribute and ezinfocollection and I have about 90 or so entries in those tables, but I can't find the 0 collection.

Does anyone have a clue about this...It's driving me mad!

Thanks