Bug #32844

Duplicated users

Added by Steffen Gebert over 9 years ago. Updated over 8 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
-
Target version:
-
Start date:
2011-03-29
Due date:
% Done:

100%

Estimated time:
(Total: 0.00 h)

Description

Probably due to the Mantis-Migration, some duplicated users have been created.

They somehow have to be cleaned up and their issues and comments merged.

SELECT id, login, mail, last_login_on FROM users where login IN
  (SELECT login FROM users GROUP BY login HAVING COUNT(*) > 1) ORDER BY login, id

Effect is that these users are not able to edit their user preferences (something about "name, email already taken").


Subtasks

Bug #25429: Editing user settings not possibleClosed2011-03-29

Actions
Bug #30180: Cannot change my account settingsClosed2011-09-21

Actions

Related issues

Related to forge.typo3.org - Bug #35063: changing Email notifications not possibleClosedSteffen Gebert2012-03-21

Actions
#1

Updated by Steffen Gebert over 9 years ago

  • Status changed from New to Resolved
SET @correctid:=123;
SET @wrongid:=55555;
-- SELECT * FROM issues WHERE author_id=@wrongid;
-- SELECT * FROM journals WHERE user_id=@wrongid;
-- SELECT * FROM members WHERE user_id=@wrongid;
-- SELECT * FROM changesets WHERE user_id=@wrongid;
UPDATE issues SET author_id=@correctid WHERE author_id=@wrongid;
UPDATE journals SET user_id=@correctid WHERE user_id=@wrongid;
UPDATE members SET user_id=@correctid WHERE user_id=@wrongid;
UPDATE changesets SET user_id=@correctid WHERE user_id=@wrongid;
DELETE FROM users WHERE id=@wrongid; 

~90 users

#2

Updated by Steffen Gebert over 9 years ago

The field issues.assigned_to_id was forgotten..

#3

Updated by Steffen Gebert almost 9 years ago

SET @correctid:=123;
SET @wrongid:=55555;
-- SELECT * FROM issues WHERE author_id=@wrongid;
-- SELECT * FROM journals WHERE user_id=@wrongid;
-- SELECT * FROM members WHERE user_id=@wrongid;
-- SELECT * FROM changesets WHERE user_id=@wrongid;
UPDATE issues SET author_id=@correctid WHERE author_id=@wrongid;
UPDATE issues SET assigned_to_id=@correctid WHERE assigned_to_id=@wrongid;
UPDATE journals SET user_id=@correctid WHERE user_id=@wrongid;
UPDATE members SET user_id=@correctid WHERE user_id=@wrongid;
UPDATE changesets SET user_id=@correctid WHERE user_id=@wrongid;
DELETE FROM users WHERE id=@wrongid; 
#4

Updated by Steffen Gebert over 8 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF