[Koha-bugs] [Bug 28534] pending_offline_circulations table uses MyISAM engine

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

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

--- Comment #4 from Nick Clemens <nick at bywatersolutions.com> ---
(In reply to David Nind from comment #2)
> I wasn't sure how to test this (using koha-testing-docker), but thought that
> this would work:
> 
> 1. Check table structure in the database:
>    . koha-mysql kohadev
>    . show create table pending_offline_operations;
>    . should show as "..ENGINE=MyISAM..."
> 2. Apply patch
> 3. Update the database (updatedatabase)
> 4. Check the table structure as per step 1 - should show as
> "..ENGINE=INNODB.."
> 
> It does update if I do a reset_all, but for the existing installations I
> seem to be missing something... (restarting the container didn't work for me
> - docker restart koha_db_1)?

I added an atomic update to fix existing installs. I added a create table as
well, one of our sites did not have MyISAM enabled, so the table was not
created. To test:
1 - Check current table structure
2 - Apply patch
3 - Update database
4 - Confirm table structure is correct
5 - Drop the table 'DROP TABLE pending_offline_operations'
6 - Update database
7 - Confirm table is created
8 - reset_all
9 - Check the structure and confirm table is created as InnoDB

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