After updating database prefix

  • Resolved formanite22

    (@formanite22)


    9 months, 2 weeks ago

    Hi,
    I have successfully updated the database prefix manually. After updating, could successfully login to cpanel, admin and other authors account. The site seemed to be working as expected.
    However, after updating, I came across cache issues on my website. I rechecked the wp_options table to verify that all entries starting with wp_ prefix are updated (20 entries). While I was going through, I could see a couple of duplicated entries (now a total of 22 entries) that show the previous prefix (wp_force_deactivated_plugins and wp_cloudflare_page_cache_install). These two entries are also available with the new updated prefix.
    Few days ago, I noticed the cache issue on my website. Though after updating the database prefix, I cleared the Cloudflare cache too. Some changes that I made especially in the sidebars and in the Customizer tool are not visible at once, when viewing my website on different browser/devices. However, the changes made are visible when I’m logged into my admin account.
    So, it seems the issue is related to the duplicated “wp_cloudflare_page_cache_install” entry. The cache was working correctly before updating the database prefix.
    So if I restore back using the backup that I made using UpdraftPlus before updating the prefix. Will I be able to fully restore my website and could resolve this wp_options table entries issue?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Contributor bcrodua

    (@bcrodua)

    Hi,

    I would suggest you optimize your database so it will delete old/unused tables. This would also help speed up your site.

    If that does not resolve the issue, yes you can use the backup to restore site to the previous point or when the backup was created.

    Best Wishes,
    Bryle

    Thread Starter formanite22

    (@formanite22)

    Hi @bcrodua,
    Thanks for your response.
    I optimized the database using the WP_Optimize plugin. However, I still the duplicate entries.
    Till now I never required to restore my website. So, I’m not 100% sure how to restore it. I was reading this article (https://updraftplus.com/faqs/restore-site-updraftplus/).
    Is the correct way to restore the website? Restoring should resolve this database issue right?

    Plugin Support vupdraft

    (@vupdraft)

    It would restore you options to the table to how it was before you made the change.

    What you are describing sounds like a caching issue so I don’t think doing a restore is going to fix your issue

    Are you using a caching plugin, if so can you purge the cache.

    Can you also clear your browser history if using chrome

    Thread Starter formanite22

    (@formanite22)

    Yes, I’m using Cloudflare caching.
    I cleared the browser history, and purged the Cloudflare cache too.
    However, the caching issue is still there.

    Plugin Support vupdraft

    (@vupdraft)

    I would contact Cloudflare support if you continue to get issues

    The reason you are seeing changes when logged in as admin user is because you do not have caching for logged in uses enabled (which is correct).

    Are you purging the cache after making a change (you should be to see the changes)?

    I don’t think this support channel is the best place for getting advice on this.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘After updating database prefix’ is closed to new replies.