HS module update #7 is calling update_sql to update a serialized field.

You can't do this because this runs through the table prefixer, which breaks serialized arrays... I.e. the { and }.

I couldn't see this reported elsewhere.

Comments

wim leers’s picture

wim leers
Location Ghent 🇧🇪🇪🇺
commented
Assigned: Unassigned » wim leers

Interesting, I didn't think of that. Will be fixed soon.

pingers’s picture

pingers commented

I guess this a valid enough reason to avoid using serialized variables... if you ever need to use them in this manner.
But that's a can of worms I'm not daring to open :)

wim leers’s picture

wim leers
Location Ghent 🇧🇪🇪🇺
commented

It's not enough reason in this case. It'd become a table with *way* too many columns otherwise. And it's often only a couple of HS configs per site, so it'd be overkill.

wim leers’s picture

wim leers
Location Ghent 🇧🇪🇪🇺
commented
Title: update 7 serialize problem » update 7 is problematic: db_prefix_tables() breaks the serialized value
Status: Active » Fixed

The sole reason is this one: update_sql() sucks.

Weird that it didn't give any problems for me and many others though.

Fixed.

pingers’s picture

pingers commented

Much appreciated ;)

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.

pingers’s picture

pingers commented

FYI - this is still causing me problems - but should never be an issue again after tonight (updating live db - eek!).

Thanks anyway!