2
1
| Exception | Count |
|---|---|
| mysql.connector.errors.DatabaseError: 1525 (HY000): Incorrect DATETIME value: 'Invalid Date 23:59:59' | 2 |
| # | Timestamp | Level | Primary exception | Details |
|---|---|---|---|---|
| 1 | 2026-11-20 09:32:12 +0530 | ERROR | mysql.connector.errors.DatabaseError: 1525 (HY000): Incorrect DATETIME value: 'Invalid Date 23:59:59' | |
[2026-11-20 09:32:12 +0530] [2223178] [ERROR] Exception in ASGI application
Traceback (most recent call last):
File "/var/softech/school-api/venv/lib/python3.12/site-packages/mysql/connector/connection_cext.py", line 755, in cmd_query
self._cmysql.query(
_mysql_connector.MySQLInterfaceError: Incorrect DATETIME value: 'Invalid Date 23:59:59'
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/var/softech/school-api/venv/lib/python3.12/site-packages/uvicorn/protocols/http/h11_impl.py", line 403, in run_asgi
result = await app( # type: ignore[func-returns-value]
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/softech/school-api/venv/lib/python3.12/site-packages/uvicorn/middleware/proxy_headers.py", line 60, in __call__
return await self.app(scope, receive, send)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/softech/school-api/venv/lib/python3.12/site-packages/fastapi/applications.py", line 1054, in __call__
await super().__call__(scope, receive, send)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/applications.py", line 112, in __call__
await self.middleware_stack(scope, receive, send)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/middleware/errors.py", line 187, in __call__
raise exc
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/middleware/errors.py", line 165, in __call__
await self.app(scope, receive, _send)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/middleware/cors.py", line 93, in __call__
await self.simple_response(scope, receive, send, request_headers=headers)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/middleware/cors.py", line 144, in simple_response
await self.app(scope, receive, send)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/middleware/exceptions.py", line 62, in __call__
await wrap_app_handling_exceptions(self.app, conn)(scope, receive, send)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app
raise exc
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/_exception_handler.py", line 42, in wrapped_app
await app(scope, receive, sender)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/routing.py", line 714, in __call__
await self.middleware_stack(scope, receive, send)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/routing.py", line 734, in app
await route.handle(scope, receive, send)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/routing.py", line 460, in handle
await self.app(scope, receive, send)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/fastapi/applications.py", line 1054, in __call__
await super().__call__(scope, receive, send)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/applications.py", line 112, in __call__
await self.middleware_stack(scope, receive, send)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/middleware/errors.py", line 187, in __call__
raise exc
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/middleware/errors.py", line 165, in __call__
await self.app(scope, receive, _send)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/middleware/base.py", line 176, in __call__
with recv_stream, send_stream, collapse_excgroups():
File "/usr/lib/python3.12/contextlib.py", line 158, in __exit__
self.gen.throw(value)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/_utils.py", line 82, in collapse_excgroups
raise exc
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/middleware/base.py", line 178, in __call__
response = await self.dispatch_func(request, call_next)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/softech/school-api/main.py", line 107, in startup
response = await call_next(request)
^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/middleware/base.py", line 156, in call_next
raise app_exc
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/middleware/base.py", line 141, in coro
await self.app(scope, receive_or_disconnect, send_no_error)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/middleware/exceptions.py", line 62, in __call__
await wrap_app_handling_exceptions(self.app, conn)(scope, receive, send)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app
raise exc
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/_exception_handler.py", line 42, in wrapped_app
await app(scope, receive, sender)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/routing.py", line 714, in __call__
await self.middleware_stack(scope, receive, send)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/routing.py", line 734, in app
await route.handle(scope, receive, send)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/routing.py", line 288, in handle
await self.app(scope, receive, send)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/routing.py", line 76, in app
await wrap_app_handling_exceptions(app, request)(scope, receive, send)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app
raise exc
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/_exception_handler.py", line 42, in wrapped_app
await app(scope, receive, sender)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/routing.py", line 73, in app
response = await f(request)
^^^^^^^^^^^^^^^^
File "/var/softech/school-api/venv/lib/python3.12/site-packages/fastapi/routing.py", line 301, in app
raw_response = await run_endpoint_function(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/softech/school-api/venv/lib/python3.12/site-packages/fastapi/routing.py", line 212, in run_endpoint_function
return await dependant.call(**values)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/softech/school-api/app/routers/v2/endpoints/fee_report.py", line 68, in get_collection_report_v2
return module.get_collection_report_v2(token_data, start_date, end_date, is_monthly, additional_cols, split_by, collection_mode, sort_by)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/softech/school-api/app/routers/v2/core/report/fee_collection_report.py", line 427, in get_collection_report_v2
results = db.execute(query, params).fetchall()
^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/softech/school-api/app/framework/db/mysqlconnection.py", line 30, in execute
raise ex
File "/var/softech/school-api/app/framework/db/mysqlconnection.py", line 27, in execute
self.cursor.execute(query, data)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/mysql/connector/cursor_cext.py", line 351, in execute
self._connection.cmd_query(
File "/var/softech/school-api/venv/lib/python3.12/site-packages/mysql/connector/opentelemetry/context_propagation.py", line 97, in wrapper
return method(cnx, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/softech/school-api/venv/lib/python3.12/site-packages/mysql/connector/connection_cext.py", line 763, in cmd_query
raise get_mysql_exception(
mysql.connector.errors.DatabaseError: 1525 (HY000): Incorrect DATETIME value: 'Invalid Date 23:59:59' |
||||
| 2 | 2026-11-20 09:32:14 +0530 | ERROR | mysql.connector.errors.DatabaseError: 1525 (HY000): Incorrect DATETIME value: 'Invalid Date 23:59:59' | |
[2026-11-20 09:32:14 +0530] [2223178] [ERROR] Exception in ASGI application
Traceback (most recent call last):
File "/var/softech/school-api/venv/lib/python3.12/site-packages/mysql/connector/connection_cext.py", line 755, in cmd_query
self._cmysql.query(
_mysql_connector.MySQLInterfaceError: Incorrect DATETIME value: 'Invalid Date 23:59:59'
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/var/softech/school-api/venv/lib/python3.12/site-packages/uvicorn/protocols/http/h11_impl.py", line 403, in run_asgi
result = await app( # type: ignore[func-returns-value]
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/softech/school-api/venv/lib/python3.12/site-packages/uvicorn/middleware/proxy_headers.py", line 60, in __call__
return await self.app(scope, receive, send)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/softech/school-api/venv/lib/python3.12/site-packages/fastapi/applications.py", line 1054, in __call__
await super().__call__(scope, receive, send)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/applications.py", line 112, in __call__
await self.middleware_stack(scope, receive, send)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/middleware/errors.py", line 187, in __call__
raise exc
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/middleware/errors.py", line 165, in __call__
await self.app(scope, receive, _send)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/middleware/cors.py", line 93, in __call__
await self.simple_response(scope, receive, send, request_headers=headers)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/middleware/cors.py", line 144, in simple_response
await self.app(scope, receive, send)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/middleware/exceptions.py", line 62, in __call__
await wrap_app_handling_exceptions(self.app, conn)(scope, receive, send)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app
raise exc
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/_exception_handler.py", line 42, in wrapped_app
await app(scope, receive, sender)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/routing.py", line 714, in __call__
await self.middleware_stack(scope, receive, send)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/routing.py", line 734, in app
await route.handle(scope, receive, send)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/routing.py", line 460, in handle
await self.app(scope, receive, send)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/fastapi/applications.py", line 1054, in __call__
await super().__call__(scope, receive, send)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/applications.py", line 112, in __call__
await self.middleware_stack(scope, receive, send)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/middleware/errors.py", line 187, in __call__
raise exc
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/middleware/errors.py", line 165, in __call__
await self.app(scope, receive, _send)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/middleware/base.py", line 176, in __call__
with recv_stream, send_stream, collapse_excgroups():
File "/usr/lib/python3.12/contextlib.py", line 158, in __exit__
self.gen.throw(value)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/_utils.py", line 82, in collapse_excgroups
raise exc
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/middleware/base.py", line 178, in __call__
response = await self.dispatch_func(request, call_next)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/softech/school-api/main.py", line 107, in startup
response = await call_next(request)
^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/middleware/base.py", line 156, in call_next
raise app_exc
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/middleware/base.py", line 141, in coro
await self.app(scope, receive_or_disconnect, send_no_error)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/middleware/exceptions.py", line 62, in __call__
await wrap_app_handling_exceptions(self.app, conn)(scope, receive, send)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app
raise exc
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/_exception_handler.py", line 42, in wrapped_app
await app(scope, receive, sender)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/routing.py", line 714, in __call__
await self.middleware_stack(scope, receive, send)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/routing.py", line 734, in app
await route.handle(scope, receive, send)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/routing.py", line 288, in handle
await self.app(scope, receive, send)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/routing.py", line 76, in app
await wrap_app_handling_exceptions(app, request)(scope, receive, send)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app
raise exc
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/_exception_handler.py", line 42, in wrapped_app
await app(scope, receive, sender)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/starlette/routing.py", line 73, in app
response = await f(request)
^^^^^^^^^^^^^^^^
File "/var/softech/school-api/venv/lib/python3.12/site-packages/fastapi/routing.py", line 301, in app
raw_response = await run_endpoint_function(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/softech/school-api/venv/lib/python3.12/site-packages/fastapi/routing.py", line 212, in run_endpoint_function
return await dependant.call(**values)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/softech/school-api/app/routers/v2/endpoints/fee_report.py", line 68, in get_collection_report_v2
return module.get_collection_report_v2(token_data, start_date, end_date, is_monthly, additional_cols, split_by, collection_mode, sort_by)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/softech/school-api/app/routers/v2/core/report/fee_collection_report.py", line 427, in get_collection_report_v2
results = db.execute(query, params).fetchall()
^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/softech/school-api/app/framework/db/mysqlconnection.py", line 30, in execute
raise ex
File "/var/softech/school-api/app/framework/db/mysqlconnection.py", line 27, in execute
self.cursor.execute(query, data)
File "/var/softech/school-api/venv/lib/python3.12/site-packages/mysql/connector/cursor_cext.py", line 351, in execute
self._connection.cmd_query(
File "/var/softech/school-api/venv/lib/python3.12/site-packages/mysql/connector/opentelemetry/context_propagation.py", line 97, in wrapper
return method(cnx, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/softech/school-api/venv/lib/python3.12/site-packages/mysql/connector/connection_cext.py", line 763, in cmd_query
raise get_mysql_exception(
mysql.connector.errors.DatabaseError: 1525 (HY000): Incorrect DATETIME value: 'Invalid Date 23:59:59' |
||||