SQL ERROR - Got a packet bigger than 'max_allowed_packet'

Status
Not open for further replies.

dbjs2009

New Member
Messages
11
Reaction score
0
Points
1
Greetings,

After this migration, one section of my site, which is powered by PhpBB, started getting this error:
SQL ERROR [ mysqli ]

Got a packet bigger than 'max_allowed_packet' bytes [1153]

This is where it's happening: http://www.cncmasters.net/cm/downloads.php
Why did this happen after the migration? Did you lower the values? Are there still ongoing issues with the MySQL configurations?
Everything was working perfectly before the migration and this only started after it was reported done.
I'd greatly appreciate it if anyone could help me resolve this issue.
 
Last edited:

leafypiggy

Manager of Pens and Office Supplies
Staff member
Messages
3,818
Reaction score
163
Points
63
How big is the packet you're trying to send? We generally don't increase this setting without good reason. Only a severely MASSIVE query would cause this to happen.
 

dbjs2009

New Member
Messages
11
Reaction score
0
Points
1
The site has been running for more than five years, nothing has changed and I made no major modifications in the last years, and this has only started to show up after the migration? Can you please investigate the matter further?
 

leafypiggy

Manager of Pens and Office Supplies
Staff member
Messages
3,818
Reaction score
163
Points
63
We've never modified this setting on our free hosting servers. Given that link, the only thing I think you could possibly be storing is Blob-type data, which would certainly use a large query size (over 1M).

I've increased max_allowed_packet on your node to 2M. I will not increase it further.
 
Status
Not open for further replies.
Top