7 Nov
2011
7 Nov
'11
3:56 p.m.
Well if you cannot find anything wrong from your end, you can just ignore
these errors.
Ludovic
2011/11/7 Yang Li <yang.lee.cool(a)gmail.com>
于 2011/11/7 22:41, Ludovic Dubost 写道:
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
not
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
--
Ludovic Dubost
Founder and CEO
Blog: http://blog.ludovic.org/
XWiki: http://www.xwiki.com
Skype: ldubost GTalk: ldubost
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
>> 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;
and verify it's translations.
Our site use zh, not multilanguage. Where to define the language set and
how to check the document's translations?
> 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 reachable I believe.
These pages are fully reachable...We created these pages by creating a
link first and then clicking the question mark.
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>
>> 于 2011/11/7 22:03, Ludovic Dubost 写道:
>>> 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/**mailman/listinfo/users>
>>>
<http://**lists.xwiki.org/mailman/**listinfo/users<
http://lists.xwiki.org/mailman/listinfo/users>
>>>
>>
> ______________________________**_________________
> users mailing list
> users(a)xwiki.org
> http://lists.xwiki.org/**mailman/listinfo/users<
http://lists.xwiki.org/mailman/listinfo/users>