08-08-2017, 06:29 PM
Your error can be caused by several issues, usually relating to sending large amounts of data to your database. If the data is large, change your variable before running your query. It defaults to 16MB but your shared host may have lowered it, or you might just be sending more than that. This changes it to 32MB:
It might also be timing out before it can finish sending. Also try this to change the seconds before timeout:
Try these and let us know if you still have issues. This isn't a UserSpice specific issue so you might find a faster answer by searching on Google than waiting for us to help you.
Code:
max_allowed_packet
Code:
SET GLOBAL max_allowed_packet=33554432;
It might also be timing out before it can finish sending. Also try this to change the seconds before timeout:
Code:
SET GLOBAL wait_timeout 10;
Try these and let us know if you still have issues. This isn't a UserSpice specific issue so you might find a faster answer by searching on Google than waiting for us to help you.