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

eZ debug

Timing:	Jan 18 2025 19:04:01
Script start
Timing:	Jan 18 2025 19:04:01
Module start 'layout'
Timing:	Jan 18 2025 19:04:01
Module start 'content'
Timing:	Jan 18 2025 19:04:02
Module end 'content'
Timing:	Jan 18 2025 19:04:02
Script end

Main resources:

Total runtime	1.2045 sec
Peak memory usage	4,096.0000 KB
Database Queries	46

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0097	588.1641	152.6563
Module start 'layout'	0.0097	0.0103	740.8203	39.5078
Module start 'content'	0.0199	1.1832	780.3281	411.1172
Module end 'content'	1.2032	0.0013	1,191.4453	8.1094
Script end	1.2045		1,199.5547

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0038	0.3115	16	0.0002
Check MTime	0.0015	0.1246	16	0.0001
Mysql Total
Database connection	0.0013	0.1084	1	0.0013
Mysqli_queries	1.1447	95.0367	46	0.0249
Looping result	0.0006	0.0483	44	0.0000
Template Total	1.1466	95.2	2	0.5733
Template load	0.0020	0.1660	2	0.0010
Template processing	1.1446	95.0276	2	0.5723
Template load and register function	0.0003	0.0270	1	0.0003
states
state_id_array	0.0028	0.2334	1	0.0028
state_identifier_array	0.0020	0.1665	2	0.0010
Override
Cache load	0.0017	0.1372	21	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0006	0.0516	1	0.0006
Fetch class attribute name	0.0006	0.0494	1	0.0006
XML
Image XML parsing	0.0001	0.0081	1	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0003	1	0.0000
General
dbfile	0.0011	0.0950	10	0.0001
String conversion	0.0000	0.0018	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
1	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
4	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
3	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 10 Number of unique templates used: 5

Time used to render debug report: 0.0001 secs