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