SEO Title, Meta description and Canonical URL is empty after website clone

  • Resolved irumsohale

    (@irumsohale)


    2 years, 3 months ago

    I have multiple country domains with the same content in different languages. I update content on a single website regularly and then clone other websites on monthly basis with main website sql dump. I run a set of SQL queries to change the domain name and other content where ever required.?

    These fields ‘SEO Title’, ‘Meta description’ and ‘Canonical URL’ in product_tags (Edit tag page) and product categories (Edit category page) are empty after the running update query.

    I have tried to export and import Yoast settings to other websites. Does Yoast SEO have any migration procedure? What I am missing here?
    Here are a few queries as examples.

    UPDATE wp_options
SET option_value = REPLACE(option_value, 'example.com', 'example.co.uk')
WHERE option_value LIKE '%example.com%'; 

UPDATE wp_yoast_seo_links
SET url = REPLACE(url, 'example.com', 'example.co.uk')
WHERE url LIKE '%example.com%'; 

UPDATE wp_yoast_prominent_words
SET stem = REPLACE(stem, 'example.com', 'example.co.uk')
WHERE stem LIKE '%example.com%'; 

UPDATE wp_yoast_indexable
SET permalink = REPLACE(permalink, 'example.com', 'example.co.uk')
WHERE permalink LIKE '%example.com%'; 

UPDATE wp_yoast_indexable
SET canonical = REPLACE(canonical, 'example.com', 'example.co.uk')
WHERE canonical LIKE '%example.com%';

    The page I need help with: [log in to see the link]

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

  • @irumsohale

    The SEO data should be transferred to the new site if you use the same database. Besides, there are multiple processes to import and export SEO data and settings, as discussed here and here.

    Likewise, using the?WP All Import?tutorial, you should be able to import your Yoast data. However, we recommend testing on a staging site first.

    Thread Starter irumsohale

    (@irumsohale)

    Thanks for getting back quickly.

    Yes, SEO data should be transferred but I think something triggers the “First-time configuration” and/or Yoast created database table got empty..

    After cloning the database, I use “Import and Export” in the Yoast tools section to import settings in the new website. but still, Yoast replaces SEO Title with the default value “%%term_title%% Yoast variable.

    I just removed all 7 Yoast tables and imported new tables with data (through phpMyAdmin). After Replace, data is fine but doesn’t show on Edit tag and product-tag page (example.co.uk/prod-tag/).

    I run “Optimise SEO Data” and then the table field description and title from Table wp_yoast_indexable are empty.

    Plugin Support Maybellyne

    (@maybellyne)

    Hello @irumsohale

    The Yoast SEO First-time configuration is triggered when you newly install the plugin or deactivate and reactivate it. This action shouldn’t empty the Yoast SEO database tables. Running the SEO data optimization analysis is to store the metadata for all your pages in a separate database table – the Indexables. By doing that, they fetch a page’s metadata in one simple database request instead of many individual requests. This enables them to “index” a site. They can translate what WordPress knows about the site to how search engines see it. Then, the Indexables serve all that rich information to search engines fast and bug-free! The result? Your pages load faster, and search engines understand your site better while wasting less electricity.

    If you’re still experiencing issues after cloning your sites, the technical support team would have to investigate this further as it could be something specific to your setup. You might want to consider Yoast SEO Premium for personal premium support so we can take a closer look at this.

    Thread Starter irumsohale

    (@irumsohale)

    Thanks for getting back.

    I understand what Yoast is doing. it’s a great functionality. I have used premium for a year but it’s not for me. I am not using most of the services in the free version even.

    • This reply was modified 2 years, 3 months ago by irumsohale. Reason: Removing credentials
    Plugin Support Maybellyne

    (@maybellyne)

    Hello @irumsohale

    Since this is a public forum, we can’t accept website credentials or provide in-depth technical support that involves taking a look at your set-up.

    Thanks for understanding.

    Thread Starter irumsohale

    (@irumsohale)

    That’s perfectly fine.

    can you please let me know the possible reasons which trigger these 2 points

    1. Why Yoast is removing the SEO data after site clone?
    2. Data is in DB table but not showing in Edit product-cat or product-tag page?

    Should I run SEO data optimization after clone?

    thanks in advance

    @irumsohale

    1. Why Yoast is removing the SEO data after site clone?

    Yoast SEO itself never removes the SEO data as it has no such features coded in it. It depends upon the circumstances, setup, and configurations between plugins, your theme within WordPress, and other things during migration. It’s difficult to list out and point them out without looking into the exact setup.

    2. Data is in DB table but not showing in Edit product-cat or product-tag page?

    Data is in database means that data is not lost. There could be other factors conflicting to fetch them and show on admin pages and front page.

    That said, indeed, we would suggest you to do (redo) the SEO Data Optimization (SEO >Tools).

    Try resetting our indexables in the database tables by following the steps below. Reset indexable won’t cause a lost of SEO data. It just help fresh reload them on the indexable table.

    1. Install & activate the?Yoast Test Helper plugin
    2. Go to Tools > Yoast Test
    3. Hit the “Reset indexables & migrations” button.
    4. Go to SEO > Tools, and under SEO data, click the “SEO Data Optimization” button to allow Yoast to rescan your pages.

    Thread Starter irumsohale

    (@irumsohale)

    hello

    SEO Data Optimization (SEO >Tools) will be done.

    I have tried it in fresh cpanel account with storefront and no other plugin but problem is there after update queries.

    let me try Reset indexables & migrations as you suggested On fresh install.

    Thanks

    Sure. Please update us how it goes!

    Thread Starter irumsohale

    (@irumsohale)

    I have disabled all the plugins except yoast and woocommerce with my customised storefront theme. Then I exported and imported Db, But it’s still removing the SEO data.

    I will try storefront default now.

    Hey @irumsohale,

    Thanks for the update. Do let us know how it goes with the default version.

    Plugin Support devnihil

    (@devnihil)

    This thread was marked resolved due to a lack of activity, but you’re always welcome to re-open the topic. Please read?this post?before?opening a new request.

Viewing 12 replies - 1 through 12 (of 12 total)
  • The topic ‘SEO Title, Meta description and Canonical URL is empty after website clone’ is closed to new replies.