2009/8/23 Jim Burgess <rails-mailing-l...@andreas-s.net>: > > I've managed to understand / solve the problem and just wanted to post > back here in case it helps anyone else. > Having read this: http://bugs.mysql.com/bug.php?id=10035 > it appears that this error is caused when a MySQL table has more than 10 > columns of the type "text". > I tested this by creating a form with 11 text fields. I filled ten of > them with input of 15,000 chrs and submitted it - everything fine. I > stuck 15,000 characters in the eleventh text field and sure enough the > same error was thrown. I started deleting the characters in the eleventh > text field and at some point I was able to successfully submit the form. > This only appears to be an issue upwards of MySQL 4.1.11 which also > explains why my old form (PHP version) didn't crash (it's operating with > MySQL 4.0.24) > If I understand the advice given on > http://bugs.mysql.com/bug.php?id=10035 correctly then the solution to > this is to save one's data in two tables, which is what I have done.
Yet another reason to use PostgreSQL? Colin --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk@googlegroups.com To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---