[2022-03-27 20:42:44][INFO] Server.access - ***** - POST /group/getGroupByPages HTTP/1.1 500 Internal Server Error
[2022-03-27 20:42:44][INFO] Server.default - Exception in ASGI application
Traceback (most recent call last):
File "***\Python37\lib\site-packages\peewee.py", line 3177, in execute_sql
cursor.execute(sql, params or ())
File "***\Python37\lib\site-packages\pymysql\cursors.py", line 148, in execute
result = self._query(query)
File "***\Python37\lib\site-packages\pymysql\cursors.py", line 310, in _query
conn.query(q)
File "***\Python37\lib\site-packages\pymysql\connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "***\Python37\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
result.read()
File "***\Python37\lib\site-packages\pymysql\connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "***\Python37\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
packet.raise_for_error()
File "***\Python37\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "***\Python37\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.ProgrammingError: (1064, 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'"group" g left join group_active g2 on g.group_id = g2.group_id\' at line 1')
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "***\Python37\lib\site-packages\uvicorn\protocols\http\h11_impl.py", line 366, in run_asgi
result = await app(self.scope, self.receive, self.send)
File "***\Python37\lib\site-packages\uvicorn\middleware\proxy_headers.py", line 75, in __call__
return await self.app(scope, receive, send)
File "***\Python37\lib\site-packages\fastapi\applications.py", line 208, in __call__
await super().__call__(scope, receive, send)
File "***\Python37\lib\site-packages\starlette\applications.py", line 112, in __call__
await self.middleware_stack(scope, receive, send)
File "***\Python37\lib\site-packages\starlette\middleware\errors.py", line 181, in __call__
raise exc
File "***\Python37\lib\site-packages\starlette\middleware\errors.py", line 159, in __call__
await self.app(scope, receive, _send)
File "***\Python37\lib\site-packages\starlette\middleware\cors.py", line 92, in __call__
await self.simple_response(scope, receive, send, request_headers=headers)
File "***\Python37\lib\site-packages\starlette\middleware\cors.py", line 147, in simple_response
await self.app(scope, receive, send)
File "***\Python37\lib\site-packages\starlette\exceptions.py", line 82, in __call__
raise exc
File "***\Python37\lib\site-packages\starlette\exceptions.py", line 71, in __call__
await self.app(scope, receive, sender)
File "***\Python37\lib\site-packages\starlette\routing.py", line 656, in __call__
await route.handle(scope, receive, send)
File "***\Python37\lib\site-packages\starlette\routing.py", line 259, in handle
await self.app(scope, receive, send)
File "***\Python37\lib\site-packages\starlette\routing.py", line 61, in app
response = await func(request)
File "***\Python37\lib\site-packages\fastapi\routing.py", line 227, in app
dependant=dependant, values=values, is_coroutine=is_coroutine
File "***\Python37\lib\site-packages\fastapi\routing.py", line 159, in run_endpoint_function
return await dependant.call(**values)
File "***\AmiyaBot\interfaces\group.py", line 82, in get_group_by_pages
res = group.execute_sql(sql).fetchall()
File "***\Python37\lib\site-packages\peewee.py", line 3184, in execute_sql
self.commit()
File "***\Python37\lib\site-packages\peewee.py", line 2950, in __exit__
reraise(new_type, new_type(exc_value, *exc_args), traceback)
File "***\Python37\lib\site-packages\peewee.py", line 191, in reraise
raise value.with_traceback(tb)
File "***\Python37\lib\site-packages\peewee.py", line 3177, in execute_sql
cursor.execute(sql, params or ())
File "***\Python37\lib\site-packages\pymysql\cursors.py", line 148, in execute
result = self._query(query)
File "***\Python37\lib\site-packages\pymysql\cursors.py", line 310, in _query
conn.query(q)
File "***\Python37\lib\site-packages\pymysql\connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "***\Python37\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
result.read()
File "***\Python37\lib\site-packages\pymysql\connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "***\Python37\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
packet.raise_for_error()
File "***\Python37\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "***\Python37\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
peewee.ProgrammingError: (1064, 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'"group" g left join group_active g2 on g.group_id = g2.group_id\' at line 1')