I am having an issue while my user post chat he received an error which is pasted below please tell me how to resolve.
App Versions
{
“chat”: “0.0.1”,
“erpnext”: “14.0.0-dev”,
“frappe”: “14.0.0-dev”,
“frappe_whatsapp”: “0.0.1”,
“hrms”: “1.0.0”,
“payments”: “0.0.1”
}
Route
Form/Task/TASK-2022-00125
Trackeback
Traceback (most recent call last):
File “apps/frappe/frappe/app.py”, line 56, in application
response = frappe.api.handle()
File “apps/frappe/frappe/api.py”, line 53, in handle
return _RESTAPIHandler(call, doctype, name).get_response()
File “apps/frappe/frappe/api.py”, line 69, in get_response
return self.handle_method()
File “apps/frappe/frappe/api.py”, line 79, in handle_method
return frappe.handler.handle()
File “apps/frappe/frappe/handler.py”, line 45, in handle
data = execute_cmd(cmd)
File “apps/frappe/frappe/handler.py”, line 83, in execute_cmd
return frappe.call(method, **frappe.form_dict)
File “apps/frappe/frappe/init.py”, line 1584, in call
return fn(*args, **newargs)
File “apps/chat/chat/api/message.py”, line 29, in send
update_room(room=room, last_message=content)
File “apps/chat/chat/utils/init.py”, line 75, in update_room
frappe.db.set_value(‘Chat Room’, room, new_values,
File “apps/frappe/frappe/database/database.py”, line 893, in set_value
query.run(debug=debug)
File “apps/frappe/frappe/query_builder/utils.py”, line 86, in execute_query
return frappe.db.sql(query, params, *args, **kwargs) # nosemgrep
File “apps/frappe/frappe/database/database.py”, line 210, in sql
self._cursor.execute(query, values)
File “env/lib/python3.10/site-packages/pymysql/cursors.py”, line 148, in execute
result = self._query(query)
File “env/lib/python3.10/site-packages/pymysql/cursors.py”, line 310, in _query
conn.query(q)
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 775, in _read_query_result
result.read()
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 1156, in read
first_packet = self.connection._read_packet()
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 725, in _read_packet
packet.raise_for_error()
File “env/lib/python3.10/site-packages/pymysql/protocol.py”, line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File “env/lib/python3.10/site-packages/pymysql/err.py”, line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.DataError: (1406, “Data too long for column ‘last_message’ at row 1”)
Request Data
{
“type”: “POST”,
“args”: {
“content”: “I am looking for a small FastAPI app to be built that works with files via Azure Blob Storage. I will need the following endpoints and anything else you think would be important: Create/Upload a new file Read/Download a file Update a file name or other data Delete File”,
“user”: “Saad”,
“room”: “CR00006”,
“email”: “saadq.technorayx@gmail.com”
},
“headers”: {},
“error_handlers”: {},
“url”: “/api/method/chat.api.message.send”
}
Response Data
{
“exception”: “pymysql.err.DataError: (1406, "Data too long for column ‘last_message’ at row 1")”
}