Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

إدارة علاقات العملاء
e-Commerce
المحاسبة
المخزون
PoS
المشروع
MRP

All apps

كافة المنشورات الأفراد الشارات

علامات التصنيف (عرض الكل)

odoo accounting v14 pos v15

حول هذا المنتدى

المساعدة

duplicate key value violates unique constraint

odoo16features

1 الرد

5136 أدوات العرض

Willie Vermeulen

Good day,

after removal of a module, i cant install a new module and i get the following message:

The operation cannot be completed: duplicate key value violates unique constraint "res_partner_pkey"

DETAIL: Key (id)=(113) already exists.

So ive tried to figure out how to fix it including

ALTER SEQUENCE res_partner_id_seq RESTART WITH 300;

Is there anyone that can possibly tell me what im supposed to check or change to changes it so a new module will start on a different index?

Thank you!

Cybrosys Techno Solutions Pvt.Ltd

Hi,

Identify the conflict:
You need to determine why there is a conflict with the value 113 in the "id" column. This could be due to a previous record that wasn't properly removed or some other issue. You should find out which record has an "id" of 113.

Resolve the conflict:
Once you've identified the conflicting record, you'll need to decide how to resolve it. You might need to delete the conflicting record if it's no longer needed or update it to have a different "id" value.

Restart the sequence:
If you've deleted the conflicting record and want to start the sequence from a different index, you can use the ALTER SEQUENCE command as you mentioned. For example, if you want to start the sequence from 300, you can execute the SQL command

Hope it helps

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!

أنشئ حساباً اليوم لتستمتع بالخصائص الحصرية، وتفاعل مع مجتمعنا الرائع!

تسجيل

المنشورات ذات الصلة	الردود	أدوات العرض
DeprecationWarning: The longpolling-port is a deprecated alias to the gevent-port option, please use the latter تم الحل odoo16features	5 سبتمبر 25	25267
How to Add wizard under print button inside the form view. odoo16features	3 أغسطس 25	3854
How to add @api.onchange in _get_view() method odoo 16 odoo16features	1 مايو 25	3750
get all partners which are internal users or portal users odoo16 odoo16features	1 أبريل 25	4604
How to add decoration color green with bold to a record with a single conditon odoo16features	1 أبريل 25	5425

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!