hotosm / galaxy-api

Backend to fetch data from Underpass
https://galaxy-api.hotosm.org/latest/redoc
GNU Affero General Public License v3.0
14 stars 5 forks source link

Unexpected input is going to database query : Validation is not working for Project ID #230

Open sentry-io[bot] opened 2 years ago

sentry-io[bot] commented 2 years ago

Sentry Issue: GALAXY-API-C

UndefinedColumn: column "liga" does not exist
LINE 6:             AND th.project_id IN (10155,10155 #liga-zambia)
                                                       ^

(33 additional frame(s) were not displayed)
...
  File "/home/ubuntu/galaxy-api/./src/galaxy/app.py", line 64, in print_psycopg2_exception
    raise err
  File "/home/ubuntu/galaxy-api/./src/galaxy/app.py", line 114, in executequery
    self.cursor.execute(query)
  File "newrelic/hooks/database_psycopg2.py", line 64, in execute
    return super(CursorWrapper, self).execute(sql, parameters, *args,
  File "newrelic/hooks/database_dbapi2.py", line 43, in execute
    return self.__wrapped__.execute(sql, **kwargs)
  File "psycopg2/extras.py", line 146, in execute
    return super().execute(query, vars)

Exception in ASGI application