[Koha-bugs] [Bug 29805] Database update fails in MySQL 5.7 because it's missing REGEXP_REPLACE

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29805

--- Comment #2 from Jonathan Druart <jonathan.druart+koha at gmail.com> ---
Created attachment 129050
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=129050&action=edit
Bug 29805: Fix 21.05.00.016 for MySQL 5.7

MySQL 5.7 is in Ubuntu 18.04 and does not support REGEXP_REPLACE. We can
easily rewrite it in Perl instead of dropping support on this Ubuntu LTS
version.

Test plan:
checkout a commit prior to 21.05.00.016
Create a notice template with
  <<opac_news.content>>
  [%opac_news.content %]
  << opac_news.content>>
  [% opac_news.content %]

Note that ISSUESLIP has already occurrence of 'opac_news.'

git checkout a branch with master + this patch
Run `updatedatabase` and notice that the 'opac_news.' occurrences have
been replaced with 'additional_contents.'

-- 
You are receiving this mail because:
You are watching all bug changes.