30 Mar
2011
30 Mar
'11
9:18 a.m.
On 03/30/2011 02:21 AM, coldserenity wrote:
Hello,
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 on einteresting 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.
Is this a known issue? Any circumstances under which it might occur? I've
experienced it at least on version 2.4 and 2.6.
Try checking the language if those two documents. (XWD_LANGUAGE in sql)
Since 2 translations of the same document are the actually 2 distinct documents, it is
possible for
them to have different parents.
If MyHappySpace.InitialRequirements was an orphan, then it was translated the translation
would too
be an orphan. Then if the original document was corrected the correction would not carry
over to the
translation.
As for the negative IDs, that is normal. They are not sequential but rather generated by a
hashcode
of the document name and language in what is one of the more embarrassing functions in the
code base.
Caleb
Regards,
Roman
--
View this message in context:
http://xwiki.475771.n2.nabble.com/Phantom-documents-tp6221973p6221973.html
Sent from the XWiki- Users mailing list archive at Nabble.com.
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users