• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Got a packet bigger than 'max_allowed_packet' bytes error message

Mike Creuzer

Well-known member
#1
Hello all,

I've attached a screenshot to a strange error when I try to import a skin XML file that I built over localhost. The file size is around 72KB, and my server has handled plenty larger than that :p. Any ideas what is causing this?

Furthermore, it also inserts the skin into the database, but it does't recache/rebuild/insert the correct data, and I've tried as both a parent and a child skin.

Any help would be great, just spent the last 70+ hours straight on this skin :p

Thanks,
Mike
 

Attachments

Brogan

XenForo moderator
Staff member
#4
Yes, it's due to having too many styles installed.

The simplest solution would be to uninstall some styles and reinstall afterwards.
 

Jake Bunce

XenForo moderator
Staff member
#6
How can I uninstall mid-upgrade? I cannot finish the upgrade.
There is no simple way to manually uninstall a style. It needs to be done through the Admin CP. I recommend one of the following:

1) Ask your host or server person to increase the max_allowed_packet setting in MySQL. That should allow the rebuild to finish.

2) Revert to a backup from before the upgrade.
 

Mike Creuzer

Well-known member
#7
Thanks a lot, I shall give that a try. Worst case scenario I just reinstall the board, not a biggie.

What is the maximum number of styles allowed before we get this error?
 

Jake Bunce

XenForo moderator
Staff member
#8
Thanks a lot, I shall give that a try. Worst case scenario I just reinstall the board, not a biggie.

What is the maximum number of styles allowed before we get this error?
It depends on your server. There is no hard limit, but the rebuild process is intensive enough that you can encounter problems with too many styles. You had problems with 15 styles. Other people have problems with half as many. I would say 5 is always safe.
 

Forsaken

Well-known member
#9
Thanks a lot, I shall give that a try. Worst case scenario I just reinstall the board, not a biggie.

What is the maximum number of styles allowed before we get this error?
I've gotten the area with as little as 7 styles, and as many as ~20.

With the new server we moved too we upgraded the packet size to 128mb as between Kim and myself we'll have more than 30 styles by next summer.

This is really the only big complaint I have with the style system.
 

Mike Creuzer

Well-known member
#10
Thanks for the support everyone. We changed the setting from 1MB to 16MB and now everything works without any problems. I will see how far the 16MB gets us, and I'll try to either post it here or somewhere for people to see.