Data too long for column 'title' at row

Hello,

I get this error when i edit my todo task form.

Any help would be appreciated, thanks.

{‘event’: None, ‘retry’: 0, ‘log’: <function log at 0x7f576260cea0>, ‘site’: ‘site1.local’, ‘job_name’: ‘frappe.utils.global_search.sync_global_search’, ‘user’:xxxxx’, ‘method_name’: ‘frappe.utils.global_search.sync_global_search’, ‘async’: True, ‘kwargs’: {‘flags’: [{‘route’: None, ‘title’: ‘

xxxxxxxx, ‘published’: 0, ‘name’: ‘3533b7cc87’}]}, ‘method’: <function sync_global_search at 0x7f5762c2d400>}
Traceback (most recent call last):
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/background_jobs.py”, line 97, in execute_job
method(**kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/global_search.py”, line 316, in sync_global_search
content = %(content)s’‘’, value)
File “/home/frappe/frappe-bench/apps/frappe/frappe/database.py”, line 199, in sql
self._cursor.execute(query, values)
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/cursors.py”, line 170, in execute
result = self._query(query)
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/cursors.py”, line 328, in _query
conn.query(q)
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/connections.py”, line 893, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/connections.py”, line 1103, in _read_query_result
result.read()
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/connections.py”, line 1396, in read
first_packet = self.connection._read_packet()
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/connections.py”, line 1059, in _read_packet
packet.check_error()
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/connections.py”, line 384, in check_error
err.raise_mysql_exception(self._data)
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/err.py”, line 109, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.DataError: (1406, “Data too long for column ‘title’ at row 1”)

Hi welcome to ERPNext,

A search turned up this that may help Data too long for column 'title' at row 1 - #3 by Ayushman_Shrestha

What change did you make and did you try to back out your change?

Hi Clarkej,

No i didn’t change anything in the form. I just completed the ToDo window and saved later on . It’s a fresh erpnewt server.

“No i didn’t change anything in the form. I just completed the ToDo window and saved later on . It’s a fresh erpnewt server.”

ok the problem is likely you are running python 3.5 and may want to switch to 2.7