Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
----------------------------------
any help, appreciated.
Hi,
The "duplicate key value violates unique constraint" error in Odoo, specifically related to mail_message_res_partner_id, indicates a data integrity issue where a duplicate entry is being created in the mail_message_res_partner_rel table. This often happens due to duplicate notifications, data corruption, custom modules, or mass mailing issues.
To troubleshoot, identify the specific product variant and partner involved, check for duplicate notifications in the chatter or email queue, and temporarily disable custom modules related to POs, product variants, or messaging. Access the database to run an SQL query to find and carefully remove duplicate entries in the mail_message_res_partner_rel table. Also, run a database integrity check and consider recreating the product variant. Always back up the database before making changes and seek expert help if needed.
Hope it helps
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
Validation Error
Solved
|
|
4
Jul 25
|
6627 | |
|
0
Dec 22
|
3026 | ||
|
1
Jul 22
|
20900 | ||
|
2
Mar 15
|
5627 | ||
|
2
Sep 25
|
2531 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
"Validation Error" is not a question. A question is a substantial phrase that ends with "?"
We get close to 1,000 posts a month and not everyone will open a post to find out what your question is.
I have edited your post to make the title a question.
In the future, please consider (1) using a Question that makes it clear what you ask without requiring people to open your post and (2) adding Tags. This will often increase the chances people will respond and also make everything clearer for others who may come along later searching for the same thing.
Failing that, you can paste your future posts into an AI Chatbot and ask it to "please generate a question of no more than 16 words that summarizes what I am asking" and use that as your question.
See also https://www.odoo.com/forum/help-1/meta-why-do-some-questions-get-answers-and-others-do-not-25620
Hello,
Confirm that you are not using any custom module in your database..?