IntegrityError: (1062, "Duplicate entry 'teo8976@gmail.com' for key 'PRIMARY'")

[teo8976]

I created an account succesfully. Then I logged in to report a(nother) bug, and it prompted me to choose a nickname. After trying a couple that already existed (and receiving a sensible message telling me they were already in use and to choose a different one), I entered "teoteo" and I got this stupid error, without the option to pick a different username.

Signing in and up to Oracle is always a pain in the ass, I can't understand how it can be that difficult to create a decent system where users can sing up and login. It's unbelievable.

And no, it's not a VirtualBox bug at all, but this is where I got automatically redirected after getting this error.

The title of the report and everything below the following line were pre-filled-in.

How to Reproduce

While doing a POST operation on /login, Trac issued an internal error.

(please provide additional details here)

Request parameters:

{'__FORM_TOKEN': u'2aec1b53ef5086a570193c62',
 'nick': u'teoteo',
 'referer': u'https://www.215389.xyz/login'}

User agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36

System Information

System information not available

Enabled Plugins

Plugin information not available

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 513, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 235, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.4/site-packages/trac/web/auth.py", line 124, in process_request
    ret = self._do_login(req)
  File "/usr/lib/python2.4/site-packages/trac/web/auth.py", line 229, in _do_login
    @self.env.with_transaction()
  File "/usr/lib/python2.4/site-packages/trac/db/api.py", line 77, in transaction_wrapper
    fn(ldb)
  File "/usr/lib/python2.4/site-packages/trac/web/auth.py", line 234, in store_authnick
    (remote_user, nick))
  File "/usr/lib/python2.4/site-packages/trac/db/util.py", line 65, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib64/python2.4/site-packages/MySQL_python-1.2.4b4-py2.4-linux-x86_64.egg/MySQLdb/cursors.py", line 202, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib64/python2.4/site-packages/MySQL_python-1.2.4b4-py2.4-linux-x86_64.egg/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
IntegrityError: (1062, "Duplicate entry 'teo8976@gmail.com' for key 'PRIMARY'")

[Frank Mehnert]

Duplicate of #12460.