Database query not updating with new data

  • linx8

    (@linx8)


    9 years, 1 month ago

    Hello,
    w3 Total cache crashed my website and I had to uninstall it. It took a long time but I followed instructions from here: Link

    However, now the website doesn’t seem to be updating properly. We have a donations system in place, and the query from the database doesn’t retrieve new donations. I have been getting around this by activating a different theme, and switching it back, which seems to update the database/query/cache.

    Anyone got any ideas? I’ve already tried removing all traces of cacheing, so not sure why the database query is being cached, or if it is something else?

    website: steernorth.org.au

    • This topic was modified 9 years, 1 month ago by linx8.
Viewing 5 replies - 1 through 5 (of 5 total)
  • Prince_Dhaval

    (@shethdhaval)

    9 years, 1 month ago

    still cache is enabled on your website
    then you have to turn off the database cache
    and which version of w3tc you used?

    Thread Starter linx8

    (@linx8)

    9 years, 1 month ago

    @shethdhaval
    I was using the latest at the time. I assume it was 0.9.5.*
    I’ve checked my .htaccess, wp-config, files and folders and removed all traces of caching. Is there an option in the database that w3 total cache changes? Could WPEngine also be doing some caching?

    More info: We have a custom post type and we save data into the database table wp_postmeta. We then query wp_postmeta to get the total value.

    Prince_Dhaval

    (@shethdhaval)

    9 years, 1 month ago

    If your hosting is wp engine then they are running their own cache management system but can you please let me know where you are going to add data that is not saved.
    In the latest version of cache they store something on database as well they clearly mentioned in change log
    Thanks

    Thread Starter linx8

    (@linx8)

    9 years, 1 month ago

    Thanks for the reply @shethdhaval,
    My hosting is Managed WordPress hosting with GoDaddy, not sure if they use WP Engine? I can see that I have a ‘Must Use’ WP Engine plugin which does some caching. Is there any way I can turn it off? Can I just remove the plugin from mu-plugins?

    Not sure what you mean by your question. I am saving data to the WP database, and it is working correctly. However querying shows old cached data. I work around this by switching themes which forces the cache to refresh. Simply clearing browser cache doesn’t do it.

    Prince_Dhaval

    (@shethdhaval)

    9 years, 1 month ago

    Hello,
    i don’t understand your concern
    see whatever the changed you made from the backend side it would be stored in database
    everytime you have to flush your cache to get the proper content

    please explain more about your concern if you not getting my point

    thanks

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

The topic ‘Database query not updating with new data’ is closed to new replies.