What does the s in this wp_options | active_plugins stand for?

  • mrgreggles

    (@mrgreggles)


    15 years, 4 months ago

    Hi,

    Just wondering: Under wp_options there’s a row called active_plugins, an example of which is:

    i:10;s:20:”download-counter.php”;

    I’d really like to know what the ‘s’ stands for, and if possible how it’s generated. The ‘i’ number is clearly sequential.

    Thanks in advance!

    Mr Muttly

Viewing 3 replies - 1 through 3 (of 3 total)
  • robinmarshall

    (@robinmarshall)

    15 years, 3 months ago

    Hi Mr Muttly,

    It’s the number of characters in the string, i.e. download-counter.php is 20 characters long.

    I am battling with this at the moment, trying to script a way to move the wp_options table to a new server.

    If you have any ideas on how to manage this, let me know!

    Cheers,
    Robin

    figaro

    (@figaro)

    15 years, 3 months ago

    I am battling with this at the moment, trying to script a way to move the wp_options table to a new server.

    Can’t you just export (dump) the table and import it on the new server?

    robinmarshall

    (@robinmarshall)

    15 years, 3 months ago

    The problem is all the URL’s are wrong. I have to manually update them in the options table then update the number next to the option value. This can take 30 minutes on a medium sized site.

    For example if the option is i:10;s:17:”http://google.com”; I need to change it to i:10;s:18:”http://nytimes.com”;

    I wrote a script to do the translation using regular expressions, but the problem is still that there are some cases where the serialization is nested in other serialized options, making it really hard to correctly match and replace.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘What does the s in this wp_options | active_plugins stand for?’ is closed to new replies.