[Solved]Long Text Fields Table Creation Issue

We are trying to create text boxes where people can paste in 2500 characters. I have used blob and text both long with characters set at 2500 and 4096. The table bombs when created and we are using Chronoforms V4 Joomla 2.5.6. Any suggestions?


Removing the characters all together worked like a charm.

Hi DerronW,

I don't think that either BLOB or TEXT take character counts, try deleting that entry. If you have a lot of VARCHAR(255) entries then you may hit the record size limit for MySQL, I think that is around 80 VARCHAR(255) columns (there's a FAQ with some more accurate info).

Bob

We have close to 70 but not 80?

DerronW,

?? You can try copying and pasting the MySQL query into PHPMyAdmin to see if you get a more helpful error message.

Bob