Questions and discussion about developing processes and programming in PHP, JavaScript, web services & REST API.

Moderator: amosbatto

By Throwaway
#813032
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
User avatar
By amosbatto
#813038
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.
Move draft Cases to Admin inbox

There are many problems with your process. I wil[…]

Thanks Amos, It's ok

3) Attach only selected quotes in the email to[…]

Hi, Indeed, i did attach the proper process map s[…]