Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ERROR: Exception in ASGI application
- Traceback (most recent call last):
- File "/usr/local/lib/python3.7/site-packages/uvicorn/protocols/http/httptools_impl.py", line 375, in run_asgi
- result = await app(self.scope, self.receive, self.send)
- File "/usr/local/lib/python3.7/site-packages/fastapi/applications.py", line 140, in __call__
- await super().__call__(scope, receive, send)
- File "/usr/local/lib/python3.7/site-packages/starlette/applications.py", line 134, in __call__
- await self.error_middleware(scope, receive, send)
- File "/usr/local/lib/python3.7/site-packages/starlette/middleware/errors.py", line 178, in __call__
- raise exc from None
- File "/usr/local/lib/python3.7/site-packages/starlette/middleware/errors.py", line 156, in __call__
- await self.app(scope, receive, _send)
- File "/usr/local/lib/python3.7/site-packages/starlette/middleware/base.py", line 25, in __call__
- response = await self.dispatch_func(request, self.call_next)
- File "./app/main.py", line 51, in db_session_middleware
- response = await call_next(request)
- File "/usr/local/lib/python3.7/site-packages/starlette/middleware/base.py", line 45, in call_next
- task.result()
- File "/usr/local/lib/python3.7/site-packages/starlette/middleware/base.py", line 38, in coro
- await self.app(scope, receive, send)
- File "/usr/local/lib/python3.7/site-packages/starlette/middleware/cors.py", line 76, in __call__
- await self.app(scope, receive, send)
- File "/usr/local/lib/python3.7/site-packages/starlette/exceptions.py", line 73, in __call__
- raise exc from None
- File "/usr/local/lib/python3.7/site-packages/starlette/exceptions.py", line 62, in __call__
- await self.app(scope, receive, sender)
- File "/usr/local/lib/python3.7/site-packages/starlette/routing.py", line 590, in __call__
- await route(scope, receive, send)
- File "/usr/local/lib/python3.7/site-packages/starlette/routing.py", line 208, in __call__
- await self.app(scope, receive, send)
- File "/usr/local/lib/python3.7/site-packages/starlette/routing.py", line 41, in app
- response = await func(request)
- File "/usr/local/lib/python3.7/site-packages/fastapi/routing.py", line 133, in app
- raw_response = await dependant.call(**values)
- File "./app/api/endpoints/quizzes.py", line 71, in get_all_quizzes_available_for_user
- return get_all_quizzes_to_user(db, user)
- File "./app/api/services/quizzes.py", line 248, in get_all_quizzes_to_user
- return get_quizzes_to_show_id(session, user)
- File "./app/crud/quizzes.py", line 120, in get_quizzes_to_show_id
- q1res = session.query(Questionnaire).from_statement(q).all()
- File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3233, in all
- return list(self)
- File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3389, in __iter__
- return self._execute_and_instances(context)
- File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3414, in _execute_and_instances
- result = conn.execute(querycontext.statement, self._params)
- File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 982, in execute
- return meth(self, multiparams, params)
- File "/usr/local/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 293, in _execute_on_connection
- return connection._execute_clauseelement(self, multiparams, params)
- File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1101, in _execute_clauseelement
- distilled_params,
- File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1250, in _execute_context
- e, statement, parameters, cursor, context
- File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1476, in _handle_dbapi_exception
- util.raise_from_cause(sqlalchemy_exception, exc_info)
- File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause
- reraise(type(exception), exception, tb=exc_tb, cause=cause)
- File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 152, in reraise
- raise value.with_traceback(tb)
- File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1246, in _execute_context
- cursor, statement, parameters, context
- File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 588, in do_execute
- cursor.execute(statement, parameters)
- sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedColumn) column q.is_active does not exist
- LINE 1: ...uiz_name, q.final_date from questionnaire q where q.is_activ...
- ^
- [SQL: SELECT q.id, q.quiz_name, q.final_date from questionnaire q where q.is_active = true and q.available_for_group && (Select department_name from "user" where id = %(user_id)s) and q.id not in (SELECT questionnaire_id FROM questionnaire_response where user_id = %(user_id)s)]
- [parameters: {'user_id': 4}]
- (Background on this error at: http://sqlalche.me/e/f405)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement