Details
-
Bug
-
Resolution: Obsolete
-
Low
-
5.1
-
None
Description
NOTE: This bug report is for Confluence Server. Using Confluence Cloud? See the corresponding bug report.
This bug can cause undesired results in Confluence, such as the page properties report macro showing multiple versions of the same page in a single report.
Steps to Reproduce
- Create a page with the label "test"
- Edit the page created in step 1, and save (this creates version 2 of that page)
- Restore the page to version 1 (which now creates version 3 which is reverted from v1)
Notice that after the steps above, you will now obtain both version 2 and version 3 of the page, linked to the "test" label in the CONTENT_LABEL table:
SELECT * FROM CONTENT c JOIN CONTENT_LABEL cl ON c.CONTENTID = cl.CONTENTID JOIN LABEL l on cl.LABELID = l.LABELID WHERE l.NAME = 'test';
If the steps above are reproduced this way:
- Create a page with the page properties macro inserted (with label="test")
- Edit the page created in step 1, and save (this creates version 2 of that page)
- Restore the page to version 1 (which now creates version 3 which is reverted from v1)
- Create a page with the page properties report macro inserted, set to find pages with label="test"
You will realize that the page properties report macro in the page created in Step 4 will list down both version 2 and version 3 of the same page in that macro.
Workaround
- Take a backup of the database
- Run this query to remove these entries from CONTENT_LABEL:
DELETE FROM CONTENT_LABEL WHERE CONTENTID IN (SELECT CONTENTID FROM CONTENT WHERE PREVVER IS NOT NULL);
- Flush all the caches via Confluence Admin >> Cache Statistics
Attachments
Issue Links
- is duplicated by
-
CONFSERVER-31746 Duplicate Pages (Old Revisions) being shown in tables
- Closed
- is related to
-
CONFSERVER-29305 Page properties report displays deleted pages
- Closed
- relates to
-
CONFCLOUD-28813 Restoring a page to a previous version creates historic entries in CONTENT_LABEL
- Closed
- mentioned in
-
Wiki Page Loading...