Strange database entries in fresh ezpublish 3.6.1 install

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