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='
[email protected]' GROUP BY diaspora_handle HAVING c > 1;
+-----------------+-------+
| diaspora_handle | c     |
+-----------------+-------+
| [email protected] | 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='
[email protected]' GROUP BY diaspora_handle HAVING c > 1;
+-----------------+-------+
| diaspora_handle | c     |
+-----------------+-------+
| [email protected] | 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='
[email protected]' GROUP BY diaspora_handle HAVING c > 1;
+-----------------+------+
| diaspora_handle | c    |
+-----------------+------+
| [email protected] | 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='
[email protected]' GROUP BY diaspora_handle HAVING c > 1;
+-----------------+------+
| diaspora_handle | c    |
+-----------------+------+
| [email protected] | 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='[email protected]' 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='[email protected]' GROUP BY diaspora_handle HAVING c > 1;
+---------------------+---+
| diaspora_handle     | c |
+---------------------+---+
| [email protected] | 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     |
+--------------------+-------+
| [email protected]    | 29618 |
| [email protected] |     4 |
| [email protected]   |     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     |
+------------------------+-------+
| [email protected] |     3 |
| [email protected]        | 28030 |
| [email protected]    |     3 |
| [email protected]  |     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     |
+-------------------------+-------+
| [email protected]      |    32 |
| [email protected] |     5 |
| [email protected]         | 26431 |
| [email protected]      |     3 |
| [email protected]        |     3 |
| [email protected]     |     3 |
| [email protected]     |     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    |
+----------------------------+------+
| [email protected]          |    2 |
| [email protected]            | 9802 |
| [email protected] |    2 |
| [email protected]           |    5 |
| [email protected]        |    5 |
| [email protected]       |    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    |
+------------------------+------+
| [email protected]     |   22 |
| [email protected]        | 5462 |
| [email protected]       |    6 |
| [email protected] |    3 |
+------------------------+------+
4 rows in set (1.63 sec)

Thanks to @mintojoseph for helping track this issue.