[OH-Dev] For a good time, run this SQL in production
Asheesh Laroia
lists at asheesh.org
Thu Mar 15 19:08:30 UTC 2012
Excerpts from Walker Hale IV's message of Wed Mar 14 18:54:47 -0400 2012:
> Asheesh,
>
> When I locally install 2012-03-12.json and run this command, I get one
> row back (for username=twiggy):
>
> select * from auth_user
> where id not in (select user_id from profile_person)
>
> I should get zero rows back. I am not authorized to run this query in
> production. Could you take a look?
mysql> select id,username,first_name,last_name,email,is_staff,is_active,is_superuser,last_login,date_joined from auth_user where id not in (select user_id from profile_person);
+----+----------+------------+-----------+-------+----------+-----------+--------------+---------------------+---------------------+
| id | username | first_name | last_name | email | is_staff | is_active | is_superuser | last_login | date_joined |
+----+----------+------------+-----------+-------+----------+-----------+--------------+---------------------+---------------------+
| 2 | twiggy | | | | 0 | 1 | 0 | 2009-07-12 13:11:03 | 2009-07-12 13:11:03 |
+----+----------+------------+-----------+-------+----------+-----------+--------------+---------------------+---------------------+
1 row in set (0.02 sec)
Our friend, twiggy! Raphael Krut-Landau will remember him, if he's still
on the list.
Twiggy was a demo user.
We should probably remove him.
-- Asheesh.
More information about the Devel
mailing list