koha-remove utilises IF EXISTS in the DROP USER calls and this was only introduced in later versions of MySQL and MariaDB.. as such it breaks on many otherwise stable distributions.
MariaDB introduced the IF EXISTS clause in 10.1.3 and MySQL introduced it in 5.7
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.
(In reply to Rudolf Byker from comment #2) > 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. Debian stretch is still using MySQL 5.5, and we are suppose to support the oldstable debian version.
Sorry, I didn't know about the oldstable requirement. See my comment at https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22128
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.
(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
(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