https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28267
Liz Rea <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #20 from Liz Rea <[email protected]> --- 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. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
