Updates made to the database are not displayed on the pages

  • Resolved kevinselectos

    (@kevinselectos)


    5 years, 5 months ago

    Hi !

    I updated the {prefix} _postmeta table to replace “2020” with “2021” in each title with this query:

    UPDATE {prefix} _postmeta SET meta_value = REPLACE (meta_value, 2020, 2021) WHERE meta_key LIKE _yoast_wpseo_title

    I can see the new titles in the database and at the bottom of the post editor.

    But on the pages, it still shows 2020.

    This only changes if I click Update in the post editor.

Viewing 8 replies - 1 through 8 (of 8 total)
  • devnihil

    (@devnihil)

    5 years, 5 months ago

    @kevinselectos We’re sorry to hear that you are experiencing this issue. If you are seeing the changes updated on the edit screen of the page, but not on the page unless you publish it, it may be related to the page’s caching.

    If you clear your cache (server, plugin, theme, or CDN such as Cloudflare) does this resolve the issue? If you are not sure how to clear your server cache you should speak with your host provider.

    Thread Starter kevinselectos

    (@kevinselectos)

    5 years, 4 months ago

    Hi devnihil,

    I spoke with our host support, cleaned the cache and the problem was still the same.

    In addition, the problem also appears on the Staging version of our site and the cache is not activated on the Staging.

    Then I tried disabling all plugins except YOAST and enabling the default theme twenty-twenty. The problem is still there.

    You can see an example here:
    https://staging-selectos.kinsta.cloud/meilleures-lampes-de-lecture/

    If I look in the edit page of this article, the meta title field is set to “%% title %% %% page %% 2021 [Comparatif] – Selectos”. But on the page, it’s always “%% title %% %% page %% 2020 [Comparatif] – Selectos”

    • This reply was modified 5 years, 4 months ago by kevinselectos.
    Thread Starter kevinselectos

    (@kevinselectos)

    5 years, 4 months ago

    @devnihil Maybe it’s better if I tag you, sorry I forgot.

    Rumejan

    (@onlyincebu)

    5 years, 4 months ago

    Hello!

    Can you please reset the indexable migrations & tables? Please follow these steps:
    1. Install & activate the Yoast Test Helper plugin: https://wordpress.org/plugins/yoast-test-helper/
    2. Go to Tools -> Yoast Test
    3. Locate the Yoast SEO section and select the “Reset indexables tables & migrations” button
    4. Click the “SEO Data” button in the SEO->Tools section.

    Let us know the result.

    Thread Starter kevinselectos

    (@kevinselectos)

    5 years, 4 months ago

    Hi @onlyincebu

    I did everything up to the 3rd step, it works and all the pages have the correct title.

    But I’m not sure I understand the last step, are you talking about the “Start SEO Data Optimization” button ?

    Thank you for your help.

    Thread Starter kevinselectos

    (@kevinselectos)

    5 years, 4 months ago

    And one last thing, can I do it directly on the live version of our site? Is there a risk of breaking our site (obviously I’ll do a backup first) ?

    Suwash Kunwar

    (@suascat_wp)

    5 years, 4 months ago

    @kevinselectos

    Yes, we mean the “Start SEO Data Optimization” button on your live site. It would not break your site. However, for the health and safety of your site, we recommend creating regular backups of your site and database.

    devnihil

    (@devnihil)

    5 years, 4 months ago

    We are going ahead and marking this issue as resolved due to inactivity. If you require any further assistance please create a new issue.

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

The topic ‘Updates made to the database are not displayed on the pages’ is closed to new replies.

Tags