CF6 form with just over 100 checkboxes (for a survey) now generates an HTML error 500 message when I try to edit

Resolve a ChronoForms 6 HTML error 500 when editing a form with many checkboxes.

Overview

The error occurs due to server resource limits and security settings when handling forms with over 100 fields.
Increase PHP memory_limit, max_input_vars, and max_execution_time in php.ini, switch from fast CGI to CGI, and temporarily disable mod_security to test.

Answered
ChronoForms v6
fa farscape 09 Aug, 2018
The setup is fairly basic ... writing a header record in one table and each response in another. Using partitions.
​
Has anyone else experienced this and, more importantly, found a fix, or is there a limit to how many fields one form can have?
​
Thanks!
fa farscape 10 Aug, 2018
Hi healyhatman. What setting, and what should it be?
​
Thanks!
fa farscape 10 Aug, 2018
Answer
OK, I got it working! Based on input from the site host, healyhatman, my ISP and Bob at Chronoengine, I made the following changes, in this order, and tested each before trying the next:
​
  1. increased memory_limit in php.ini (suggested by the site's host)
  2. switched from fast CGI to CGI (suggested by the site's host)
  3. turned off mod_security (Suggested above by healyhatman. I've since turned that back on)
  4. increased max_input_vars in php.ini (suggested by Bob, who said "a form with 100 checkboxes could have several thousand inputs in the admin form.")
  5. increased max_execution_time in php.ini (Bob also suggested turning on Joomla error reporting, which revealed a timeout error. That last item in the list did the trick, although the other things might have contributed.)
This topic is locked and no more replies can be posted.