[Koha-bugs] [Bug 28267] Koha-common package upgrade problem from 20.05.xx to 20.11.04-1

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

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

Liz Rea <wizzyrea at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |wizzyrea at gmail.com

--- Comment #20 from Liz Rea <wizzyrea at gmail.com> ---
I've seen this as well, very often in Koha where the database server started
out in 2012-era ubuntu, and the database has never been dropped and
recreated/reimported since.

Updating the rows to dynamic solved it. We went whole hog and did all the
tables since Koha was the only thing in the affected database server.

This will spit out the commands necessary to alter all of the tables, you can
pick and choose which ones you want, or do them all at once: 

for table in $(mysql --batch --skip-column-names
--defaults-extra-file=/etc/mysql/debian.cnf --execute="SELECT
CONCAT(TABLE_SCHEMA, '.', TABLE_NAME) FROM information_schema.TABLES WHERE
ENGINE = 'InnoDB' AND ROW_FORMAT IN('Redundant', 'Compact') AND TABLE_NAME NOT
IN('SYS_DATAFILES', 'SYS_FOREIGN', 'SYS_FOREIGN_COLS', 'SYS_TABLESPACES',
'SYS_VIRTUAL', 'SYS_ZIP_DICT', 'SYS_ZIP_DICT_COLS');"); do echo "ALTER TABLE
${table} ROW_FORMAT=DYNAMIC;"; done;

Be a little careful, this will spit out all tables in all databases. Be sure
that's what you want to do before going and pasting that into a mysql cli.

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