My employer has moved to a new domain, and hence we all have new email
I tried changing my email address from the Configuration menu, but it said
I tried doing this as rt root, but got “Illegal value in EmailAddress”.
I checked and found that my new email address is already present in RT’s
database, as “Autocreated on ticket submission”.
How do I merge these accounts?
mysql> select id,Name,EmailAddress,Comments from Users where EmailAddress like ‘%binand%’;
| id | Name | EmailAddress | Comments |
| 4 | binand | firstname.lastname@example.org | NULL |
| 40 | email@example.com | firstname.lastname@example.org | Autocreated on ticket submission |
| 55 | email@example.com | firstname.lastname@example.org | Autocreated on ticket submission |
| 101 | email@example.com | firstname.lastname@example.org | Autocreated on ticket submission |
4 rows in set (0.01 sec)
I want to merge all these into one account, with id = 4. Or if
simpler, I just want to change the EmailAddress for id = 4 to
email@example.com. Is it ok if I do an UPDATE in the database?
RT version is 2.0.13.