27 Oct
2014
27 Oct
'14
6:41 p.m.
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 <thomas.mortagne(a)xwiki.com> 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#HConv….
On Sat, Oct 25, 2014 at 12:05 AM, Paul Libbrecht <paul(a)hoplahup.net> 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
devs(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/devs
--
Thomas Mortagne
_______________________________________________
devs mailing list
devs(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/devs