When a user request new e-mail address verification email the previous one should be deleted

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 6.1.30 EE GA3, 6.1.X EE, 6.2.10 EE GA1, 6.2.X EE, 7.0.0 M3
• Fix Version/s: 6.2.4 CE GA5, 6.2.X EE, 7.0.0 M4
• Component/s: User Management
• Labels:
  • 6.1_release_notes
  • liferay-fixpack-portal-44-6130
  • liferay-fixpack-portal-58-6210
• Branch Version/s:
  6.2.x
• Backported to Branch:
  Committed
• Story Points: 14
• Fix Priority: 3
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/24110

Steps to reproduce:

1. In Portal Settings > Authentication check the "Require strangers to verify their email address?" checkbox
2. Register a user
3. Sign in with the new user
4. When you asked for your e-mail address verification code click on Send New Verification code
5. Now if you check the DB you will see 2 tickets in the ticket table for the same user with the same e-mail address
   If you use one of the verification codes only that record will be deleted from the DB.

Result: The old verification code (ticket) is left in the ticket table. Since only one ticket will be used any other will be left forever in the db.

Expected behavior: When a new verification code is sent any previous ones should be deleted.