Page 1 of 1

Packet / database issue

Posted: Thu Feb 01, 2018 12:57 pm
by Throwaway
We have pretty big dynaforms being used but for some reason when they're being saved/submitted. It throws this error.
Code: Select all
No database selected [Native Error: MySQL server has gone away]
The issue is that we've modified the timeout and increased the max packet size to 500M, and those worked momentarily. Then I got this error on another case.
Code: Select all
Unable to execute UPDATE statement. [wrapped: Could not execute update [Native Error: Got a packet bigger than 'max_allowed_packet' bytes]
PM shows 500M as the packet size, is it reset or hardcoded in ProcessMaker? I don't see any issues in sysGeneric.php

Re: Packet / database issue

Posted: Thu Feb 01, 2018 10:22 pm
by amosbatto
You can check what the current settings are by creating a trigger in your process with this code:
Code: Select all
$aSettings = ini_get_all();
print "<pre>";
print_r($aSettings);
die; 
See: http://php.net/manual/en/function.ini-get-all.php

You probably have to increase max_allowed_packet, max_post_size and max_input_vars.