SQLAlchemy error (MySQLdb._exceptions.OperationalError) (1054, "Unknown column 'message' in 'field list'") #11

Closed
opened 2023-03-05 12:38:26 +00:00 by KamijouMarisa · 2 comments
[2023-03-05 20:29:40] ERROR | Database | SQLAlchemy error (MySQLdb._exceptions.OperationalError) (1054, "Unknown column 'message' in 'field list'")
[SQL: INSERT INTO event_log (`system`, type, severity, message, details) VALUES (%s, %s, %s, %s, %s)]
[parameters: ('allnet', 'ALLNET_AUTH_SUCCESS', 20, 'A61E01A0017 authenticated from 172.19.228.155: SDFE v0.00', '"{}"')]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
[2023-03-05 20:29:40] ERROR | Database | core.data.schema.base: Failed to insert event into event log! system = allnet, type = ALLNET_AUTH_SUCCESS, severity = 20, message = A61E01A0017 authenticated from 172.19.228.155: SDFE v0.00
``` [2023-03-05 20:29:40] ERROR | Database | SQLAlchemy error (MySQLdb._exceptions.OperationalError) (1054, "Unknown column 'message' in 'field list'") [SQL: INSERT INTO event_log (`system`, type, severity, message, details) VALUES (%s, %s, %s, %s, %s)] [parameters: ('allnet', 'ALLNET_AUTH_SUCCESS', 20, 'A61E01A0017 authenticated from 172.19.228.155: SDFE v0.00', '"{}"')] (Background on this error at: https://sqlalche.me/e/14/e3q8) [2023-03-05 20:29:40] ERROR | Database | core.data.schema.base: Failed to insert event into event log! system = allnet, type = ALLNET_AUTH_SUCCESS, severity = 20, message = A61E01A0017 authenticated from 172.19.228.155: SDFE v0.00 ```
Contributor

Make sure you always update your database (schemas) before posting an issue.

python dbutils.py --version 3 upgrade
Make sure you always update your database (schemas) before posting an issue. ``` python dbutils.py --version 3 upgrade ```
Author

Done. I will close it.

Done. I will close it.
Sign in to join this conversation.
No Milestone
No project
No Assignees
2 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: Hay1tsme/artemis#11
No description provided.