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@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@hotmail.com> To: Katrin Fischer <katrin.fischer.83@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@web.de] *Enviada:* sábado, 1 de janeiro de 2022 10:53 *Para:* anabela semedo <anabela556@hotmail.com>; Koha <koha@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@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