| Merging and splitting user names [message #161258] |
Sat, 28 November 2009 20:55  |
gorm
Messages: 29
Registered: October 2009
Location: Moscow, Russia
Karma: 0
|
Junior Member |
|
|
I am converting my rather large previous forum based on modified WWWboard to Fudforum. This forum had no registration. Sometimes the users of that old made slips in their aliases or just changed their names for some reason. After the conversion sometime I obtain many duplicates for the same user which I would like to merge. How can I change a username for the message or the username in the list of the users as the fprum does not allow to do so to a name that is already registered? Sometime the opposite problem arises - to split a user because sometimes newcomers were using names that were already accepted by former users and than changed them to a new ones. So I would like to have a possiblity to change a name in the message without changing it for all messages assigned to this name.
[Updated on: Sat, 28 November 2009 20:57] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Merging and splitting user names [message #161407 is a reply to message #161392] |
Mon, 21 December 2009 20:40  |
gorm
Messages: 29
Registered: October 2009
Location: Moscow, Russia
Karma: 0
|
Junior Member |
|
|
naudefj писал(а) Сбт, 19 Декабрь 2009 12:50I don't have an example. You probably need to update fud28_msg (poster_id column) as well as the other tables mentioned in the quoted thread.
When I try in SQL manager something like:
update fud30_msg set poster_id='285' where id='3486';
I get
Fatal error: Call to a member function fetch() on a non-object in ../FUDforum/include/theme/default/db.inc on line 182
However the user name changes while the statistics is not updated. That is why I need to do a concistency check to update it.
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]