Mar 23rd, 2010, 9:52 AM
(Mar 23rd, 2010, 5:47 AM)BlueRobot Wrote: Looking through MySQL bugs and forums - seems like this issue is being addressed by:
1) keeping InnoDB and splitting the table into multiple tables
2) Changing the table from InnoDB to MyISAM
I'm going to do some tests on a development database changing from text to mediumtext/longtext and see if that makes any difference.
I did some tests - the error is not related to the field size but the size of the entire record.
MyISAM tables seemed to work fine, so I changed the form tables over. I'm not worried about upgrades as this website will only be used for about another month or so.