I just activated one of the projects for a client. After months of editing the moment was finally there. We have used the Builder to create the page layouts. There was no migration to a new server, it was just a case of changing the url’s in the database and setting the DNS right.
Afterwards, the pages build with the Beaver were empty. After a little search we saw that the content wat stil there (pfew). But the layout was gone. Alle content in the Page Builder was just stacking on top of each other with no columns or what so ever.
We did “save” one of the pages and the content was visible again, but the layout was as in the preview, just stacked with no columns.
Please, how can we fix this! We need to be online tommorrow (europe time).
Thanks for getting in touch and sorry to hear you’re having this kind of trouble. How did you change the URLs in the database? We recommend using this tool to do that since it handles serialized data. Have you tried clearing the BB cache as well? It’s found under Settings > Page Builder > Cache. One last thing, did you have a backup of the DB before doing the changes above?
Theme, plugins and the database of the development site are save.
Will try to reinstall on the develop location/url tommorrow.
Left it local on the iMac at the office…
Did not use the tool, just made a “find and replace” on the database.
I am no developer so this tools looks kinda hard for me to execute.
Cache delete didn’t work. Any other way to do the database job?
Did not use the tool, just made a “find and replace” on the database.
That is most likely what caused the issue. BB stores most of its data in a serialized format(as well as some other plugins, themes and WP itself). Doing a standard search and replace would corrupt it. You can try using the BackupBuddy plugin when transferring the DB over to the new site as it handles serialized data as well.
Additional remark: BackupBuddy in it’s new version 6 handles not only the serialized data best but is also able to manage sites on a staging server and live server. This is one of the greatest time savers I ever had (beside Beaver Builder). Staging Site is for development and customer review and Live Site is what it says.
Ok, guys, this is not working at all. PHP MyAdmin gives errors all over when i try to import.
Is there any other way you could help me? By adjusting the database the right way for example?
I have no knowledge of serious database things. The normal WP migration is what i can handle, when it gives errors, i’m lost…
What kind of errors are you getting when importing the new database? You’ll want to drop all the tables on your current DB(after taking a backup) before importing a new one.
When using the WP Migrate DB plugin, you’ll notice that there is a field for find and replace. Just place your staging/development URL under Find then place your live site URL under Replace. Check the screenshot for reference. http://imgur.com/5QCVx8I
Once you get the gzip file, you can import that to your live site DB. If it’s a blank DB, you can just import it directly. But if there’s content, you’ll need to drop those tables before importing the new one in.
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘?’ at line 1
I just tried using the WP Migrate DB(Lite Version) on my local and I was able to export/import just fine. I also checked the data inside the postmeta table and it handled the serialized data with no problems. Would it be fine if you could list down the steps you did when you used the said plugin? There might have been an error along the way.
