于 2011/11/7 22:41, Ludovic Dubost 写道: > 2011/11/7 Yang Li <yang.lee.c...@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; >> > 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. > > 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 not > 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.c...@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@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@xwiki.org >> http://lists.xwiki.org/**mailman/listinfo/users<http://lists.xwiki.org/mailman/listinfo/users> >> > > _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
