Hello, please help me figure out what the issue.
I am seeing the following error log, please advise what is the issue because I couldn’t figure it out. fortunately, I am still receiving the emails but seeing this error.
This happened after updating to the version 13.20.1 from 13.20.0
Thank you
################
Title
pull_from_email_account
Error
Traceback (most recent call last):
File “apps/frappe/frappe/utils/background_jobs.py”, line 110, in execute_job
method(**kwargs)
File “apps/frappe/frappe/email/doctype/email_account/email_account.py”, line 840, in pull_from_email_account
email_account.receive()
File “apps/frappe/frappe/email/doctype/email_account/email_account.py”, line 365, in receive
raise Exception(frappe.as_json(exceptions))
Exception: [
“Traceback (most recent call last):\n File "apps/frappe/frappe/email/doctype/email_account/email_account.py", line 334, in receive\n communication = self.insert_communication(msg, args=args)\n File "apps/frappe/frappe/email/doctype/email_account/email_account.py", line 420, in insert_communication\n frappe.db.set_value("Communication", name, "uid", uid, update_modified=False)\n File "apps/frappe/frappe/database/database.py", line 703, in set_value\n query.run(debug=debug)\n File "apps/frappe/frappe/query_builder/utils.py", line 59, in execute_query\n return frappe.db.sql(query, params, *args, **kwargs) # nosemgrep\n File "apps/frappe/frappe/database/database.py", line 146, in sql\n self._cursor.execute(query, values)\n File "env/lib/python3.8/site-packages/pymysql/cursors.py", line 148, in execute\n result = self._query(query)\n File "env/lib/python3.8/site-packages/pymysql/cursors.py", line 310, in _query\n conn.query(q)\n File "env/lib/python3.8/site-packages/pymysql/connections.py", line 548, in query\n self._affected_rows = self._read_query_result(unbuffered=unbuffered)\n File "env/lib/python3.8/site-packages/pymysql/connections.py", line 775, in _read_query_result\n result.read()\n File "env/lib/python3.8/site-packages/pymysql/connections.py", line 1156, in read\n first_packet = self.connection._read_packet()\n File "env/lib/python3.8/site-packages/pymysql/connections.py", line 725, in _read_packet\n packet.raise_for_error()\n File "env/lib/python3.8/site-packages/pymysql/protocol.py", line 221, in raise_for_error\n err.raise_mysql_exception(self._data)\n File "env/lib/python3.8/site-packages/pymysql/err.py", line 143, in raise_mysql_exception\n raise errorclass(errno, errval)\npymysql.err.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘b’206’ WHERE name IN (‘bb3eda09b4’)’ at line 1")\n”
]
################