Support community for TTG plugins and products.
NOTICE
The Turning Gate's Community has moved to a new home, at https://discourse.theturninggate.net.
This forum is now closed, and exists here as a read-only archive.
You are not logged in.
Pages: 1
After updating to BL3, many searches on my website are now timing out with:
Something went wrong
Unexpected error: Maximum execution time of 30 seconds exceeded in PdoExtended.php on line 540
Please report error at http://community.theturninggate.net
For example, this search "http://rick.samcos.com/backlight/search/?q=steens" sometimes succeeds but has been failing >50% of the time today.
Previously, searches on my website often took >20 seconds, so they appear to always have been on the cusp of a 30 sec timeout. Appears that BL3 now has pushed many of them over that limit!
Rick
Offline
Ben will have to chime in on this. But I'm curious, are you able to estimate how many images are on your site?
Offline
Hi Rick, the execution time is set in the php.ini file using the variable max_execution_time. If you have access to the php.ini file, or your own file somewhere under your html directory, then try changing that to a higher value.
Another option would be to edit the file backlight/.htaccess and add a line like this:
php_value max_execution_time 60Where 60 should double the allowed time. In either case, setting it to 31 would be a good start to verify that the timeout has been changed. If successful then the message would read '...Maximum execution time of 31 seconds exceeded…'.
Can you email me the file backlight/data/publisher/master.sq3? I'll see whether there are any optimisations that can be made to speed up that query.
Offline
Thanks, Ben -- I changed php.ini max_execution_time and that worked. I'm seeing some searches take over 40 seconds so it sure seems like something changed in BL3, since I never had a search take over 30 secs. before (i.e., never saw the 30 sec. timeout).
I'll email you link to my master.sq3 file (34MB).
Rick
Offline
Pages: 1