Skip to Content
Menu
This question has been flagged

Hi, i hope all its fine , i want to ask you about this issue :

psycopg2.IntegrityError: duplicate key value violates unique constraint "res_groups_name_uniq"

DETAIL: Key (name)=(Finance / Accountant) already exists

sql:bad query: UPDATE "res_groups" SET "name"='Finance / Accountant',write_uid=1,write_date=now() WHERE id IN (49)

thats ocurs when i run my openerp server with parameter --update=all. I chage the database structure ON UPDATE NO ACTION, for ON UPDATE CASCADE on tables res_groups y ir_ui_menu_group_rel. The result its the same. The thing is Finance / Accountant = 49 on table res_groups,with constraint res_groups_name_uniq.

In res_group_id_seq the number its updated  start on 50, latter 51 when i run again  openerp-server.py  --config=/...rute/openerp-server.conf --update=all

regards.

Avatar
Discard
Related Posts Replies Views Activity
1
Mar 15
5943
0
Mar 15
2869
3
Mar 15
5827
2
Mar 15
7484
0
May 24
230