25 Oct
2014
25 Oct
'14
12:05 a.m.
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
25 Oct
25 Oct
10:59 a.m.
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
27 Oct
27 Oct
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
11:22 p.m.
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" <paul(a)hoplahup.net> 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:
_______________________________________________
devs mailing list
devs(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/devs
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
3665
days inactive
3668
days old
3 comments
2 participants
participants (2)
-
Paul Libbrecht -
Thomas Mortagne