Bug while migrating a large website from Yoast

  • Resolved boustalahit

    (@boustalahit)


    6 years, 6 months ago

    Hello,
    I’m currently working on migrating a website from Yoast to Seopress. This website is part of a site network and it has a large number of pages (more that 30000) that are stored as custom post types and that has custom meta registered for each.
    When I click on “migrate now” in seopress tools, it’s almost instant so I checked what it did : the articles are ok, but pages and custom post types are not migrated correctly. The google preview send the good title and description but all fields (“title”,”meta description” and “meta keyword”) are empty ! And if I check for the page code that is in frontend, the meta are empty as well so it get the content instead of meta description. It’s frustrating because it seems to work, but it’s not :'(
    Is there some limitation that generate this error ? What is the migration doing in database ? Is there something that I could do directly in sql maybe to fix this ? I’m working on a pre-production server so we could test some things if needed.

    Thanks a lot for your time
    Nicolas

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter boustalahit

    (@boustalahit)

    After some investigations, the migration script stops after 1600 writes (exactly) in the database. And for some reason the Google preview detects the yoast meta datas and show them in the backend. So in the backend, it feels like the script have done all of the job, but no, it only has done a part of it. A ugly trick would be to change the meta_key value of _yoast_wpseo_metadesc and _yoast_wpseo_title to _seopress_titles_desc and _seopress_titles_title directly in the database (tested on 1 entry, it seems to work). Before doing this, I’d like maybe some input on what is going on with the script. Maybe it’s also a server limit, I don’t know. Can you help me ? Thanks

    • This reply was modified 6 years, 6 months ago by boustalahit.
    Plugin Author Benjamin Denis

    (@rainbowgeek)

    It works without any limit (batch 200).
    The 1600 seconds are probably those of your server.
    The script just makes an update_post_meta by changing the name of each meta by the new ones.
    So yes, you can do it via MySQL.
    Disable Yoast when using SEOPress, otherwise, you will have conflicts between the two.

    Thread Starter boustalahit

    (@boustalahit)

    Ok, thanks a lot, I’ll do that. Have a good day ??

    Thread Starter boustalahit

    (@boustalahit)

    So I made it by hand in sql, it works fine now.

    Plugin Author Benjamin Denis

    (@rainbowgeek)

    Cool!
    I mark the topic solved.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Bug while migrating a large website from Yoast’ is closed to new replies.