Moving site / Changing domain name issue

  • Resolved Agent8

    (@agent8)


    8 years, 5 months ago

    Hi,
    I’m trying to move a website from a test domain name to a live domain name. I’ve performed the standard MySQL queries to update the URLs in the database and done some testing on the new domain but the URLs of content files added in tabs are still the old domain name.

    I’ve attempted to use a SQL command to edit the URLs in the wp_postmeta meta_value fields but as soon as I apply this the Tabs disappear from my site.

    I’ve got over a hundred instances of files uploaded to product tabs which I need to modify but don’t want to do it by hand.

    Can you help with this issue? This is the query I’m running:

    UPDATE wp_postmeta SET meta_value = replace(meta_value, ‘https://www.oldsite.co.uk’, ‘https://www.newsite.co.uk’);

    Many thanks,
    Nick.

Viewing 2 replies - 1 through 2 (of 2 total)

  • Same problem for me.

    Plugin Contributor yikesitskevin

    (@yikesitskevin)

    Hi @agent8,

    Unfortunately there are issues with migrating environments I’ve opened an issue on our GitHub repo for this problem, you can find that here. We will try to get that solved as soon as possible.

    To be honest, I am not sure why updating the database is causing the data to be lost. The only way I can see that happening is if the serialized array is somehow being broken (missed semi-colon, for example) and the application then fails to read it. But doing a simple MySQL replace should not create that issue. I am looking into it and will respond if I can find something.

    I’m sorry that I do not have solutions for you.

    Kevin.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Moving site / Changing domain name issue’ is closed to new replies.