Earlier I put the upgrade on hold, but now I am planning to upgrade again. As expected the issue persists when I update the plugin and then upgrade the DB as notified by the plugin.
The plugin renames the old 'wp_toolset_associations table' to 'wp_toolset_associations_old' and creates a new table instead. I think the issue is occurring because the row ids are reset.
Let's take an example of author relation: Author relates to Articles CPT with many to many relationship.
In old screenshot you can see the ids are reset (as expected from a new table) but you will also notice the the parent id (author) was 9177 and its child (article) was 10240 earlier which is now changed to 1 and 2 now.
The author with ID 9177 still present in the article CPT but I double checked and 9177 is not present in the associations table now.
Hello. Thank you for contacting the Toolset support.
It should not create any issues.
Before doing any migration I suggest that you should take full backup of your database and website so in any worst case you will have a complete backup with you and you can restore it.
I suggest you should try to follow the following steps:
- Take full backup of your database and website
- Update Toolset plugins
- check all relationships are correct if yes:
- Edit few posts and which are involved in post relationship and check all related posts are displayed with post-relationship box
If you see all related posts are displayed then everything should be find and you are ready to go.
Can you please share information where I can find it not working and setup a staging site for me where I can review all those issues.
*** Please make a FULL BACKUP of your database and website.***
I would also eventually need to request temporary access (WP-Admin and FTP) to your site. Preferably to a test site where the problem has been replicated if possible in order to be of better help and check if some configurations might need to be changed.
I have set the next reply to private which means only you and I have access to it.
Can you please confirm where should I perform the search - do you mean I've to use the default WordPress search? or you have created custom search view? If yes, can you please share problem URL where you added that custom search view?
I search for the "Ayu Sutriasa" key word after updating the Toolset plugins on your install to latest version. I see the first page loaded after search has same entry as the live site:
> hidden link
While activating the Types plugin after updating it I see there is some database related error. There is a great chance that there will be no permission to update the database. Can you please make sure that on your database server there is enough permissions granted so that when such script or plugin try to interact with database and try to update it the operation should be successful.
Do you confirm that there is enough permission granted on database?
And I hope that you already have a backup as once I will try to update database there is no chance to revert back.
I think that is an error with wp_redis no, and can be ignored. BTW while checking it I ran the migration script by mistake. You can check the attached image for that. It skipped some associations due to some posts being 404. Otherwise all went okay.
Now I think you will see mismatch in search results between live and staging.
Minesh I can provide you a duplicator backup of the staging site (before we upgraded the plugin and migrated DB) Using that backup you can create 2 sites may be and compare them.
