Personal spaces are no longer linked and creator is anonymous
プラットフォームについて: サーバーと Data Center のみ。この記事は、サーバーおよび Data Center プラットフォームのアトラシアン製品にのみ適用されます。
問題
User is unable to access his personal space via User Interface under the top right drop-down menu. User only sees Add Personal Space option instead of Personal Space.
症状
- Personal space links missing after a Confluence upgrade.
- Personal space still exists if accessed directly using the URL.
- The creator of the personal space is Anonymous
診断
Run this SQL query to check the CREATOR of the space. If it's NULL, then proceed to the solution below.
select * from SPACES WHERE SPACETYPE='personal'
原因
During the upgrade, for some unknown cause, all the personal space creator has changed to NULL causing the creator to be anonymous.
ソリューション
データベースの変更を行う場合は必ず事前にバックアップを取得してください。可能な場合は、まずステージング サーバーで SQL コマンドの変更、挿入、更新、または削除を行うようにします。
Also backup the Confluence Home directory before proceeding.
Run the query below and it will restore all the personal spaces to the original creator.
MySQL :
update spaces set creator = (select user_key from user_mapping where concat('~', username) = spacekey) where spacetype = 'personal' and creator is null;
PostgreSQL
update spaces set creator = (select user_key from user_mapping where spacekey = '~' || username) where spacetype = 'personal' and creator is null;
最終更新日 2018 年 11 月 14 日
Powered by Confluence and Scroll Viewport.