Running on Apache server with Joomla 3.8.12 and PHP 7.2.
PHP vars set to max in ,htaccess. Have verified that there isn't a database issue or that it is maxing out db connections.
Hosted at Liquid Web Cloud servers. They've checked everything and are looking into it further, but it doesn't appear to be an issue on their end and we don't think so either.
After creating a job application form, when we try to open it for editing, the server times out. Eventually, we can get it to pen after several attempts over 5 minutes or so. Then, after making any edits, the form will never save and just sits on the saving page without ever showing as saved or closing.
We also have this form on a few other sites and can't even get it to open.
No errors generated in the server error logs and no messages other than timing out.
Any ideas where to go or what to check?
Hello! Thank you for your help.
Our PHP is set to :
Maximum Input Variables 259200
max_execution_time 300
We have also already added this flag to the htaccess file: php_flag suhosin.simulation On as per another post. We did also try the suhosin values recommended in the FAQ, to no avail. We can't open the form, on the rare occasion we get it to open - we can't save any changes. There are no PHP errors in the log files.
Hi cyberspyder,
Can you take a form backup and post it here so that I can see if it opens OK on my test site.
Bob
Cool but next time just use the "File upload" button.
I looked all over for that.... where is it???
Ok sorry about that.[file=11009]General_Employment_Application_24_Sep_2018_15_17_33.cf6bak[/file]
Hi cyberspyder,
Please ignore: The form opens OK on my test server and I can edit and re-save it. It doesn't appear to be very complex:- 8 inputs (no submit button) in the Designer tab ; and only a Display Section action in the Setup tab.
Bob
Hmm. That is strange. I don't know what I did wrong, but here's the form front end. https://www.tacojakes.com/employment/
There are buttons on each page and it's got like 6 pages. The front end works the way we want it to, we just need to edit it, because they want to change all the dates from calendars to text blanks.
Hi Cyberspyder,
Ahhhh my apologies, I restored the wrong form download - mea culpa.
Yours restores but does not load in the editor: Fatal error: Maximum execution time of 30 seconds exceeded in . . .
It does look like a problem with servers settings because of the size of the form.
Bob
OK so what do we do about it? I have the server settings set to the suggested amounts. what can we do to make it more functional?
Hi cyberspider,
I suggest that you increase the max_execution_time setting until the form loads and saves correctly. If you temporarily set Site Error Reporting on then you can see the PHP error messages.
Bob
Hi GreyHead,
The server is set at the maximum. All recommended configurations were applied and it still would not work.
I was able to resolve the issue by doing the following:
1. I removed all the Save commands from the settings page.
2. I deleted the table from the database - not an issue since the there were no legit entries.
3. I was able to make my changes to the form and save normally.
4. I recreated the table
5. I added all the Save commands to the settings.
Now my form saves normally even with the database table connected. My assumption is - there was some corruption with the table after editing it repeatedly.
Hi cyberspyder ,
Well done - and thank you for letting us know. I have not seen a similar problem reported before.
Bob
