WordPress.org

Support

Support » Plugins and Hacks » [Resolved] Serialized Data Issue

[Resolved] Serialized Data Issue

  • 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 Author Frank Bueltge
    Participant

    @bueltge

    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 ‘[Resolved] Serialized Data Issue’ is closed to new replies.