Replacing URL’s (in DB) when content in widget

  • Resolved Neotropic2023

    (@neotropic2023)


    7 years, 3 months ago

    Does not replace the URL’s. So this is not the first time. Maybe not even the last. But I have had to switch a few sites over to https from http. I noticed one consistent issue. They are changed in the database (all instances), but not when I go to edit the content in the browser in wp-admin. In fact, it never matches up. I actually have to manually change the URL’s in the content. Even though I see they are changed in the actual post_content when viewing the SQL ‘_posts’ table. Why may I ask? Does not happen when I am not using this plugin. Using velvet blues on top of manual queries.

    At first I thought it as cache (front end), until I went to edit the page and noticed that going on. How come your plugin is not pulling what is in the database? Where else is it, can it pull this content from? Why do they simply not match up? Not a matter of ‘looking’ at the right one either. Not the first time this has happened.

    Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor alexgso

    (@alexgso)

    7 years, 3 months ago

    Hi neotropic2023,

    Page Builder acts like the standard WordPress editor in that it’ll reference the direct URL of certain images. With that said, we don’t store the complete Page Builder data in wp_posts and instead store it in a post meta called panels_data – the post content is merely a basic form for fall back reasons.

    To clarify, which widgets specifically didn’t update after running Velvet Blues? I ask because I actively recommend that tool for doing this so it should be working without issue. Also, what were you searching for and what did you replace it with?

    Thread Starter Neotropic2023

    (@neotropic2023)

    7 years, 3 months ago

    Ya, after thinking about it I feel it is something else. It will do it anyways, no matter what editor it is.

    It is strange, I run Velvet Blues and my own. See URL’s changed in SQL. But when I go to edit the page… images are still http and not https! It only happens with images. Code I use is basically the same as Velvet Blues. Plus done this many times with or without that plugin.

    I use this as they do not have it in theirs:

    UPDATE wp_options SET option_value = replace(option_value, ‘http://oldurl.com’, ‘https://newurl.com’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’;

    UPDATE wp_options SET option_value = replace(option_value, ‘http://oldurl.com’, ‘https://newurl.com’);

    In any case, really only need to use the second. Just in case.

    It changes it on all. Drafts, revisions ect… Just strange to see it not change when I go into the editor. Mind boggling. Not really all that bad. But when you have a client with 40 testimonials with images, each in their own block. Bah, daunting.

    I will continue looking. This is not the problem, this plugin.

    Plugin Contributor alexgso

    (@alexgso)

    7 years, 3 months ago

    Hi neotropic2023,

    Would it be possible for you to link me to one of the pages that didn’t update so I can inspect the results? Also, if possible, could you send me an export of the page that you link me to? To do this please open up the linked page in the editor and click the Layout button in the Page Builder toolbar. Then click import/export and then click download. Please upload the export to a 3rd party file hosting site such as teknik.io.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Replacing URL’s (in DB) when content in widget’ is closed to new replies.