[Bug 29009] New: Attempting to Koha-restore shows unnecessary SQL error
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.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29009 --- Comment #1 from Matthew LS <matthew.lindfield-seager@hope.edu.kh> --- Created attachment 124853 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=124853&action=edit Patch (from GitHub - https://github.com/Koha-Community/Koha/pull/42.patch) -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29009 Mike Lake <mikel@speleonics.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |mikel@speleonics.com.au --- Comment #2 from Mike Lake <mikel@speleonics.com.au> --- I can confirm that this patch removed that error for me using Debian 11.0 and koha-common 21.05.04-1 -- 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=29009 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |Needs Signoff -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29009 Magnus Enger <magnus@libriotech.no> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |RESOLVED CC| |magnus@libriotech.no Resolution|--- |DUPLICATE --- Comment #3 from Magnus Enger <magnus@libriotech.no> --- Looks like this was solved by bug 10517. *** This bug has been marked as a duplicate of bug 10517 *** -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org