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
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.