DataError: (1406, u"Data too long for column ‘title’ at row 1")
screenshot !
{‘retry’: 0, ‘log’: <function log at 0x7fed000ac230>, ‘site’: u’example.com’, ‘event’: None, ‘method_name’: u’frappe.utils.global_search.sync_global_search’, ‘method’: <function sync_global_search at 0x7fed009a6de8>, ‘user’: u’Jay’, ‘kwargs’: {‘flags’: [{‘name’: u’9c958772ef’, ‘title’: u’Test Server ready, Now I waiting for exp Dump data from Bank. Once I receive the dump data from Bank. Then I will import the comp’, ‘route’: None, ‘doctype’: u’Communication’, ‘content’: u’Subject : Test Server ready, Now I waiting for exp Dump data from Bank. Once I receive the dump data from Bank. Then I will import the comp ||| From : Jay’, ‘published’: 0}]}, ‘async’: True, ‘job_name’: u’frappe.utils.global_search.sync_global_search’}
Traceback (most recent call last):
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/background_jobs.py”, line 95, 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 166, in sql
self._cursor.execute(query, values)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/cursors.py”, line 165, in execute
result = self._query(query)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/cursors.py”, line 321, in _query
conn.query(q)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py”, line 860, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py”, line 1061, in _read_query_result
result.read()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py”, line 1349, in read
first_packet = self.connection._read_packet()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py”, line 1018, in _read_packet
packet.check_error()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py”, line 384, in check_error
err.raise_mysql_exception(self._data)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/err.py”, line 107, in raise_mysql_exception
raise errorclass(errno, errval)
DataError: (1406, u"Data too long for column ‘title’ at row 1")
Try to use Small Text field type for title field
Ok.
Will there be a maybe increase the title size somewhere in database and fix this issue?
Please advise.