Forums / Install & configuration / Collected Information not Displaying Anything

Collected Information not Displaying Anything

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