https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24986
--- Comment #22 from Marcel de Rooy <[email protected]> --- Well, my conclusion for now is: I am all for pushing this change to prevent future problems. But my test tells me that when you already ran into this problem, you cant alter table anymore and resolve it like the dbrev does. I needed to set strict mode off to alter the 140 fields to TEXT. And even then it was not sufficient. Only when I dropped field 140, it was gone. Perhaps another limitation? InnoDB should allow 1000 columns, but I already passed some other limitation: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. Not sure, but it might help to combine the separate ALTERs into one statement instead of looping. And it might help to temporarily disable strict mode for the alter, but as I saw in my test, the change might not be enough to recover? -- You are receiving this mail because: 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/
