[Koha-bugs] [Bug 22128] koha-remove fails mysql ERROR 1133 (42000) at line 2: Can't find any matching row in the user table

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22128

Liz Rea <wizzyrea at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #89528|0                           |1
        is obsolete|                            |

--- Comment #2 from Liz Rea <wizzyrea at gmail.com> ---
Created attachment 90081
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=90081&action=edit
Bug 22128: Use DROP USER IF EXISTS instead of GRANT USAGE before DROP USAGE

MySQL 5.7 is old, and the latest versions fail on "GRANT USAGE" if the
user does not exist. "DROP USER IF EXISTS" has been with us since 5.7,
so all users should have it by now. This patch fixes the issue.

To test:

Try to koha_remove a site, and if it works with no errors, all good!

Note: 
I reformatted this patch to community guidelines, and did not test it. I took
the intent of the patch, and made it so that it would work. The work is
Rudolf's and I have attributed it as such.

-- 
You are receiving this mail because:
You are watching all bug changes.