Details
-
Bug
-
Resolution: Unresolved
-
Major
-
None
-
2.6
-
None
-
*The issue appeared on:* XWiki 2.6
*Current version is:* XWiki Enterprise 3.0-rc-1.35909
*Upgrade chain:* 2.2.2 -> 2.2.3 -> 2.2.4 -> 2.3 -> 2.4 -> 2.6 -> 3.0RC1
-
Unknown
-
Description
I've recently noticed that one of the documents on XWiki is in the orphaned list while clicking on it redirects me to the document that obviously has parent (path in the above section is present).
Going to the database I found out one interesting thing
mysql> select xwd_id, xwd_name, xwd_fullname, xwd_parent, xwd_version, xwd_translation from xwikidoc where xwd_name like 'InitialRequirements'; +------------+---------------------+----------------------------------+--------------------------------+-------------+-----------------+ | xwd_id | xwd_name | xwd_fullname | xwd_parent | xwd_version | xwd_translation | +------------+---------------------+----------------------------------+--------------------------------+-------------+-----------------+ | 43295369 | InitialRequirements | MyHappySpace.InitialRequirements | | 5.1 | 1 | | -536599142 | InitialRequirements | MyHappySpace.InitialRequirements | xwiki:MyHappySpace.UserStories | 25.2 | 1 | +------------+---------------------+----------------------------------+--------------------------------+-------------+-----------------+ 2 rows in set (0.00 sec)
As I understand it's not quite normal to have document wit negative ID. I remember such issue happening before, the solution to it was to back-up the document content, delete the document. This would make "the document behind" (or phantom document) visible, delete the phantom document, and then create the document once more, restoring it from the backup.
If you'd ask me for circumstances under which it occurred, I recollect only in general - we were simultaneously working on the document trying to create it and import its content from MSWord file. Issue with this document occurred on XWiki v2.6
Try checking the language of those two documents exposed that they have different xwd_language values
mysql> select xwd_id, xwd_language, xwd_default_language from xwikidoc where xwd_name like 'InitialRequirements'; +------------+--------------+----------------------+ | xwd_id | xwd_language | xwd_default_language | +------------+--------------+----------------------+ | 43295369 | en | | | -536599142 | | en | +------------+--------------+----------------------+ 2 rows in set (0.00 sec)
It's important to mention that Multilingual option is turned off and default language is set to 'en.
I have also checked the entire DB and only 2 documents in our database have 'en' language.
The rest of them have empty language value. I have checked the second document with 'en' set - and it too has a phantom.
This issue is logged based on following discussion in mailing list http://xwiki.475771.n2.nabble.com/Phantom-documents-td6221973.html
Related mail threads