Meta Box

Apologies for the late reply.

I have installed the latest MB User Meta plugin (v 1.2.9).

I have followed my replication instructions here.

The good news is that when I deleted the user who shared the same ID as the post, all other users who were associated with the post REMAINED associated with the post. (Previously they all lost their relationship with that post!) So this is great, thank you.

However, before I deleted the user who shared the ID with the post. I noticed this:

What I SHOULD be seeing here is this:

The post "TESTING" shares the same ID as the user.

So one bug fixed but another remains:

If the user shares the same ID as the post they are associated with. It doesn't render the user's associations correctly in the user profile

Thanks for your help 🙂

I suspect you will be okay in your scenario because terms utilise the terms database table whereas posts, pages and custom post types utilise the posts table.

Matching IDs from the users table and the posts table is where problems lies.

However, I do not know for sure about terms; you'll have to test this by assigning multiple users to the same term and then deleting any user that shares the ID of said term (or vice versa) to see if everything remains intact as it should.

But still, this is a very significant bug. Developers, please chime in. Here is how you can replicate the issue. Thank you.

Hello, I am bumping this thread because this is a major bug!

Please see my previous post (this one) for instructions about how to replicate this issue.

This is actually worse than I first thought.

I just deleted a standard page (standard pages have no MB relationships set up on my installation at all).

The page had an ID of 55.

When I then checked the user with an ID of 55, this user no longer has any of the relationships they had before I deleted the completely unrelated page!

This means if I delete ANY post type that happens to share an ID with a user, all of that user’s relationships disappear!

This is a very big problem!

Thanks for reading.

Thank you very much for your swift response.

You have slightly misunderstood the issue.

The (related) post does not get deleted; that stays intact like you have found.

The issue is ALL other users that had a relationship with that post no longer have a releationship with it.

To replicate the issue:

• Create three new users
• Create one new post
• Make a relationship between the three new users and the new post
• Make one of the users have the same ID as the post
• Delete the user who has the same ID as the post

Once deleted, the remaining two users will no longer have a relationship with the post.

My short-term solution to the issue has been to change the auto-increment of the ID column in the users table to 1 million meaning any new user IDs will be 1M+1, 1M+2, 1M+3, etc, to ensure there will be no more ID collisions between users and posts (my post IDs are still relatively low, less than 200).

That will keep things working on my website for a long time. It's unlikely but if the post IDs in the future exceed 1M, the problem will come back because there will again be user IDs that match post IDs and the problem will persist.

I hope I have made things a little clearer. If you need to know anything else, let me know and I'll be happy to explain further.

Thank you

Ok thank you for your help. No worries, I'll keep doing it the way I'm doing it for now.

All the best