Serialized Data Issue

  • Resolved dliciaga

    (@dliciaga)


    11 years, 3 months ago

    So I search and replaced for serialized data. Needed to replace 1 word in a widget.

    Bad idea…..I hit the go button before I backed up my database (bigger mistake). All my widgets disappeared from my entire network.

    Got them back by hacking the includes/functions.php file:

    function maybe_unserialize( $original ) {
    if ( is_serialized( $original ) ) {
        $fixed = preg_replace_callback(
            '!(?<=^|;)s:(\d+)(?=:"(.*?)";(?:}|a:|s:|b:|i:|o:|N;))!s',
            'serialize_fix_callback',
            $original );
        return @unserialize( $fixed );
    }
    return $original;
}
function serialize_fix_callback($match) { return 's:' . strlen($match[2]); }

    The question is that the data is there, you don’t by chance know how to get it all back without this hack.

    http://wordpress.org/extend/plugins/search-and-replace/

Viewing 1 replies (of 1 total)
  • Plugin Contributor Frank Bueltge

    (@bueltge)

    11 years, 3 months ago

    The plugin don’t work with serialized data, use a default sql statement for search/replace. The first area to s/r give the chance to use it about all tables and fields, often usefull, but it is important, that the user know, what he does.

Viewing 1 replies (of 1 total)
  • The topic ‘Serialized Data Issue’ is closed to new replies.