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

Not a Bug data registry produces a big packet in the database?

Discussion in 'Resolved Bug Reports' started by Izagar, Jun 9, 2011.

  1. Izagar

    Izagar Active Member

    This is what I get when I try to upload it to my new server... Not sure if it's a bug or not. I need help fixing this...

    INSERT INTO `xf_data_registry` (`data_key`, `data_value`) VALUES ('styles', 0x613a393a7b693a31333b613a383a7b733a383a227374796c655f6964223b693a31333b733a393a22706172656e745f6964223b693a303b733a31313a22706172656e745f6c697374223b733a343a2231332c30223b733a353a227469746c65223b733a363a224175726f7261223b733a31313a226465736372697074696f6e223b733a303a22223b733a31303a2270726f70657274696573223b733a36363436333a22613a3330303a7b733a31343a22706167654261636b67726f756e64223b733a373a2223323332363631223b733a31373a22636f6e74656e744261636b67726f756e64223b733a373a2223313935383933223b733a31383a22746578744374726c4261636b67726f756e64223b733a31383a22726762283235352c203235352c2032353529223b733a31313a22636f6e74656e7454657874223b733a31383a22726762283235352c203235352c2032353529223b733a31333a227072696d6172794d656469756d223b733a303a22223b733a363a22686561646572223b613a313a7b733a31303a226261636b67726f756e64223b733a31393a226261636b67726f756e642d636f6c6f723a203b223b7d733a393a22696d61676550617468223b733a31343a227374796c6[...]

    MySQL said:
    #1153 - Got a packet bigger than 'max_allowed_packet' bytes

    Anything I can do to fix this or do I need to contact my host? =\
  2. Mike

    Mike XenForo Developer Staff Member

    When you say "upload it to your server", do you mean from a backup? I assume so as that's hex encoded.

    If so, you may need to change the settings of how you backup, or ask your host to import it via the command line (as the max allowed packet size can be increased).

    That said, it is possible if you have a lot of styles to generate a large cache like that. We'd recommend reducing the number of styles if possible.
  3. Izagar

    Izagar Active Member

    We only have like... 6 or more or something... It's BlackEnd, Default, four custom ones, and 1 Zelda one.
  4. Luke F

    Luke F Well-Known Member

    The column uses mediumblob so surely hex encoding is correct?

    Have always wondered why blob/varbinary is used so widely in XF - HeidiSQL displays the data in hex so it's really awkward to work with the database.
  5. Izagar

    Izagar Active Member

    Ok... Removing Hexidemical allowed me to upload it... Now to figure out why my database isn't working still.
  6. Mike

    Mike XenForo Developer Staff Member

    Serialized data is binary. (Make it a text field, add some UTF-8 characters, flip the encoding to something else and watch it break. Leave it as binary and it won't.)

    This is an issue with the export and varying max_allowed_packet sizes between servers then. A relatively common issue actually, but not something that we can do much about as it's all outside of XF.

Share This Page