Forums

Create Table Error in CF4

apryl 18 Oct, 2011
Hi,
I am having trouble creating a table for one of my forms. The form has 94 fields. I have been working with the same form for a while and have created tables from it before adding more fields. I tried trouble shooting to see which fields were causing conflict. I deleted the bottom section of the form and I was able to create a table. I tried to delete individual fields but could not isolate any one that might be the problem. I deleted a section from the top of the form and was again able to create the table. I have left all the defaults to VARCHAR 255 for all.
The only thing I have been able to figure out is that if I try to create a table with less than 90 fields it will save. Otherwise I get an error.
Is there some new limit in CF4 for number of field in table creation.
I have a form on another site using CF3 which had over 120 fields and was able to create a table.
Thank you,
apryl
GreyHead 18 Oct, 2011
Hi apryl,

There's no limit in ChronoForms but some servers/sites have 'protection' code that limits the number of variables that can be submitted at once. This seems to be the most frequent cause of problems that arise once some magic number of input/entries is passed.

Bob
This topic is locked and no more replies can be posted.