Skip to Content
This question has been flagged
sqlnullprimarykey
4 Replies
17855 Views
Avatar
sarkarsolution.surat

odoo.sql_db: bad query: b' INSERT INTO mail_message_res_partner_needaction_rel (mail_message_id, res_partner_id)\n                        (SELECT a, b FROM unnest(ARRAY[173653]) AS a, unnest(ARRAY[24]) AS b)\n                        EXCEPT (SELECT mail_message_id, res_partner_id FROM mail_message_res_partner_needaction_rel WHERE mail_message_id IN (173653))\n                    '

ERROR: null value in column "id" violates not-null constraint

DETAIL:  Failing row contains (173653, 24, null, null, null, null).


How to solve it when I send a message in chatter 

Avatar
Discard
Manish Bohra

Can you explain where you are this problem ?

sarkarsolution.surat
Author

When i try to Send message/ post message in chat

Avatar
Cyril Gaspard (GEM)
Best Answer

Hi,

try to create your record fist, by pushing the left top button "Create".

Bye

Avatar
Discard
Avatar
sarkarsolution.surat
Author Best Answer

 


When I try to send a message at that time I get an error

Avatar
Discard
Related Posts Replies Views Activity
Usage Of SQl Queries In odoo
sql
Avatar
Avatar
1
Nov 22
7879
sql constraints aren't being detected in my model
sql
Avatar
Avatar
1
Oct 21
4483
Odoo on microsoft sql server instead postgres sql?
sql
Avatar
2
Nov 18
11164
Openerp with MS-SQL
sql
Avatar
Avatar
Avatar
Avatar
4
Mar 15
6254
how can i get the date in dd mm yyyy format please help me?
sql
Avatar
Avatar
1
Mar 15
6951