search

fpdcc / ccfp-asset-dashboard

CCFP Asset Dashboard
0 stars 1 forks source link

Trails gis query throwing an error #241

Closed smcalilly closed 1 year ago

smcalilly commented 1 year ago

From an email:

One issue I already encountered was I couldn’t select trail data when I was creating new projects. I was able to see the selected segments in existing projects though. So please take a look at that.

I was able to recreate this on production.

smcalilly commented 1 year ago

2023-06-20T17:01:30.462258+00:00 heroku[router]: at=info method=GET path="/assets/?q=busse&asset_type=trails" host=ccfp-asset-dashboard-staging.herokuapp.com request_id=ed26142c-f35a-406f-b3fe-9a08f367994a fwd="108.248.50.187" dyno=web.1 connect=0ms service=120ms status=500 bytes=3784 protocol=https 2023-06-20T17:01:49.227051+00:00 app[web.1]: [2023-06-20 17:01:49 +0000] [16] [DEBUG] GET /assets/ Internal Server Error: /assets/ Traceback (most recent call last): File "/usr/local/lib/python3.8/site-packages/django/db/backends/utils.py", line 84, in _execute return self.cursor.execute(sql, params) psycopg2.errors.UndefinedColumn: column trails_info.trails_id does not exist LINE 1: SELECT "quercus"."trails_info"."trail_info_id", "quercus"."t... ^

The above exception was the direct cause of the following exception:

Traceback (most recent call last): File "/usr/local/lib/python3.8/site-packages/django/core/handlers/exception.py", line 47, in inner response = get_response(request) File "/usr/local/lib/python3.8/site-packages/django/core/handlers/base.py", line 181, in _get_response response = wrapped_callback(request, *callback_args, callback_kwargs) File "/usr/local/lib/python3.8/site-packages/django/views/decorators/csrf.py", line 54, in wrapped_view return view_func(*args, *kwargs) File "/usr/local/lib/python3.8/site-packages/rest_framework/viewsets.py", line 125, in view return self.dispatch(request, args, kwargs) File "/usr/local/lib/python3.8/site-packages/rest_framework/views.py", line 509, in dispatch response = self.handle_exception(exc) File "/usr/local/lib/python3.8/site-packages/rest_framework/views.py", line 469, in handle_exception self.raise_uncaught_exception(exc) File "/usr/local/lib/python3.8/site-packages/rest_framework/views.py", line 480, in raise_uncaught_exception raise exc File "/usr/local/lib/python3.8/site-packages/rest_framework/views.py", line 506, in dispatch response = handler(request, *args, **kwargs) File "/usr/local/lib/python3.8/site-packages/rest_framework/mixins.py", line 46, in list return Response(serializer.data) File "/usr/local/lib/python3.8/site-packages/rest_framework_gis/serializers.py", line 23, in data return super(ListSerializer, self).data File "/usr/local/lib/python3.8/site-packages/rest_framework/serializers.py", line 253, in data self._data = self.to_representation(self.instance) File "/usr/local/lib/python3.8/site-packages/rest_framework_gis/serializers.py", line 32, in to_representation ("features", super().to_representation(data)), File "/usr/local/lib/python3.8/site-packages/rest_framework/serializers.py", line 686, in to_representation return [ File "/usr/local/lib/python3.8/site-packages/django/db/models/query.py", line 287, in iter self._fetch_all() File "/usr/local/lib/python3.8/site-packages/django/db/models/query.py", line 1308, in _fetch_all self._result_cache = list(self._iterable_class(self)) File "/usr/local/lib/python3.8/site-packages/django/db/models/query.py", line 53, in iter results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size) File "/usr/local/lib/python3.8/site-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql cursor.execute(sql, params) File "/usr/local/lib/python3.8/site-packages/django/db/backends/utils.py", line 66, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "/usr/local/lib/python3.8/site-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers return executor(sql, params, many, context) File "/usr/local/lib/python3.8/site-packages/django/db/backends/utils.py", line 84, in _execute return self.cursor.execute(sql, params) File "/usr/local/lib/python3.8/site-packages/django/db/utils.py", line 90, in exit raise dj_exc_value.with_traceback(traceback) from exc_value File "/usr/local/lib/python3.8/site-packages/django/db/backends/utils.py", line 84, in _execute return self.cursor.execute(sql, params) django.db.utils.ProgrammingError: column trails_info.trails_id does not exist LINE 1: SELECT "quercus"."trails_info"."trail_info_id", "quercus"."t...