[root at localhost: [Django] Error (EXTERNAL IP): /register/]

[Ralf Baechle]

On Thu, Dec 08, 2011 at 10:41:44PM +0800, Jeremy Kerr wrote:

> At the moment, the registration process explicitly disallows multiple
> registrations with the same address. If you try to add a new one, you
> get an error telling you that the email address is already registered.
> 
> The stack trace you've shown is erroring-out *before* the registration
> is saved. This would indicate that you *already* have two entries in the
> auth_user table with that email address (and are now trying to add a
> third). Did you add one manually?

mysql> SELECT id, username, last_login, date_joined FROM auth_user WHERE email = 'ralf at linux-mips.org';
+----+----------+---------------------+---------------------+
| id | username | last_login          | date_joined         |
+----+----------+---------------------+---------------------+
|  1 | root     | 2011-12-07 12:43:30 | 2009-10-10 02:08:07 |
|  5 | ralf     | 2011-12-07 13:27:12 | 2009-10-10 09:04:34 |
+----+----------+---------------------+---------------------+
2 rows in set (0.03 sec)

root is the django admin account which I don't use for patchwork itself.
ralf is the account I use for all the actual patchworking.

As per the last column I created these accounts in 2009 so I'm not quite
sure what I did back then to create two accounts with the same email
address but I'm sure I did not manually add this record.

mysql> SELECT type, email, user_id, date, active FROM patchwork_emailconfirmation WHERE email = 'ralf at linux-mips.org';
+------------+---------------------+---------+---------------------+--------+
| type       | email               | user_id | date                | active |
+------------+---------------------+---------+---------------------+--------+
| userperson | ralf at linux-mips.org |       5 | 2009-10-10 09:10:53 |      0 |
| optout     | ralf at linux-mips.org |    NULL | 2011-12-06 15:59:50 |      0 |
| optout     | ralf at linux-mips.org |    NULL | 2011-12-07 13:01:33 |      1 |
+------------+---------------------+---------+---------------------+--------+
3 rows in set (0.01 sec)

Seems the first entry in this table is a leftover from creating the ralf
account.  Which makes me wonder why there is nothing equivalent for root.
Probably because django doesn't verify email addresses, just patchwork?

  Ralf