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...

[email protected] 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 <[email protected]>
To:     Katrin Fischer <[email protected]>



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:[email protected]]
*Enviada:* sábado, 1 de janeiro de 2022 10:53
*Para:* anabela semedo <[email protected]>; Koha
<[email protected]>
*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
[email protected]
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
[email protected]
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Reply via email to