SQL changes not reflected on site

  • wpress2010

    (@wpress2010)


    10 years, 6 months ago

    Have to do a global search/replace on strings in SQL to eliminate incorrectly encoded punctuation after someone moved client’s site to new server.

    Made a few manual edits in posts via MySQLadmin to verify proper replacements, saved, loaded site, changes not seen! Cleared browser cache, tried again. Changes still not seen!

    No cache plugins in use. I’m obviously missing something here.

    TIA!

Viewing 4 replies - 1 through 4 (of 4 total)
  • Moderator t-p

    (@t-p)

    10 years, 6 months ago

    Try Clearing cache.
    If using any cache plugins, try deactivating them.

    Thread Starter wpress2010

    (@wpress2010)

    10 years, 6 months ago

    No cache plug that I can find.

    I went into the WP dashboard, went to Posts, found the Post I was trying to edit in SQL, edited it via the Dashboard Edit button, and immediately saw my changes when I viewed the site.

    But when I tried the same thing in myPHPadmin, and the UPDATE reported success, the changes were NOT seen on the site, even after a browser cache clear and logging off the site, logging back on.

    Moderator t-p

    (@t-p)

    10 years, 6 months ago

    But when I tried the same thing in myPHPadmin, and the UPDATE reported success, the changes were NOT seen on the site

    You may want to contact your webhosting and ask them

    WPWhiteSecurity

    (@wpwhitesecurity)

    10 years, 6 months ago

    Hi,

    The issue is definitely related to caching. Your hosting provider could be doing it (as Tara is suggesting) and sometimes even ISPs do it.

    Did you try to access the same website from a different location / server? If all works fine, then your ISP is caching the website.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘SQL changes not reflected on site’ is closed to new replies.