[Koha] MySQL 5 fixes

[Mike Dalgity]

I originally replied to Ms. Johnson off list but I'll post here for everyone
else following this topic.  I am not a developer but the following is what
I've come across on the subject.

According to Bug #1089
http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1089 MySQL 5 will NOT
be supported in Koha 2.x.  Apparently MySQL 5 introduces more problems other
than reserved keywords.  It's my understanding that the fix isn't as simple
as fixing the keywords and the search problems.  The patch that is included
in that bug report makes a LOT of changes, stats modules, aquistions, etc.
And the authour indicates that there are still additional problems the patch
doesn't fix or even introduces.  The probable reason that MySQL 5 isn't
supported is that it's a major undertaking to change everything and then
test it. Also the 2.x branch is supposed to be stable so a major change like
this is not recommended. AFAIK you will have to wait for Koha 3.0 to support
MySQL 5 (of course it can be modified to work if you really want it to). If
the developers have changed their plans someone please correct me.

Mike D.


-----Original Message-----
From: koha-bounces at lists.katipo.co.nz
[mailto:koha-bounces at lists.katipo.co.nz]On Behalf Of Alex King
Sent: September 29, 2006 5:40 PM
To: BWS Johnson
Cc: koha at lists.katipo.co.nz
Subject: Re: [Koha] MySQL 5 fixes


It looks like Koha version 2.2.5 was released in January.  Normally, the
download for 2.2.5 wouldn't be changed.  I would assume the fixes are in
the pipeline for the next version in the series, 2.2.6.

So when 2.2.6 is released I would expect it will work nicely with MySQL5.

Perhaps a warning could be put on the download page mentioning the
MySQL5 issue.

Cheers,

Alex

BWS Johnson wrote:
> Salvete!
>
> Is there a reason that the reserved language switch to make Koha play
> nice with MySQL 5 hasn't been incorporated into the downloads yet? Am
> I missing something?
>
> Cheers,
> Brooke @ Hinsdale MA
> ------------------------------------------------------------------------
>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
_______________________________________________
Koha mailing list
Koha at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha