Hello
I am having issue with saving form and got this error.
attached the form
Error: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs .
Joomla version - 3.9.6
PHP version - 7.2
please check this and resolve the issue
Thanks[file=12271]application_emp_24_May_2019_14_42_17.cf6bak[/file]
For now you may try to open the #_chronoengine_forms6 table in the database and set the "sections" field to "longtext", that should work until the new update it out!
Best regards
Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
Hello
I have made the changes on this table #_chronoengine_forms6 in the database and set the "sections" field to "longtext"
but it's not working, same error is generating.
Please resolve this asap.
Do the same thing for functions
Hello
Please provide resolution for the issue, also let me know when the next update will be available.
I can not reproduce this issue here, are you usre that you have updated the field type of your forms6 table ?
Best regards
Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
I have made the changes on this table forms6 in the database and set the "sections" field to "longtext" and "functions" field also
but still getting same issue while saving the form.
form is already attached in the ticket.
Please try to reproduce the issue at your end using form i have given to you.
the issue is still not resolved by the given instructions
please provide resolutions asap!
How does it work with the new update ?
Best regards
Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
updated chronoform with the latest version
but still issue not resolved.
please check asap
Is your form particularly large?
Yes, it's very large, already attached in ticket.
please provide resolutions asap.
are you able to replicate the issue on form i have sent to you
still not get any proper solutions for that
please resolve the issue asap
I'm able to replicate the issue but I'm not sure why it's happening yet, because those fields are simply not that big they're nowhere near hitting the LONGTEXT limit.
please resolve the issue as you are replicating it right now, i have to deploy it to live site.
hello
it's almost 15 days ago issue
i am still waiting for solution.
FIGURED IT OUT
You are saving your data to the database, and you've selected "Auto Manage Data Table". But your form has HUNDREDS of fields, and MYSQL has a maximum size all of the columns together can be. Simply no getting around it - it's got nothing to do with Chronoforms.
You need to design your data table properly, with the correct data types for the fields, don't use "Auto manage data table", and only save the fields you actually need. If you really truly need all of them, make sure they're the right type. For example if it's a checkbox you want "boolean" not "varchar(60)" and you want your checkbox to be sending a 1 or 0 not "YES / NO"
Additionally, instead of having "employer1 employer2 employer3 .... employer 5" you should use a repeater area, and you should split the employer off into a separate data table or at the very list have all employer data in a single JSON column.
I spent a lot of time figuring this out for you, still annoyed I didn't get a response
I think I have this problem too. Thank you for pointing me in the right direction to start solving this!
What exactly is the problem you have ?
Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
