https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29009 Bug ID: 29009 Summary: Attempting to Koha-restore shows unnecessary SQL error Change sponsored?: --- Product: Koha Version: 21.05 Hardware: All OS: All Status: NEW Severity: trivial Priority: P5 - low Component: Installation and upgrade (command-line installer) Assignee: koha-bugs@lists.koha-community.org Reporter: matthew.lindfield-seager@hope.edu.kh QA Contact: testopia@bugs.koha-community.org `koha-restore` command outputs an error about being unable to drop the user: `ERROR 1396 (HY000) at line 1: Operation DROP USER failed for 'koha_library'@'%'` This can be avoided by adding `IF EXISTS` to the command (as has been done in [`koha-remove`](https://github.com/Koha-Community/Koha/blob/a5a3a330cfc7c7d6c35db13326745dab...) Tested on Ubuntu 20.04 LTS with Koha 21.05.02.003 and 21.05.03.001 N.B. This bug was originally filed as a [PR on GitHub](https://github.com/Koha-Community/Koha/pull/42) -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.