[Koha] Fwd: update error

[Katrin Fischer]

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