Maximum cardinality achieved, not importing relationship

This support ticket is created 5 years, 5 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: Post-relationship

This topic contains 4 replies, has 3 voices.

Last updated by MennoB5853 5 years, 5 months ago.

Assisted by: Luo Yang.

Author

Posts

May 29, 2019 at 10:29 pm #1253725

Darren

I am trying to: Import parent/child relationships using WP All Import

Link to a page where the issue can be seen: This site is currently running on a private server

I have a large number of posts within a 4 different custom post types. One of them is the parent post type and the other 3 are connected to the parent using relationships of one to many.

Parent posts = 19K+
Child 1 = 100K
Child 2 = 200K
Child 3 = 75K

I've begun importing the relationships using WP All Import and the Toolset beta import plugin.

The first import I did went very smoothly and didn't see too many issues. The second, however, is limiting me only a one to one relationship. Upon looking a the WP All Import log, I'm seeing:

"Maximum cardinality achieved, not importing relationship"

I'm assuming this is the error that's not allowing any more relationships to be added to the database.

Can anyone lend some insight on this? I can't find any reference to it. I've contacted them as well and I'm waiting to hear back.

Thanks in advance!

May 30, 2019 at 3:58 am #1253809

Luo Yang

Hello,

I assume you see the error message when using WP All Import plugin, this should be some limitation of WP All Import plugin, I have searched the keyword "Maximum cardinality achieved WP All Import" in google, but can not find report too.

I suggest you check with their support for this:
hidden link

May 30, 2019 at 1:02 pm #1254301

Darren

I Googled it too but had no luck finding anything.

I contacted them as well but I wanted to make sure there were no restrictions on how many total parent/child connections I could have on the site. I have never heard of anything like this but had to ask.

Thanks for your help and I'll come back to this thread if I need further assistance.

May 31, 2019 at 1:29 am #1254681

Luo Yang

There isn't any limitation in Toolset side, it should be a limitation of WP All Import plugin.

January 10, 2020 at 11:44 am #1450617

MennoB5853

Hi Luo and Darren,

I also have this issue. Looks something to do with SQL: hidden link). A unique id has a high cardinality, a random word which may have multiple instances has a low cardinality. I think WP All Import doesn't handle post relationships very well, because it thinks the value might be used only once, even when the relationship is one to many.

Following 🙂