Visiting the page for images uploaded by a specific user to a specific competition (e.g. images?event=monuments&year=2022&country=Sweden&user=Tanzania ) results in a 502 error.
Stacktrace below:
| 1 | [pid: 29706|app: 0|req: 1/10939] 192.168.209.150 () {60 vars in 1236 bytes} [Fri Sep 2 06:00:27 2022] GET /images?event=monuments&year=2022&country=Sweden&user=Bamsefar75 => generated 0 bytes in 84 msecs (HTTP/1.1 500) 0 headers in 0 bytes (0 switches on core 0) |
|---|---|
| 2 | Traceback (most recent call last): |
| 3 | File "/data/project/wikiloves/www/python/venv/local/lib/python2.7/site-packages/flask/app.py", line 2464, in __call__ |
| 4 | return self.wsgi_app(environ, start_response) |
| 5 | File "/data/project/wikiloves/www/python/venv/local/lib/python2.7/site-packages/flask/app.py", line 2450, in wsgi_app |
| 6 | response = self.handle_exception(e) |
| 7 | File "/data/project/wikiloves/www/python/venv/local/lib/python2.7/site-packages/flask/app.py", line 1867, in handle_exception |
| 8 | reraise(exc_type, exc_value, tb) |
| 9 | File "/data/project/wikiloves/www/python/venv/local/lib/python2.7/site-packages/flask/app.py", line 2447, in wsgi_app |
| 10 | response = self.full_dispatch_request() |
| 11 | File "/data/project/wikiloves/www/python/venv/local/lib/python2.7/site-packages/flask/app.py", line 1952, in full_dispatch_request |
| 12 | rv = self.handle_user_exception(e) |
| 13 | File "/data/project/wikiloves/www/python/venv/local/lib/python2.7/site-packages/flask/app.py", line 1821, in handle_user_exception |
| 14 | reraise(exc_type, exc_value, tb) |
| 15 | File "/data/project/wikiloves/www/python/venv/local/lib/python2.7/site-packages/flask/app.py", line 1950, in full_dispatch_request |
| 16 | rv = self.dispatch_request() |
| 17 | File "/data/project/wikiloves/www/python/venv/local/lib/python2.7/site-packages/flask/app.py", line 1936, in dispatch_request |
| 18 | return self.view_functions[rule.endpoint](**req.view_args) |
| 19 | File "/data/project/wikiloves/www/python/src/app.py", line 159, in images_page |
| 20 | imgs = images.get(args) |
| 21 | File "./images.py", line 44, in get |
| 22 | data = commonsdb.query(*sql) |
| 23 | File "./commons_database.py", line 41, in query |
| 24 | return self._query(*sql) |
| 25 | File "./commons_database.py", line 30, in _query |
| 26 | cursor.execute(*sql) |
| 27 | File "/data/project/wikiloves/www/python/venv/local/lib/python2.7/site-packages/pymysql/cursors.py", line 161, in execute |
| 28 | query = self.mogrify(query, args) |
| 29 | File "/data/project/wikiloves/www/python/venv/local/lib/python2.7/site-packages/pymysql/cursors.py", line 140, in mogrify |
| 30 | query = query % self._escape_args(args, conn) |
| 31 | TypeError: not all arguments converted during string formatting |
| 32 | [pid: 29706|app: 0|req: 2/10940] 192.168.209.150 () {60 vars in 1236 bytes} [Fri Sep 2 06:00:27 2022] GET /images?event=monuments&year=2022&country=Sweden&user=Bamsefar75 => generated 0 bytes in 74 msecs (HTTP/1.1 500) 0 headers in 0 bytes (0 switches on core 0) |