[Resolved] Linked Posts Through Relationships Not Showing on Front End

[Author]

Posts

[charlesB-5]

On one post custom post type "Ouvrage" with have several relationships with other custom posts: Auteurs, Evidences, Receuils and Extraits.

Auteurs and Evidences are showing fine on the front end, but Extraits and Receuils are not.

As an example:
hidden link should show several Extraits and one Receuils.
Admin is: hidden link

I checked all the code for the views and can't find differences between them.

Fell free to access the admin section (same toolset credentials as earlier).

Thank you very much.

Getting the debug info I noticed a "Troubleshooting" "delete leftover posts" - Could this be the issue? Should I delete them?
Thanks again

[Nigel]

Hi Charles

We don't retain login credentials, can I get them from you again so that I can take a look?

[Nigel]

Hi Charles

The Receuils View wasn't working because somehow the Content Selection had been removed (screenshot). I re-applied the Receuils setting, and it worked.

It wasn't clear what the issue with the Extraits View was.

I created a similar View for testing and it worked, so I made a couple of superficial edits to your View (changed the content selection and removed the Query Filter), then set the View back how it was originally, and that seemed to do the trick.

Some underlying option seems to not have saved correctly, but now it's working.

There are admin messages that indicate the importing of related posts wasn't completed, and it looks like some of them associations can't be made because of problems with the data, see the second screenshot.

You should take a backup and then complete the import process. You may need to manually fix the indicated connections.

[charlesB-5]

Thank you Nigel. I there a way to delete this "import" completely? Because when I try to import them on the duplicate site I get this message (see screenshot)
There is no "Ouvrage de Référence" or "Univers" relationships anymore, so I can't delete them manually???

[Nigel]

Did you import data with post relationships from a CSV file, or did you have existing data on an old Types 2 site and ran the migration wizard to upgrade to Types 3?

And now that you ran the import (which effectively failed) does it still prompt you to run the import or does the message prompting you to import the associations disappear?

[charlesB-5]

We never imported any CSV. It must have happened during the migration.
and There is no "Ouvrage de Référence" or "Univers" relationships anymore, so I can't delete them manually???
After the Start Import I am back with the same message as previously (see screenshot)
After I get 1573.. couldn't be imported I click on List Broken Associations... and then back to the original screenshot about import 1573 green 19 red.

I cloned the site you can access it and test if you want at hidden link - Same credentials

[Nigel]

I'm just checking with my colleagues, I'll update you again once I have their input.

[charlesB-5]

Thanks - all import can be deleted.

[Nigel]

OK, the Types developer asked me to escalate with a copy of your site for him to inspect, which I'm doing now.

[Nigel]

There are some leftover entries in the database that need deleting.

Are you comfortable using something like phpMyAdmin to run a couple of SQL queries?

You should, of course, try it on your staging or test site before doing the same on your production site.

The two queries to run would be

DELETE from wp_options WHERE option_name = '_toolset_associations_import_is_available'

DELETE FROM wp_postmeta WHERE meta_key LIKE '_toolset_associations_%'

[charlesB-5]

I ran the queries and it seems to have worked perfectly. Now looking if no data has been lost.

[Waqar]

Hi Charles,

Thanks for the update and glad that Nigel's recommendation worked.

He is on vacation and will be back on Monday, so feel free to let us know in case you need any further assistance around this.

regards,
Waqar