Jan 18th, 2010, 12:14 PM
(Jan 16th, 2010, 1:43 PM)Ben Wrote: Ah, that last line sums up the cause pretty well:
Quote:Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs
This is a database restriction. What hosting company do you use? It may be worth dropping them a line to request they increase the permitted size of database table rows.
Unfortunately, Form Tools won't be able to create that form for you with the database restriction in place. But it should definitely handle the situation more elegantly. I've logged this as a bug, here: http://bugs.formtools.org/index.php?cmd=view&id=191
I'll be sure to address it in an upcoming release.
In the meantime... I actually ran into this very same problem for the Prague Fringe festival sometime last year. For them, I ended up to reduce the total size of fields, keeping everything as small as possible. What you could try is reducing the database field size for all those fields that don't really need 255 chars. Are some that could use 20 chars or even 5? That may reduce the total size enough to get around it.
Good luck...!
- Ben
Thank you Ben! That worked perfectly! Ahhh that was a weight lifted off my shoulders! Thanks again
