[Koha] Fwd: update error

[Coehoorn, Joel]

Hopefully not the MySql. Version 5.5 is scary out of date, and has been
formally end of life since 2018. It hasn't even had security patches for 3
1/2 years.

Joel Coehoorn
Director of Information Technology
York College of Nebraska


On Tue, Mar 29, 2022 at 10:14 AM Martin Longo <jmlongo at uncu.edu.ar> wrote:

> Hello .. I am facing this problem too ... the thing is that the system
> I'm working on was upgraded from Debian 8.0 to Debian 9.0 ... and it
> seems to have Mysql 5.5 and MariaDB 10.1 installed ... as far as I know
> REGEXP_REPLACE should be available in MariaDB 10.0 and newer...
>
> Tkoha at lists.katipo.co.nzhis Koha instance has been installed via apt...
> is there any documentation about how to check which DBMS is Koha using
> and how to switch it?
>
> Thanks in advance
>
> El 6/1/22 a las 07:15, Katrin Fischer escribió:
> >
> > Hi Ana,
> >
> > please always keep conversation on the mailing list, so others can help
> > you too.
> >
> > It looks like REGEXP_REPLACE might be a feature only available in newer
> > MySQL versions. It doesn't seem to appear in the 5.7 manual, but only in
> > the 8.0 manual, but I am having trouble finding the version it was
> > introduced in.
> >
> > What OS are you using and is updating the DBMS or switching to MariaDB
> > an option?
> >
> > Katrin
> >
> >
> >
> > -------- Forwarded Message --------
> > Subject:     RE: update error
> > Date:     Tue, 4 Jan 2022 12:10:58 +0000
> > From:     anabela semedo <anabela556 at hotmail.com>
> > To:     Katrin Fischer <katrin.fischer.83 at web.de>
> >
> >
> >
> > Hi Katrin, thanks for your time.
> >
> > I use the mysql, version 5.7.38
> >
> > I still couldn't solve it.
> >
> > do I have to uninstall everything?
> >
> > Upgrade to 21.05.00.016 [14:16:28]: Bug 24387 - Rename opac_news with
> > additional_contents
> >
> > ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: FUNCTION
> > koha.biblioteca.REGEXP_REPLACE does not exist at
> > /usr/share/koha/lib/C4/Installer.pm line 738
> >
> > Thanks again,
> >
> > Ana Bela
> >
> > *De:*Katrin Fischer [mailto:katrin.fischer.83 at web.de]
> > *Enviada:* sábado, 1 de janeiro de 2022 10:53
> > *Para:* anabela semedo <anabela556 at hotmail.com>; Koha
> > <koha at lists.katipo.co.nz>
> > *Assunto:* Re: update error
> >
> > Hi Ana,
> >
> > better to copy the error into the email as attachments will be removed
> > on the mailing list:
> >
> > Upgrade to 21.05.00.016 [14:16:28]: Bug 24387 - Rename opac_news with
> > additional_contents
> >
> > ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: FUNCTION
> > koha.biblioteca.REGEXP_REPLACE does not exist at
> > /usr/share/koha/lib/C4/Installer.pm line 738
> >
> > Are you using MySQL or MariaDB and which is the version?
> >
> > Katrin
> >
> > On 30.12.21 17:36, anabela semedo wrote:
> >
> >    hello ever one
> >
> >    i have a problem here,
> >
> >    trying to update koha to the latest version
> >
> >    and i have this error here that i am not able to resolve.
> >
> >    can anybody help me?
> >
> >    thankyou.
> >
> >    Ana Bela Semedo
> > _______________________________________________
> >
> > Koha mailing list  http://koha-community.org
> > Koha at lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
>
> --
> Ing. J. Martin Longo
> Depto. Gestion Informatica
> SID - UNCuyo
> http://sid.uncu.edu.ar
>
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>