Hi,

There was a bug in a 2 or 3.x version of DNN when new users other portals (not child portals) received the same UserID (kind of like unwanted single sign on) - this is causing me endless problems (some queries report 3 records back (1 for each additional portal)) and I remember seeing a SQL script somewhere to break the relationship. Does anyone know anything about this or how I can solve the problem?

The last resort is copying the DB and making a new DNN instance and only running one portal off the DNN install but this is a lot of work and will result in a new DNN install to maintain. There are about 100 records where the users are members of all 3 portals..

Any advice appreciated...

Entrepreneur

PokerDIY Tournament Manager - PokerDIY Tournament Manager<
PokerDIY Game Finder - Mobile Apps powered by DNN
PokerDIY - Connecting Poker Players

Hi, thanks for the reply - the site was originally DNN 2, and then the problem came in around 3.x, and I have had it ever since (now on 4.5.0).

So basically - when I was on DNN 2 or 3, there was a bug that if the SAME user  (based on username) in another portal created a new user on a different portal, it would not create a new user record (ie. they now have the same ids across portals, which is wrong).

So, to see it in action (but it affects a variety of modules/portal probs- check out the map on PokerDIY. If you click on the UK, you will noticed a whole lot of duplicates (my Display name on there is PokerDIY - so in the UK you will see 2 PokerDIY's. Ironically there used to be 3 as I have 3 portals on this DNN install, but I have emigrated to Australia and updated my country, so the portal properties are working off the PortalUser record, so the 3rd record is in Aus. A lot of modules (like the Forum) pick up the duplicate records now as they do a query on userID expecting it to be unique across portals, but it is not. This is not the modules fault, it was the fault of the bug on CreateUser over a year ago (I have stupidly ignored the problem until now).

So... what I think is happening is this:

PortalUser table -

Portal ID 1,2,2 links to UserID 1 (me)

User Table has ONE record - UserID 1, but it should have 3, and the PortalUser table should link to each one of these recpectively (sorry, very hard to explain in text!)

Entrepreneur

PokerDIY Tournament Manager - PokerDIY Tournament Manager<
PokerDIY Game Finder - Mobile Apps powered by DNN
PokerDIY - Connecting Poker Players

Hi Rodney,

Let us know if you find out anything. I always just assumed it was simply done like this from the start and was going to stay like this. I'd like it to go one way or the other.. either let us elect to share users across portals, or make it completely separate. It's a pain as it is.

Rob