Home>Support>Update Page Builder content to https

Update Page Builder content to https

Notice: This thread is over two years old; the information may be outdated. Please consider creating a new thread if you require free support. If you have an active SiteOrigin Premium license, you can email our premium support desk at [email protected].

Hi,

I’ve to update a http site to https. The site has a lot of content, all build with page builder.
Because of the amount of content I have to do this via MySQL-Statements direktly in the database.
If I do the following statement:
UPDATE wp_posts
SET post_content = REPLACE(
post_content,
“http://www”,
“https://www”
);
all the content will be changed, but not the content set with the page builder.
To change the page builder content I do the following statement:
UPDATE wp_postmeta
SET meta_value = REPLACE(
meta_value,
‘src=”https://www’,
‘src=”http://www’
);
After doing this, all the content including image links will be fine and everything runs on https.
But the page builder is no longer there. All the content is now natural wordpress content without page builder anywhere.
Which destroys all content settings and alignments.

After recognizing this effect I tested it on several websites with different versions of page builder and wordpress. I changed the database manually and not via statement, but everytime and everywhere I do changes in the wp_postmeta, page builder will stop work.

If I set back the changes page builder will start work again, changing the image links in the editor in the wordpress backend will work too. But this is for my actuall project much to much work.

Is there any way to change all the page builder content via sql-statement in the database?

Thank You very much,
Stephan Bonkowski

This is our free support forum. Replies can take several days. If you need fast email support, please purchase a SiteOrigin Premium license.

  1. 7 years, 4 months ago Alex S
    Hi, I Work Here

    Hi Stephan,

    Page Builder data is stored in a serialized form. This means that the SQL used and the manual edits will break the data. Please undo the changes you made via manual edits and via the SQL and then use Velvet Blues Update URLs to correctly update the URLs to no longer reference the HTTP version.

Replies on this thread are closed. Please create a new thread if you have a question, or purchase a SiteOrigin Premium license if you need one-on-one email support.

Get The Most Out of SiteOrigin with SiteOrigin Premium

Find Out More