Hello. Thank you for contacting the Toolset support.
It seems you have junk data available with your database may be its due to import you made.
What I suggest, can you please try with clean install where you install only Toolset plugins and build your post types and relationship and try to connect the posts.
I already run a test with my test sing with Many to Many post relationship between post types Exhibitions and Artists and I could not see the issue. Please check the following video: hidden link
I think you're right, we have the same setup on our prod site (pdc.org) without an issue.
But on dev.pdc.org we tried using a plugin, JSON Content Importer, to import Test Hazard Product posts. It's supposed to delete old Test Hazard Product posts whenever a new import is completed, but it seems there may be orphaned data causing Toolset to think the old posts still exist?
I'm not sure how to troubleshoot this, do you know what may be causing Toolset to think there are extra posts being connected?
Thanks so much for your help!
I can get you backend access to the site if you'd like.
I don't doubt that the issue is due to the JCI plugin, and I wouldn't expect you to try to fix someone else's plugin.
But do you know where in the database I should look for duplicate content that may be making Toolset think there are more posts than there are?
I will then pass that information on to the JCI plugin developer to look into further, but they said they are not sure what is causing toolset to think there are more posts attached to the page than there should be.
*** Please make a FULL BACKUP of your database before you perform any deletion from your database.***
Toolset store all connection information within "wp_toolset_associations" table where we store the connection information with relationship ID and associated parent/child IDs including intermediary ID.
If you have many relationships created, you should locate your relationship ID from the table "wp_toolset_relationships" and find all connection that belongs to your specific relationship ID from the "wp_toolset_associations" and then try to delete the found records.
