This thread is resolved. Here is a description of the problem and solution.
Problem:
The issue here is that the user migrated their site manually but noticed that their views settings was lost.
Solution:
This is actually possible if the site it being migrated manually and all the links are not updated properly.
What you can do to avoid this is to use the duplicator plugin to perform your site migrations.
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 – 12:00 | 9:00 – 12:00 | 9:00 – 12:00 | 9:00 – 12:00 | 9:00 – 12:00 | - |
| - | 13:00 – 18:00 | 13:00 – 18:00 | 13:00 – 18:00 | 14:00 – 18:00 | 13:00 – 18:00 | - |
Supporter timezone: America/Jamaica (GMT-05:00)
This topic contains 8 replies, has 2 voices.
Last updated by Paul Marconi 5 years, 7 months ago.
Assisted by: Shane.
Hi,
I have Toolset Types & View plugins installed, and when I am trying to migrate a wordpress site to another host, I will upload the whole wordpress files & folders to the NEW server, then update the mysql database to the new URL strings by running some sql updates and replacement commands on the tables: wp_options, wp_posts, wp_postmeta.
This will get the site up on the new host, but in the Toolset Views, it always loses the selected post type for each view where some settings are gone too, keeping only the codes.
In the Toolset View list, I will get the message somewhat like below:
"any (missing post type) ordered by post date, descending, default items per page with manual pagination"
I have a screenshot attached.
Not sure is the problem with updating the database by running some SQL updates, but please find the SQL commands that I use to update the base url on the tables:
UPDATE wp_options SET option_value = replace(option_value, 'hidden link', 'hidden link') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET guid = replace(guid, 'hidden link','hidden link');
UPDATE wp_posts SET post_content = replace(post_content, 'hidden link', 'hidden link');
UPDATE wp_postmeta SET meta_value = replace(meta_value,'hidden link','hidden link');
I've tried using the Duplicator plugin to migrate the site, but it won't always work on some servers, so sometimes I have to do this manually.
Is there a way to update the base url in the database to the new URL without losing the Toolset View settings?
Thanks!
Hi Shane,
All of the Custom Post Types are still there with all of it's posts, the only issue is the Views. Every time I update the database by running some SQL updates (like I mentioned above), the Views are still there, but it loses it the selected post type and some settings are gone too, keeping only the codes, such as the image attached.
Thanks!
