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. > > 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.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> > -- Ludovic Dubost Founder and CEO Blog: http://blog.ludovic.org/ XWiki: http://www.xwiki.com Skype: ldubost GTalk: ldubost _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
