Section 0 does not exist

Previous topic

Install & configuration

Next topic

Author	Message
Benjamin Selmer	Wednesday 13 September 2006 2:59:15 am I have upgraded a site from 3.4.0 to 3.8.3. Everything works just fine exept for one thing: On the old site all images are in section 0. On the new site there is no section zero. This causes all images to be inaccessible unless you are logged in as administrator. Is there a simple way of making them all part of another section? Anyone have a script? There are houndreds of objects with section 0 so doing it manually is not very tempting. Or is there a way to make a section with the id zero? Or does that zero mean that these objects are not part of any section? The images are scattered all over the content tree (not in the medialibrary). If I could move them all into the media library and then reasing the media section to the media folder, they should all become part ov the media section. But as I said, there are houndreds of them scattered all over the place. Is there a way of bulk moving all objects of a certain class?
Per-Espen Kindblad	Wednesday 13 September 2006 3:34:42 am I haven't tried this, but maybe you can fix this in the db, by using: update ezcontentobject set section_id=1 where contentclass_id =5; I guess your image class got id=5 Remember backup before you test ;) Best regards Per-Espen Kindblad
Benjamin Selmer	Wednesday 13 September 2006 3:57:52 am That will probably work. Thanks.

Author

Message

Benjamin Selmer

Wednesday 13 September 2006 2:59:15 am

I have upgraded a site from 3.4.0 to 3.8.3. Everything works just fine exept for one thing:

On the old site all images are in section 0. On the new site there is no section zero. This causes all images to be inaccessible unless you are logged in as administrator.

Is there a simple way of making them all part of another section? Anyone have a script? There are houndreds of objects with section 0 so doing it manually is not very tempting.

Or is there a way to make a section with the id zero? Or does that zero mean that these objects are not part of any section?

The images are scattered all over the content tree (not in the medialibrary). If I could move them all into the media library and then reasing the media section to the media folder, they should all become part ov the media section. But as I said, there are houndreds of them scattered all over the place. Is there a way of bulk moving all objects of a certain class?

Per-Espen Kindblad

Wednesday 13 September 2006 3:34:42 am

I haven't tried this, but maybe you can fix this in the db, by using:
update ezcontentobject set section_id=1 where contentclass_id =5;

I guess your image class got id=5

*Remember backup before you test* ;)

Best regards
Per-Espen Kindblad

Benjamin Selmer

Wednesday 13 September 2006 3:57:52 am

That will probably work.

Thanks.

eZ debug

Timing:	Jan 18 2025 05:05:38
Script start
Timing:	Jan 18 2025 05:05:38
Module start 'layout'
Timing:	Jan 18 2025 05:05:38
Module start 'content'
Timing:	Jan 18 2025 05:05:40
Module end 'content'
Timing:	Jan 18 2025 05:05:40
Script end

Main resources:

Total runtime	1.4284 sec
Peak memory usage	4,096.0000 KB
Database Queries	57

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0052	587.9375	152.6250
Module start 'layout'	0.0052	0.0027	740.5625	39.4453
Module start 'content'	0.0080	1.4185	780.0078	510.7188
Module end 'content'	1.4265	0.0019	1,290.7266	12.1641
Script end	1.4283		1,302.8906

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0035	0.2442	16	0.0002
Check MTime	0.0014	0.0958	16	0.0001
Mysql Total
Database connection	0.0006	0.0449	1	0.0006
Mysqli_queries	1.3784	96.5055	57	0.0242
Looping result	0.0005	0.0341	55	0.0000
Template Total	1.3871	97.1	2	0.6936
Template load	0.0019	0.1301	2	0.0009
Template processing	1.3853	96.9824	2	0.6926
Template load and register function	0.0001	0.0069	1	0.0001
states
state_id_array	0.0019	0.1324	1	0.0019
state_identifier_array	0.0059	0.4107	2	0.0029
Override
Cache load	0.0015	0.1074	21	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0006	0.0416	2	0.0003
Fetch class attribute name	0.0012	0.0821	5	0.0002
XML
Image XML parsing	0.0008	0.0578	2	0.0004
class_abstraction
Instantiating content class attribute	0.0000	0.0008	6	0.0000
General
dbfile	0.0011	0.0778	19	0.0001
String conversion	0.0000	0.0005	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
3	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
3	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
2	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: 14 Number of unique templates used: 6

Time used to render debug report: 0.0003 secs