i can't create a table in sql to conect my form

Hi all

I´m in a big problem. I did a form with 648 fields (a very very hard job) but finally, when i select this form and press "create table" the system display the structure to save, but pressing "save" an error in red is displaying with the following text "Check table query below:" follow by all the fields names and the kind of reg (datetime, varchar...)

First i thought in a limitation of mi server, but with mamp i have the same reaction.

Please i need help urgent. My job depends on it.

Thanks very much.

Hi oceanografos,

Please check the error message. You'll probably find that is says that the total size of all the fields you are trying to create is more than the allowed record size in MySQL. This will certainly be true if you have 648 mostly VARCHAR(255) inputs.

If this is the problem you will need to look at each of the inputs you wish to save and take the size down to the minimum you actually need.

Or, probably better, rethink the form and database design. It is unlikley that any form needs 648 inputs or 648 columns in one tabale :-(

Bob

Hi oceanografos,

You may also save the data to multiple tables using Chronoforms, but a 648 columns table is something not advised at all.

Regards,
Max