https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28534 --- Comment #4 from Nick Clemens <nick@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.