Odoo Server (MOVED TO GITHUB)

WARNING when you try to update some module

Asked by Nhomar - Vauxoo

[2010-03-11 06:33:56,067] WARNING:orm:[01]: unable to add 'unique(res_id, user_id)' constraint on table ir_ui_view_sc !
[2010-03-11 06:33:56,067] WARNING:orm:[02]: If you want to have it, you should update the records and execute manually:
[2010-03-11 06:33:56,067] WARNING:orm:[03]: ALTER table ir_ui_view_sc ADD CONSTRAINT ir_ui_view_sc_shortcut_unique unique(res_id, user_id)

This Warning appear when you use -u module -d db_name.

somebody can explain a little, what does it means? and what are the concecuences if you dont make this ALTER TABLE command!

Thx

Question information

Language:
English Edit question
Status:
Solved
For:
Odoo Server (MOVED TO GITHUB) Edit question
Assignee:
No assignee Edit question
Solved by:
Nhomar - Vauxoo
Solved:
Last query:
Last reply:
Revision history for this message
Jay Vora (Serpent Consulting Services) (jayvora) said : 		#1

Hello Nhomar,

This warning is regarding Shortcuts.
There is an added sql constraint that the user can add a shortcut once. In easy words, a unique pair or user and action.

Once a shortcut added by a user, can not be added again.

Thanks.

Revision history for this message
Nhomar - Vauxoo (nhomar) said : 		#2

Ok...

Thanks for the quick answer Jay.

;-)