1. 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

Discussion in 'Troubleshooting and Problems' started by Mike Creuzer, Dec 28, 2011.

  1. Mike Creuzer

    Mike Creuzer Well-Known Member

    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
     

    Attached Files:

  2. Brogan

    Brogan XenForo Moderator Staff Member

  3. Mike Creuzer

    Mike Creuzer Well-Known Member

    We have around 15 styles installed.

    I just tried updating the board to 1.1.1 and I got the same error.
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    Yes, it's due to having too many styles installed.

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

    Mike Creuzer Well-Known Member

    Oh I didn't know there was a limit on how many styles can be installed.

    How can I uninstall mid-upgrade? I cannot finish the upgrade.
     
  6. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    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.
     
  7. Mike Creuzer

    Mike Creuzer Well-Known Member

    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?
     
  8. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    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.
     
    Mike Creuzer likes this.
  9. Forsaken

    Forsaken Well-Known Member

    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.
     
    TheVisitors and Mike Creuzer like this.
  10. Mike Creuzer

    Mike Creuzer Well-Known Member

    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.
     

Share This Page