Image upload is broken

icu bot is uploading images like crazy, icu account is locked now

mysql> SELECT diaspora_handle, COUNT(*) c FROM photos where created_at like '2016-05-30%' and  diaspora_handle='
icu@poddery.com' GROUP BY diaspora_handle HAVING c > 1;
+-----------------+-------+
| diaspora_handle | c     |
+-----------------+-------+
| icu@poddery.com | 29618 |
+-----------------+-------+
1 row in set (1.50 sec)

mysql> SELECT diaspora_handle, COUNT(*) c FROM photos where created_at like '2016-05-29%' and  diaspora_handle='
icu@poddery.com' GROUP BY diaspora_handle HAVING c > 1;
+-----------------+-------+
| diaspora_handle | c     |
+-----------------+-------+
| icu@poddery.com | 28030 |
+-----------------+-------+
1 row in set (1.40 sec)

mysql> SELECT diaspora_handle, COUNT(*) c FROM photos where created_at like '2016-05-15%' and  diaspora_handle='
icu@poddery.com' GROUP BY diaspora_handle HAVING c > 1;
+-----------------+------+
| diaspora_handle | c    |
+-----------------+------+
| icu@poddery.com | 9017 |
+-----------------+------+
1 row in set (1.72 sec)

mysql> SELECT diaspora_handle, COUNT(*) c FROM photos where created_at like '2016-05-01%' and  diaspora_handle='
icu@poddery.com' GROUP BY diaspora_handle HAVING c > 1;
+-----------------+------+
| diaspora_handle | c    |
+-----------------+------+
| icu@poddery.com | 4133 |
+-----------------+------+
1 row in set (1.40 sec)

compare that with my account

mysql> SELECT diaspora_handle, COUNT(*) c FROM photos where created_at like '2016-05-30%' and  diaspora_handle='praveen@poddery.com' GROUP BY diaspora_handle HAVING c > 1;
Empty set (1.30 sec)

mysql> SELECT diaspora_handle, COUNT(*) c FROM photos where created_at like '2016-05-29%' and  diaspora_handle='praveen@poddery.com' GROUP BY diaspora_handle HAVING c > 1;
+---------------------+---+
| diaspora_handle     | c |
+---------------------+---+
| praveen@poddery.com | 3 |
+---------------------+---+
1 row in set (1.62 sec)

To get a feel of how it compares with other users

mysql> SELECT diaspora_handle, COUNT(*) c FROM photos where created_at like '2016-05-30%' and diaspora_handle li
ke '%poddery.com' GROUP BY diaspora_handle HAVING c > 1;
+--------------------+-------+
| diaspora_handle    | c     |
+--------------------+-------+
| icu@poddery.com    | 29618 |
| isabel@poddery.com |     4 |
| lise@poddery.com   |     4 |
+--------------------+-------+
3 rows in set (1.88 sec)

mysql> SELECT diaspora_handle, COUNT(*) c FROM photos where created_at like '2016-05-29%' and diaspora_handle li
ke '%poddery.com' GROUP BY diaspora_handle HAVING c > 1;
+------------------------+-------+
| diaspora_handle        | c     |
+------------------------+-------+
| evilhippie@poddery.com |     3 |
| icu@poddery.com        | 28030 |
| praveen@poddery.com    |     3 |
| riderplus@poddery.com  |     7 |
+------------------------+-------+
4 rows in set (1.79 sec)

mysql> SELECT diaspora_handle, COUNT(*) c FROM photos where created_at like '2016-05-28%' and diaspora_handle li
ke '%poddery.com' GROUP BY diaspora_handle HAVING c > 1;
+-------------------------+-------+
| diaspora_handle         | c     |
+-------------------------+-------+
| anders@poddery.com      |    32 |
| commitstrip@poddery.com |     5 |
| icu@poddery.com         | 26431 |
| isabel@poddery.com      |     3 |
| lise@poddery.com        |     3 |
| praveen@poddery.com     |     3 |
| the_gog@poddery.com     |     3 |
+-------------------------+-------+
7 rows in set (2.03 sec)

mysql> SELECT diaspora_handle, COUNT(*) c FROM photos where created_at like '2016-05-27%' and diaspora_handle like '%poddery.com' GROUP BY diaspora_handle HAVING c > 1;
+----------------------------+------+
| diaspora_handle            | c    |
+----------------------------+------+
| aster@poddery.com          |    2 |
| icu@poddery.com            | 9802 |
| katharsisdrill@poddery.com |    2 |
| lise@poddery.com           |    5 |
| modesty@poddery.com        |    5 |
| neomatia@poddery.com       |    2 |
+----------------------------+------+
6 rows in set (1.84 sec)

mysql> SELECT diaspora_handle, COUNT(*) c FROM photos where created_at like '2016-05-26%' and diaspora_handle like '%poddery.com' GROUP BY diaspora_handle HAVING c > 1;
+------------------------+------+
| diaspora_handle        | c    |
+------------------------+------+
| anders@poddery.com     |   22 |
| icu@poddery.com        | 5462 |
| lise@poddery.com       |    6 |
| mataperros@poddery.com |    3 |
+------------------------+------+
4 rows in set (1.63 sec)

Thanks to @mintojoseph for helping track this issue.