The problem seems to be that the column "message_id' (table "mail_message") is a string but you gave it an integer.
It should'nt be WHERE (mail_message."message_id" in (134060)) but: WHERE (mail_message."message_id" in ('134060'))
So you can either :
-change the field "message_id' in the object "mail_message" (from addon "mail") but you assume that all your message_id will always contain only digits.
- or (much better) you keep "message_id" as a string but transform your integer to a string.
Hi everyone,
The problem seems to be that the column "message_id' (table "mail_message") is a string but you gave it an integer. "message_ id" in (134060)) but: WHERE (mail_message. "message_ id" in ('134060'))
It should'nt be WHERE (mail_message.
So you can either :
-change the field "message_id' in the object "mail_message" (from addon "mail") but you assume that all your message_id will always contain only digits.
- or (much better) you keep "message_id" as a string but transform your integer to a string.