Some users have been entered twice with different email address. How can i delete one of them. I haven't any ways to do it in the interface...and I couldn't do it straight in the database.
Let me know!
Thanks!
;){kind=logo}
Team Elements
PUBLIC PROFILE
Issues and Open Discussion
Delete a user?
You need to be logged in to post messages
1.
4/10/2007
10:36 PM
EDT
Hello Patrice,
The web interface doesn't yet have a user deletion capability -- only because all data in teamelements is referential and the author and editor of all data is recorded. A spec needs to be made to figure out how to handle the referential integrity and provide a simple web interface to delete and/or merge user's data. There is only a enabled/disabled capability which wouldn't solve your problem.
At the database level this can be done rather quickly because there isn't any (or much) related data yet.
1. If you know the email addresses you want deleted then you can issue:
DELETE FROM users WHERE email = 'user@email.com'
2. If you receive an error that a related user_log record exists then you need to first issue:
DELETE FROM user_log WHERE user_id IN (SELECT user_id FROM users WHERE email = 'user@email.com')
If there is a pattern behind the invalid users then that can reduce the number of SQL statements needed.
3. Finally, because team elements performs caching of user and project data, you should restart tomcat to clear the extra users out of the cache.
Not the best answer, but the admin section in general is lacking behind the other areas.
- Matt
1 result found