• 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?

Izagar

Active member
#1
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? =\
 

Mike

XenForo developer
Staff member
#2
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.
 

Luke F

Well-known member
#4
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.
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.
 

Mike

XenForo developer
Staff member
#6
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.
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.)

Ok... Removing Hexidemical allowed me to upload it... Now to figure out why my database isn't working still.
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.