https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23945 --- Comment #1 from Martin Renvoize <martin.renvoize@ptfs-europe.com> --- MariaDB introduced the IF EXISTS clause in 10.1.3 and MySQL introduced it in 5.7 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23945 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|enhancement |major -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23945 Rudolf Byker <rudolfbyker@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |rudolfbyker@gmail.com --- Comment #2 from Rudolf Byker <rudolfbyker@gmail.com> --- If you are still using MariaDB from 2015 (when 10.1.3 was released) or earlier, you have bigger problems than not being able to run `koha-remove`, i.e. security vulnerabilities. -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23945 --- Comment #4 from Rudolf Byker <rudolfbyker@gmail.com> --- Sorry, I didn't know about the oldstable requirement. See my comment at https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22128 -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23945 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |INVALID Status|NEW |RESOLVED --- Comment #5 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- So, I tried to install MySQL 5.5 on a debian 9 (old stable, stretch) and realized that it was not possible. Then I found this: https://mariadb.com/kb/en/library/moving-from-mysql-to-mariadb-in-debian-9/ Which basically says that it's expected and that Debian does no longer provide a MySQL package. So I feel like we are good here. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23945 --- Comment #7 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- (In reply to Marcel de Rooy from comment #6)

(In reply to Jonathan Druart from comment #3)

...

Debian stretch is still using MySQL 5.5, and we are suppose to support the oldstable debian version.

Jessie indeed

I meant Stretch: vagrant@kohadevbox$ more /etc/debian_version 9.11 vagrant@kohadevbox$ apt show mysql-server Package: mysql-server Version: 5.5.9999+default But that's not a "real" mysql-server package -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.