Getting this error in frappe log. I can send WhatsApp messages, but unable to receive them. Am using WhatsApp Cloud API v21.0
2024-11-21 08:15:57,946 ERROR frappe Error while inserting deferred Error Log record: Error Log 5m12ho3q88: ‘Title’ ((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 '“tabWhatsApp Message” where “to” = '91XXXXXXXXX' or “from” = '91XXXXXXXXX'\n…' at line 11’)) will get truncated, as max characters allowed is 140
Site: xxx.frappe.cloud
Form Dict: {}
App Versions
{
“crm”: “1.26.0”,
“email_delivery_service”: “0.0.1”,
“erpnext”: “15.43.0”,
“exotel_integration”: “0.0.1”,
“frappe”: “15.48.0”,
“frappe_whatsapp”: “1.0.7”,
“healthcare”: “15.0.1”,
“hrms”: “15.35.2”,
“india_compliance”: “15.14.1”,
“lms”: “2.12.0”,
“payments”: “0.0.1”,
“print_designer”: “1.4.3”,
}
Traceback with variables (most recent call last):
File “apps/frappe/frappe/app.py”, line 114, in application
response = frappe.api.handle(request)
request = <Request ‘Frappe Cloud’ [POST]>
response = None
rollback = True
e = KeyError(‘entry’)
File “apps/frappe/frappe/api/init.py”, line 49, in handle
data = endpoint(**arguments)
request = <Request ‘Frappe Cloud’ [POST]>
endpoint = <function handle_rpc_call at 0x7fe0e3517b00>
arguments = {‘method’: ‘frappe_whatsapp.utils.webhook.webhook’}
File “apps/frappe/frappe/api/v1.py”, line 36, in handle_rpc_call
return frappe.handler.handle()
method = ‘frappe_whatsapp.utils.webhook.webhook’
frappe = <module ‘frappe’ from ‘apps/frappe/frappe/init.py’>
File “apps/frappe/frappe/handler.py”, line 49, in handle
data = execute_cmd(cmd)
cmd = ‘frappe_whatsapp.utils.webhook.webhook’
data = None
File “apps/frappe/frappe/handler.py”, line 85, in execute_cmd
return frappe.call(method, **frappe.form_dict)
cmd = ‘frappe_whatsapp.utils.webhook.webhook’
from_async = False
server_script = None
method = <function webhook at 0x7fe0de84e520>
File “apps/frappe/frappe/init.py”, line 1725, in call
return fn(*args, **newargs)
fn = <function webhook at 0x7fe0de84e520>
args = ()
kwargs = {‘test’: ‘message’, ‘cmd’: ‘frappe_whatsapp.utils.webhook.webhook’}
newargs = {}
File “apps/frappe/frappe/utils/typing_validations.py”, line 31, in wrapper
return func(*args, **kwargs)
args = ()
kwargs = {}
apply_condition = <function whitelist..innerfn.. at 0x7fe0de84e200>
func = <function webhook at 0x7fe0de84ede0>
File “apps/frappe_whatsapp/frappe_whatsapp/utils/webhook.py”, line 15, in webhook
return post()
File “apps/frappe_whatsapp/frappe_whatsapp/utils/webhook.py”, line 43, in post
messages = data[“entry”][“changes”][0][“value”].get(“messages”, )
data = {‘test’: ‘message’, ‘cmd’: ‘frappe_whatsapp.utils.webhook.webhook’}
messages =
builtins.KeyError: ‘entry’
This seems to have resolved on its own. I believe the problem was with Meta config, nothing to do with Frappe CRM / Frappe WhatsApp.