7 Nov
2011
7 Nov
'11
3:41 p.m.
2011/11/7 Yang Li <yang.lee.cool(a)gmail.com>
于 2011/11/7 22:10, Ludovic Dubost 写道:
Well you would need to delete the unnecessary data. It's a bit complicated
This means that you have a document which is a translation that has no
language set. This is not too normal. You might want to check that document
and verify it's translations.
to explain because it really depends which one is
showing up as wrong
Ludovic
I failed the following two queries:
select "Checking original documents that are marked translated" AS
"DOCUMENT - Translations";
select xwd_fullname, xwd_default_language, xwd_language from xwikidoc
where (xwd_language = "" OR xwd_language IS NULL) and xwd_translation != 0;
select "Checking orphaned translated document (without an original
document)" AS "DOCUMENT - Translations";
select tdoc.xwd_fullname, tdoc.xwd_default_language, tdoc.xwd_language
from xwikidoc as tdoc left join xwikidoc as doc on doc.xwd_fullname =
tdoc.xwd_fullname and tdoc.xwd_id != doc.xwd_id and doc.xwd_translation !=
1 where tdoc.xwd_translation = 1 and doc.xwd_translation IS NULL;
This means you would have a translated document in the database for which
the main document (main language one) is not existing. These pages are not
reachable I believe.
Ludovic
Several pages with Chinese as the page titles showed up. But I cannot
delete them because they are important pages. How can I fix them?
2011/11/7 Yang Li<yang.lee.cool(a)gmail.com>
--
Ludovic Dubost
Founder and CEO
Blog: http://blog.ludovic.org/
XWiki: http://www.xwiki.com
Skype: ldubost GTalk: ldubost
于 2011/11/7 22:03, Ludovic Dubost 写道:
______________________________**_________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/**mailman/listinfo/users<http://lists.xwiki.org/m…
You probably should script deleting the feed documents. Otherwise you'll
only remove part of it.
You might have added data to additional tables and missing indexes show
the
problem.
Using the Admin.Tools indexes in addition to the default ones my help.
Ludovic
Hi, I am Yang Li, and one small question: I tried the database
sanitycheck
script and found there are some rows selected, which is not desirable.
What
I'm supposed to do?
______________________________****_________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/****mailman/listinfo/users<http://lists.xwiki.org…
<http://**lists.xwiki.org/mailman/**listinfo/users<http://lists.xwiki.org/mailman/listinfo/users>