Sorry I'm not really an expert on this script, just know it was used in cases like this. Le 27 oct. 2014 18:41, "Paul Libbrecht" <[email protected]> a écrit :
> Thank you very much Thomas, > > that script rocks! > > In my development machine, it has worked trouble-freely. > And indeed the simple SpaceIndex has stopped confusing cases afterwards. > But may other things will do. > > However, the script issued a number of errors: > > ERROR 1025 (HY000) at line 1: Error on rename of > './curriki1_15/#sql-1e1f_a8' to './curriki1_15/xwikiproperties' (errno: 150) > > (which constraint-integrity violations) > > And indeed, the tables are not with the right collation keys there. > > Is there anything else bad I should fear about these errors? > Do I have a way to avoid them? Or to know more about them? > > thanks in advance. > > paul > > On 25 oct. 2014, at 10:59, Thomas Mortagne <[email protected]> > wrote: > > > Yes your issue sounds like wrong MySQL encoding/collation (which is an > > easy mistake since the default MySQL setup is wrong for XWiki). The > > right one is utf8_bin. > > > > You might be interested by > > > http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMySQL#HConvertadatabasefromlatin128orcollationutf8_ci29toutf82Futf8_bin > . > > > > On Sat, Oct 25, 2014 at 12:05 AM, Paul Libbrecht <[email protected]> > wrote: > >> Hello XWiki experts, > >> > >> we seem to be encountering a few HQL queries which return us document > names with the wrong casing! E.g. richard instead of Richard. > >> > >> One case where we do not even have any curriki specific is > Main/SpaceIndex?space=Coll_anntoniaowens which shows documents of > Coll_AnntoniaOwens (only). > >> > >> Is there something I can suspect for this issue? > >> Would there be somewhere a case-insensitivty default in MySQL? (the > question at > http://stackoverflow.com/questions/7857669/mysql-case-sensitive-query > seems to say so). However changing SQL is not really an option. > >> > >> thanks in advance. > >> > >> Paul > >> > >> _______________________________________________ > >> devs mailing list > >> [email protected] > >> http://lists.xwiki.org/mailman/listinfo/devs > > > > > > > > -- > > Thomas Mortagne > > _______________________________________________ > > devs mailing list > > [email protected] > > http://lists.xwiki.org/mailman/listinfo/devs > > _______________________________________________ > devs mailing list > [email protected] > http://lists.xwiki.org/mailman/listinfo/devs > _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
