[Koha-bugs] [Bug 29009] New: Attempting to Koha-restore shows unnecessary SQL error
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Tue Sep 14 09:45:31 CEST 2021
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 at lists.koha-community.org
Reporter: matthew.lindfield-seager at hope.edu.kh
QA Contact: testopia at 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/a5a3a330cfc7c7d6c35db13326745dabf8fe0df3/debian/scripts/koha-remove#L69-70)
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.
More information about the Koha-bugs
mailing list