Hi Everyone,
I am trying to upgrade from v2.2.2 to v2.4.1 and I have generated this error:-
[Sun Apr 20 12:22:52 2014] WARNING:init:unable to add 'UNIQUE(name)' constraint on table gnuhealth_healthprofessional !
If you want to have it, you should update the records and execute manually:
ALTER table "gnuhealth_healthprofessional" ADD CONSTRAINT "gnuhealth_healthprofessional_hp_uniq" UNIQUE(name)
Traceback (most recent call last):
File "/usr/local/bin/trytond", line 111, in <module>
trytond.server.TrytonServer(options).run()
File "/usr/local/lib/python2.6/dist-packages/trytond/server.py", line 124, in run
Pool(db_name).init(update=update, lang=lang)
File "/usr/local/lib/python2.6/dist-packages/trytond/pool.py", line 151, in init
lang=lang)
File "/usr/local/lib/python2.6/dist-packages/trytond/modules/__init__.py", line 399, in load_modules
load_module_graph(graph, pool, lang)
File "/usr/local/lib/python2.6/dist-packages/trytond/modules/__init__.py", line 235, in load_module_graph
cls.__register__(module)
File "/usr/local/lib/python2.6/dist-packages/trytond/modules/health/health.py", line 238, in __register__
super(HealthProfessional, cls).__register__(module_name)
File "/usr/local/lib/python2.6/dist-packages/trytond/model/modelsql.py", line 141, in __register__
table.add_constraint(ident, constraint)
File "/usr/local/lib/python2.6/dist-packages/trytond/backend/postgresql/table.py", line 395, in add_constraint
self._update_definitions()
File "/usr/local/lib/python2.6/dist-packages/trytond/backend/postgresql/table.py", line 128, in _update_definitions
(self.table_name,))
File "/usr/local/lib/python2.6/dist-packages/trytond/backend/postgresql/database.py", line 309, in execute
return self.cursor.execute(sql, params)
How do I resolve it?
Thank you in advance and please have a holy and peaceful Easter,
Shane.