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