- This topic has 3 replies, 2 voices, and was last updated 7 years, 9 months ago by
Anh Tran.
-
AuthorPosts
-
January 12, 2017 at 8:06 PM #4783
MarketPress
ParticipantHello guys!
I love the plugin and all the extensions so far. I have only one issue with the saved data in wp_postmeta. I would like to know if there is a way to automatically replace an url (for example) in this table. If i change any character of cloneable field inside the database table, the fields are empty in the backend after. My general workflow is to export the database and import it at the new system. Before importing i have to change the URL of the development system to the final URL. But after replacing the URLs, all the cloneable fields are empty in the backend. Is there a workaround for that behavior? For now i have to replace all URLs in the backend fields by hand.January 14, 2017 at 6:14 PM #4795Anh Tran
KeymasterHi, the job of search and replace URL in the database is very common while migrating a WordPress site. You can do that in many ways in general, not specific for Meta Box by using:
WordPress search and replace tool: this tool is one of the best tool to do this job with GUI
WP-CLI
search-replacecommand provides a same way to do that with command line. If you’re using Windows, you might want to follow this tutorial to install WP-CLI on Windows.Both tools allow you search and replace a string in the whole database or in a specific table (wp_postmeta).
January 17, 2017 at 5:53 PM #4827ParticipantHi! Thanks for your reply. The search and replace process is working well, but if any character is changed in the table field of a cloneable field, the field is empty in the WordPress backend. So it seems like that the connection gets lost if there is a change in the table field. The content of the fields in the backend is returning if i undo my change in the database table field. How exactly is the connection between the table field and the backend field working? Thanks for your Help!
January 19, 2017 at 9:36 AM #4846KeymasterHi,
If you change only the post meta value, then nothing happens. Please try search and replacing only on the column
meta_valuein the tablewp_postmeta. -
AuthorPosts
- You must be logged in to reply to this topic.