|
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
|