Docs

[Chris Stovall]

Okay this is a new one for me. I recently moved this site from a beta/dev server back to the live server.

This is the page in question. When I inspect the icon, you can see that it it most definitely linked to the live server and it is displaying properly. No question. See the image below.

http://grabthegold.com/ingredients/

Now, when I edit the same page in Cornerstone, the image is missing and it is linked to a server that’s no longer even running. It’s been shut down. How and or why would it be using two sets of data? How do I know what to trust if it’s not even showing what is being displayed on the site?

Same page, same info, different data from the backend to the front end. How do I prevent or correct this?

Sending login info below. Please TREAD LIGHTLY. This is a busy corporate site.

[Chris Stovall]

This reply has been marked as private.

[Christian]

Hey Chris,

This looks like your site has not been migrated properly. Please see https://community.theme.co/kb/cornerstone-migration/ for proper site migration.

Cornerstone uses post meta data (separate from content) for the page builder. What happens when you save is the data is both saved in post meta (what Cornerstone uses) and text content (responsible for front-end display). In your case now, your post meta data is still from your old dev server so if you save in Cornerstone, your page might appear broken. Please follow the proper migration process.

Thanks.

[Chris Stovall]

The migration process that was followed, and what I’ve been using for years is this.

http://codex.wordpress.org/Moving_WordPress

It’s even listed in your post above.

Can you please tell me which tables in the DB are safe to run the script to change the data are? I’ve only done it in the posts data. If you could give me that data, I think I’d be in better shape.

[Rue Nel]

Hello Chris,

Thanks for the updates. It looks like you are using the manual migration process. To resolve this issue in your site, I would suggest that you install a 3rd party plugin Search and Replace. You can simply search for the url of your dev server and replace it with the new live server. This is the easiest way you can resolve this.

Please let us know how it goes.

[Chris Stovall]

I have done that. I use this script. The same one I’ve been using for years.

https://interconnectit.com/products/search-and-replace-for-wordpress-databases/

Currently I’m only updating the “posts” table. This still results in the same problem I’ve detailed above. So can you please tell me what tables need to have the script run on them? That’s the question that was asked above as well.

Pre-cornerstone this has not been an issue. In the posts table, the script HAS been run to replace the URL. This still results the cornerstone data being out of sync from the front end to the back end. Seems like there needs to be some more information in order to make this work. In previous versions of Cornerstone, this has NOT been an issue. Please detail the steps needed to perform a manual move as I’m sure I not the only DEV that uses this method. This is THE method that most professional wordpress designers use after all.

Please help and thank you!

[Paul R]

Hi Chris,

I would recommend moving your site as a whole instead of manually updating db.

Try to use this third party plugin instead. I have tested this on my test sites and didn’t find any issue.

Duplicator – Backups & Migration Plugin – Cloud Backups, Scheduled Backups, & More

Hope that helps

[Chris Stovall]

I get that. But I need to know what DB tables to update. Can I update them all?

A lot of times I need to move sites all over the place, restore versions to a beta site, etc. I often don’t even know what the URL is going to be or have an active version of WP to move it into.

Currently I’m restoring a site from Jan. It’s not running on a server and I have to move it to one. Since it’s not live, I can’t use the plugin as you’ve stated.

There really needs to be some input on this. I know more people than just me are having this issue.

[Jack]

Hi there Chris,

Thanks for your reply, personally I move sites the same as you, manually.

Cornerstone stores it’s data in the post meta table, if you run the find and replace on post_meta and on the posts table, replacing the old domain with the new, Cornerstone should correctly reference the new site.

Or have you tried updating wp_post_meta and it still wasn’t correct? I see in your above screenshot, that just wp_posts seems to be highlighted.

If that is the case that (where post_meta has been updated and it still isn’t working), that definitely isn’t right and is something we can look into/debug for you.

Thank you!

[Chris Stovall]

Thanks. I’ll do it on a testing server today and report back. I had a cornerstone site goes down 2x after having another coder move the DB around. It stripped out the cornerstone data and completely broke my ability to use cornerstone on any pages. The cornerstone data was gone, and the site had to be rebuilt. Twice. It took a total of 50 hours between the 2 instances. You can see why I might be a little gun shy.

I’ll let you know how it goes.

[Christian]

Thanks. Let us know.

[Chris Stovall]

I’m super happy to report that letting the script fly on all fields DID NOT DAMAGE the database or the Cornerstone data. It worked great.

[Christopher]

Glad to hear that it didn’t cause any issues.

[Chris Stovall]

I spoke too soon. The pages that had the ® on them broke. I even used the HTML tag for the ® but it didn’t help. The theme converted the HMTL to the actual ® on page and in the DB. Once I ran the script, those pages were toast. The cornerstone data was present on the page but I could not edit the page. I had to rebuilt it. I have the files and DB of you guys would like to look at them.

I’ve now removed all ® from the site. I think this will fix it.

[Rad]

Hi there,

Thanks for sharing, I’ll check that too could be related to html_entity_decode().

Thanks.

[Author]

Posts