Strange database entries in fresh ezpublish 3.6.1 install

Author Message

John Smith

Saturday 27 September 2008 4:53:14 am

Hi There,

Yesterday I installed fresh ezpublish 3.6.1 and saw some strange database entries in "ezcontentobject_tree" table which is messing up the "Location" entries (stated below) after upgrading from 3.6.1 to 3.8.x and onwards to 4.0.1

1. "Look and Feel" in the Design section getting two "Locations".
Design / <site title>( which is correct)
<site title> ( Node id= "55", do not need this entry)

2. "Gobal settings" in "Setup" section getting two locations:
Setup / Common INI settings (which is correct)
Common INI settings ( Node id= "57", do not need this entry)

<b>Question:</b>

a) Is it a bug in 3.6.1 or a feature. It has been deliberately inserted into the database - see the entries in sql below.

b) Why there is no insertion of these entries in version 3.8.x onwards to 4.0.x.

Look at the two lines in kernel\sql\common\cleandata.sql

INSERT INTO ezcontentobject_tree (contentobject_id, contentobject_is_published, contentobject_version, depth, is_hidden, is_invisible, main_node_id, modified_subnode, node_id, parent_node_id, path_identification_string, path_string, priority, remote_id, sort_field, sort_order) VALUES (52,0,0,2,0,0,0,0,55,48,'','/TEMPPATH',0,'fa9f3cff9cf90ecfae335718dcbddfe2',1,1);
INSERT INTO ezcontentobject_tree (contentobject_id, contentobject_is_published, contentobject_version, depth, is_hidden, is_invisible, main_node_id, modified_subnode, node_id, parent_node_id, path_identification_string, path_string, priority, remote_id, sort_field, sort_order) VALUES (54,0,0,2,0,0,0,0,57,48,'','/TEMPPATH',0,'772da20ecf88b3035d73cbdfcea0f119',1,1);

Deleting the entries from the table gives me the correct locations in "Look and Feel" and "Gobal settings" in "Setup". Please suggest, is it ok to delete the entries after upgrading.

Cheers

Regards
Smith

André R.

Saturday 27 September 2008 6:16:59 am

Looking over svn history, here are some fixes in cleandata that might be worth to fix before you do the upgrade:

rev: 15589
table: ezcontentobject_tree
comment: - Removed invalid nodes from common.sql
# They contained /TEMPPATH.
Removed node id (node for object id): 57 (54), 55 (52)

rev: 16690
table: ezcontentobject_tree
comment: - Fixed bug #8764: Wrong format in ezcontentobject_tree table for design/ez_publish.

  56,
  58,
  'design/ez_publish',
-  '/1/58/56',
+  '/1/58/56/',
  0,
  '772da20ecf88b3035d73cbdfcea0f119',
  1,

eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription
@: http://twitter.com/andrerom

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing: Jan 18 2025 16:22:08
Script start
Timing: Jan 18 2025 16:22:08
Module start 'layout'
Timing: Jan 18 2025 16:22:08
Module start 'content'
Timing: Jan 18 2025 16:22:09
Module end 'content'
Timing: Jan 18 2025 16:22:09
Script end

Main resources:

Total runtime0.8790 sec
Peak memory usage4,096.0000 KB
Database Queries54

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0060 589.2813152.6563
Module start 'layout' 0.00600.0044 741.937539.5078
Module start 'content' 0.01040.8668 781.4453536.2578
Module end 'content' 0.87720.0018 1,317.703112.0938
Script end 0.8790  1,329.7969 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00380.4297160.0002
Check MTime0.00140.1549160.0001
Mysql Total
Database connection0.00060.073110.0006
Mysqli_queries0.823693.6977540.0153
Looping result0.00050.0571520.0000
Template Total0.844996.120.4224
Template load0.00240.270820.0012
Template processing0.842595.844220.4212
Template load and register function0.00010.013710.0001
states
state_id_array0.00300.346510.0030
state_identifier_array0.00100.119320.0005
Override
Cache load0.00190.2186330.0001
Sytem overhead
Fetch class attribute can translate value0.00060.073120.0003
Fetch class attribute name0.00130.148130.0004
XML
Image XML parsing0.00160.181920.0008
class_abstraction
Instantiating content class attribute0.00000.001030.0000
General
dbfile0.00180.2015170.0001
String conversion0.00000.001440.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
2content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
8content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
5content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
2content/datatype/view/ezxmltags/literal.tpl<No override>extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tplEdit templateOverride template
1content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 20
 Number of unique templates used: 7

Time used to render debug report: 0.0002 secs