| Merging Duplicate User id's [message #21584] |
Sun, 05 December 2004 18:56  |
srchild
Messages: 88
Registered: December 2003
Location: UK
Karma: 1
|
Member |
|
|
I'm wondering how easy it will be to merge users with duplicate id's into one id?
I've disabled private messaging, so I think that all it might involve is updating the poster_id in table msg, and of course the users in table users?
So I'm thinking that if user id 23 and user id 57 are the same person, I could do something like updating all lines in table msg where poster_id = 23 and change it to 57, then delete user 23 from table users.
Or will that mess everything up because I forgot to change it somewhere else as well...??
Background: I'm importing messages from two yahoogroups. In all of these the email address is obscured by having the right-hand side converted to @n... (where n is a single letter a-z). So as I import these I shall have users autocreated with invalid email addresses. I could go through and update these to make them the live users, but I'm planning on importing the second group later than the first and so this will recreate all the invalid id's as duplicates of the real ones. So I'm thinking to let there be invalid id's for a while, and later merge them with the active registered users (where I can identify them, which is nearly all)
Comments?
Simon Child
|
|
|
|
| Re: Merging Duplicate User id's [message #21587 is a reply to message #21584] |
Sun, 05 December 2004 20:10  |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
For the most part you have the right idea, but you need to update a few more tables when merging the users.
private messages table,
attachment table
and poll tables.
FUDforum Core Developer
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]