New to the community? Start here

Direct edits in the database do not directly show up in the front end

I’ve noticed several times now that when I make direct edits through phpMyAdmin (e.g. a search and replace), those edits do not show up in the front end (or in admin screens) until I open the post editor for that specific post. I don’t even have to save the post; just opening up the editor is enough for my database edits to become visible.

I suspect it’s a caching issue, but I’m not sure. I’m running Hummingbird on my site, but haven’t touched any settings at all yet (everything should still be in its default state).

Any thoughts on how to fix this?

Tue, 9 Mar 2021 0:10:33
  • Nithin Ramdas
    • Support Wizard

    Hi Kevin ,

    If you haven’t cleared Object Cache the changes in the database will not reflect instantly. You should see the option to clear “Object Cache” in the Hub for your specific site under the “Hosting > Tools” tab:

    [attachments are only viewable by logged-in members]

    Please do let us know if you have any further query. Have a nice day ahead.

    Kind Regards,
    Nithin

      • PTaubman
        • I'm just a Cook

        It is probably a good idea depending on what you are modifying directly into the database. Think of it this way…

        Before I leave to go to the market to buy the groceries for the week, I take a picture of the shopping list that my wife and I make throughout the week. I bring this picture with me to the store and I start to go shopping and put all the items in the cart. Since my wife hates to shop, I go by myself.

        While I am shopping, looking at my list, and selecting the brand I want, my wife is at home and remembers that she want Orange Juice. She adds it to the list. She sees it on her list (In the database) but I don’t see it on my list (the cached version). I would need for her to send me the new list so I can see things (empty the cache – i.e., my old list – and get the new list from her – i.e., read the database again).

        A silly example, but I hope it helps.

        Paul.

        • Kevin
          • Design Lord, Child of Thor

          Thanks for the analogy, it’s a pretty good one actually :smiley:.

          It is probably a good idea depending on what you are modifying directly into the database.

          I probably should’ve specified that I generally only edit (custom) post content that should be visible in the front end. So if I understand correctly, I should always clear the cache after doing so (please correct me if I’m wrong).

          I’m marking this issue as resolved. Thanks again guys!