Options value missing after migration

  • resting

    (@resting)


    9 years, 8 months ago

    Options values are missing after migrating from Site A to site B.
    Here’s what I did:
    After exporting the entire DB, I replaced URL and Dir path of Site A with Site B.
    Then i import everything.
    All’s good except that values in Options framework is missing.
    Where is the DB value stored and how can I migrate it?
    Thanks.

    https://wordpress.org/plugins/options-framework/

Viewing 1 replies (of 1 total)
  • Thread Starter resting

    (@resting)

    9 years, 8 months ago

    Ok found this: https://wordpress.org/support/topic/theme-delicate-theme-options-lost-when-moving-to-new-domain?replies=19#post-2654903

    I have seen a lot of people fall in this trap. I am not familiar with this theme at all, but my guess is that it uses the WP Settings API to store options in an array in the DB. Ordinarily the options would get stored thus:
    name => value

    So, you would get something like:
    ‘background_image’ => ‘http://path.to/old/url’

    But using the WP API if you save the options, the options get encoded. So you get something like this:
    type:length:value

    Note that apart from the value, you have the length that is stored. So, your background_image option above also gets the number 22 assigned for the length (the path is 22 characters long).

    When you are doing a find/replace via the DB, you are basically changing the URL to ‘http://new-path.to/old/new-url’, which is 30 characters long, but your option still says “22”. This corrupts your options array.

    Fixing the s: length worked.

Viewing 1 replies (of 1 total)

The topic ‘Options value missing after migration’ is closed to new replies.