Page Comparison

Problem

Importing Spaces does not automatically set them in the SubSpace navigation bar.

Solution

It is possible to set the parent space via HTTP Post remotely.

Use the URL: http://<Confluence_URL>/admin/subspace/changeparentspace.action
Method: POST
Request Header: Content-Type:application/x-www-form-urlencoded
Body: parentKey=<Key_of_the_parent_space>&key=<Key_of_the_space>

To set the parent space is also possible via database but we do not recommend to change any data in the database. It is very dangerous.

Do the following steps to set the parent space:

1. Get the id of the space description of the desired space:

   Code Block
   SELECT spacedescid FROM spaces WHERE spacekey='<SPACE_KEY>';

   
   

2. Set the parent space key in the space description of the desired space:

   Code Block

   INSERT INTO os_propertyentry (entity_name, entity_id, entity_key, key_type, boolean_val, double_val, string_val, text_val, long_val, int_val, date_val) VALUES ('confluence_ContentEntityObject',<SPACE_DESCRIPTION_KEY>,'metadatakeys',6,FALSE,0,NULL,'Parent',0,0,NULL); INSERT INTO os_propertyentry (entity_name, entity_id, entity_key, key_type, boolean_val, double_val, string_val, text_val, long_val, int_val, date_val) VALUES ('confluence_ContentEntityObject',<SPACE_DESCRIPTION_KEY>,'metadata.Parent',6,FALSE,0,NULL,'<PARENT_SPACE_KEY>',0,0,NULL);

   
   

3. Reset the application cache in the Confluence administration

   1. via "Confluence Admin" => "ADMINISTRATION" => "Cache Statistics" => "Flush All"

   2. via URL: http://<Confluence_URL>/admin/cachestatistics.action => "Flush All"

Related Articles