Skip Navigation

[Closed] 'Better Search Replace' plugin could not replace all the required Posts…

This support ticket is created 4 years, 9 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun Mon Tue Wed Thu Fri Sat
- 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 -
- 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 -

Supporter timezone: Asia/Hong_Kong (GMT+08:00)

Tagged: 

This topic contains 6 replies, has 2 voices.

Last updated by Luo Yang 4 years, 8 months ago.

Assisted by: Luo Yang.

Author
Posts
#1730123

DL

Hi,

Thank you for 'Gyms and Trainers' directory site template.

Unfortunately, 'Better Search Replace' plugin could not replace all the required Posts, Fields, Taxonomies & Taxonomy terms.

The following are 'Search/Replace' details:

- Gyms > Electricians

During the search/replace, 73 tables were searched, with 105 cells changed in 105 updates.
Click here for more details.
Search/Replace Details
Table Changes Found Rows Updated Time
wp_ke_options 9 9 0.033 seconds
wp_ke_postmeta 33 33 0.17 seconds
wp_ke_posts 61 61 0.098 seconds
wp_ke_toolset_relationships 1 1 0.002 seconds

- Gym > Electrician

During the search/replace, 73 tables were searched, with 49 cells changed in 47 updates.
Click here for more details.
Search/Replace Details
Table Changes Found Rows Updated Time
wp_ke_options 7 7 0.032 seconds
wp_ke_postmeta 22 22 0.144 seconds
wp_ke_posts 19 17 0.06 seconds
wp_ke_toolset_relationships 1 1 0.002 seconds

- Personal Trainers > Services

During the search/replace, 73 tables were searched, with 46 cells changed in 46 updates.
Click here for more details.
Search/Replace Details
Table Changes Found Rows Updated Time
wp_ke_options 4 4 0.031 seconds
wp_ke_postmeta 6 6 0.054 seconds
wp_ke_posts 34 34 0.084 seconds
wp_ke_toolset_relationships 2 2 0.006 seconds

- Personal Trainer > Service

During the search/replace, 73 tables were searched, with 64 cells changed in 64 updates.
Click here for more details.
Search/Replace Details
Table Changes Found Rows Updated Time
wp_ke_options 1 1 0.017 seconds
wp_ke_postmeta 3 3 0.053 seconds
wp_ke_posts 6 6 0.034 seconds
wp_ke_toolset_relationships 2 2 0.025 seconds

- Sessions > News

During the search/replace, 73 tables were searched, with 61 cells changed in 59 updates.
Click here for more details.
Search/Replace Details
Table Changes Found Rows Updated Time
wp_ke_options 3 3 0.019 seconds
wp_ke_postmeta 47 47 0.183 seconds
wp_ke_posts 10 8 0.042 seconds
wp_ke_toolset_relationships 1 1 0.002 seconds

- Session > News

During the search/replace, 73 tables were searched, with 14 cells changed in 14 updates.
Click here for more details.
Search/Replace Details
Table Changes Found Rows Updated Time
wp_ke_options 4 4 0.023 seconds
wp_ke_postmeta 5 5 0.049 seconds
wp_ke_posts 4 4 0.025 seconds
wp_ke_toolset_relationships 1 1 0.002 seconds

The following are links to:

'Better Search Replace' plugin
https://wordpress.org/plugins/better-search-replace/

'Development' site
hidden link
username: rgkvsrgvlaehtvlhgvlhglaegh
password: greeting.reprint.shorthand

Your assistance in finding working solution for the above 'Search/Replace' issue would be greatly appreciated.

Thanks,
DL

#1730325

Hello,

I assume you are going to find and replace all custom post types setting as below:
- Gyms > Electricians
- Personal Trainers > Services
...

Toolset Types plugin stores custom post type setting as serialized array value in database, you can not use other simple SQL tools "Better Search Replace" plugin to replace them, it will conduct other unexpected reuslt.

In your case, I suggest you try these:
1) Dashboard-> Toolset-> Post Types, find and edit those specific post types, in section, there you can change the post type name to what you want.

2) Then use "Better Search Replace" plugin to find and replace the normal text.

#1734153

DL

Hi Luo,

Thank you for your response.

Unfortunately, the suggested solution could not replace all the required Posts, Fields, Taxonomies & Taxonomy terms.

In addition, the Posts are not accessible for editing after the suggested solution.

Your assistance in finding working solution for the above 'Search/Replace' issue would be greatly appreciated.

Thanks,
DL

#1734207

Unfortunately, according to our support policy, we can not provide support for other plugins.
https://toolset.com/toolset-support-policy/

However, you can provide a copy of your website in below private message box, provide detail steps to duplicate the same problem, I need to test it in my localhost, then I can escalate this issue if it is a compatibility problem.
https://toolset.com/faq/provide-supporters-copy-site/

For the problem: the Posts are not accessible for editing after the suggested solution.

I assume you have changed the post type slug too, you can run a simple SQL query to update post type slug setting of each post easily, for example:
hidden link

#1735667

DL

Hi Luo,

Thank you for your response.

The site is restored from the last backup and the Posts are now accessible for editing.

Thanks,
DL

#1735669

DL

Thank you,
DL

#1735671

Great, feel free to create new ticket if there is other new questions. thanks

The topic ‘[Closed] 'Better Search Replace' plugin could not replace all the required Posts…’ is closed to new replies.