[Koha-bugs] [Bug 30912] Database update fails for 21.12.00.016 Bug 30060

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Thu Jun 9 15:02:31 CEST 2022


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

--- Comment #7 from Nick Clemens <nick at bywatersolutions.com> ---
(In reply to Keith Sorbo from comment #4)
> 
> Where should I run the test plan?
> It looks like the test plan has sql commands. Do I run in the mysql command
> line? 
> I assume the restart_all and updatedatabase commands are macros created by
> koha?
> 
> (Please excuse my ignorance in the koha system.)
> 
> ***************
> Test plan:
> update systempreferences set value="21.1200015" where variable="version";
> restart_all
> updatedatabase
> 
> ALTER TABLE user_permissions DROP PRIMARY KEY;
> update systempreferences set value="21.1200015" where variable="version";
> restart_all
> updatedatabase
> **************

To run the SQL you should enter mysql like:
sudo koha-mysql kohadev

Where "kohadev" is your instance name

You can 'sudo koha-list' to confirm instance name(s)

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


More information about the Koha-bugs mailing list