Internal Server Error on adding 1044th Client

[FriedGeek]

I've been trying to add a 1044th client to formtools but after I add it, I click on the "Clients" link through admin and get an internal server error. After removing the last entered client from the database using PHPMyAdmin, I can click the Client link and the Client table page displays normal in formtools.

I have over 8,000 form submissions between several clients and the submission tables display just fine so I figure it's not a problem with the MySQL server or its settings. There are no .htaccess files in the admin/clients/ directory that could cause this error. I tried entering a different client thinking that my server's firewall filters may have blocked the page due to some text that could be flagged as text within a malicious file but that made no difference. I need this fixed quick. Any suggestions? Thanks..

---

I think this may be a pagination issue. I had increased the number of client records per page from 25 to 50 and now it's working.

[FriedGeek]

There's still a problem. I'm getting forbidden errors as I add more clients and the only way to avoid the errors is to keep increasing the client records per page. I've added another 50 clients and had to increase the number of clients per page to 65. I tried decreasing random numbers down to 10 per page but nothing less than 65 works for 1094 clients (17 pages). Is there a setting within formtools that'll fix this? I don't know of any php.ini settings that relate to this problem. Suggestions welcome..

Thanks.

[FriedGeek]

I have resolved this problem. Some dedicated server hosts have certain settings set to where it's almost impossible to run an application without running into one issue or another. It's mostly due to security. Thankfully, there are configuration settings that can be tweaked and there are .htaccess rules that may be set in order to resolve certain issues.

In this case, the error didn't show up in my CPanel error logs but rather in the Mod Security log which is accessible only through WHM. This was the error:

ModSecurity: Output filter: Response body too large (over limit of 1024288, total not specified)

I have access to my server's root so I had gone into the apache directory and located this file: modsec2.conf
(Path on my server is: /usr/local/apache/conf/ - may not be the same on all dedicated servers)

I edited this line:
SecResponseBodyLimit 1024288
Just added 2 - 0's at the end so it would be 102428800 (Bytes)
I restarted apache then accessed formtools. I reset the clients per page to 25 and it worked! No more Internal Server Error.

If you don't manage your own dedicated server and are hosted and you run into this problem, you may need to contact your host and have him set this for you. He may be able to localize it to just your account through .htaccess rather than compromise his entire server's security.