[Health] GNU HEALTH 2.6.1 ERROR when running ./trytond --database=dname --Update=all

[Bounmy Sihaphom]

Hi all!

Just follow all steps necessary to update GNUhealth from 2.4 to 2.6.1, i am running into the error as follow:

[Fri Aug 01 22:34:52 2014] WARNING:init:unable to add 'UNIQUE(code, institution)' constraint on table gnuhealth_hospital_building !
If you want to have it, you should update the records and execute manually:
ALTER table "gnuhealth_hospital_building" ADD CONSTRAINT "gnuhealth_hospital_building_code_uniq" UNIQUE(code, institution)
Traceback (most recent call last):
  File "./trytond", line 113, in <module>
    trytond.server.TrytonServer(options).run()
  File "/home/gnuhealth/gnuhealth/tryton/server/trytond-3.2.1/trytond/server.py", line 123, in run
    Pool(db_name).init(update=update, lang=lang)
  File "/home/gnuhealth/gnuhealth/tryton/server/trytond-3.2.1/trytond/pool.py", line 151, in init
    lang=lang)
  File "/home/gnuhealth/gnuhealth/tryton/server/trytond-3.2.1/trytond/modules/__init__.py", line 428, in load_modules
    _load_modules()
  File "/home/gnuhealth/gnuhealth/tryton/server/trytond-3.2.1/trytond/modules/__init__.py", line 396, in _load_modules
    load_module_graph(graph, pool, lang)
  File "/home/gnuhealth/gnuhealth/tryton/server/trytond-3.2.1/trytond/modules/__init__.py", line 237, in load_module_graph
    cls.__register__(module)
  File "/home/gnuhealth/gnuhealth/tryton/server/trytond-3.2.1/trytond/model/modelsql.py", line 146, in __register__
    table.add_constraint(ident, constraint)
  File "/home/gnuhealth/gnuhealth/tryton/server/trytond-3.2.1/trytond/backend/postgresql/table.py", line 395, in add_constraint
    self._update_definitions()
  File "/home/gnuhealth/gnuhealth/tryton/server/trytond-3.2.1/trytond/backend/postgresql/table.py", line 128, in _update_definitions
    (self.table_name,))
  File "/home/gnuhealth/gnuhealth/tryton/server/trytond-3.2.1/trytond/backend/postgresql/database.py", line 309, in execute
    return self.cursor.execute(sql, params)
psycopg2.InternalError: current transaction is aborted, commands ignored until end of transaction block

OS: Ubuntu 12.04.

Any help is appreciated.Thanks in advance.

Best Regards;

Bounmy Sihaphom

Calat factory Co. Ltd.

Ban Nahai,Hatsaiphong District,Vientiane ,Laos

Mobile:020-5663 6285

mail. address@hidden

Disclaimer:

Confidential information may be contained in this message and may be subject to legal privilege. Access to this e-mail by anyone other than the intended is unauthorized. If you are not the intended recipient (or responsible for delivery of the message to such person), you may not use, copy, distribute or deliver to anyone this message (or any part of its contents ) or take any action in reliance on it. In such case, you should destroy this message, and notify us immediately. 

On Wed, Jul 30, 2014 at 11:44 AM, Bounmy Sihaphom <address@hidden> wrote:

Hi all!

Maybe some can help us solving the filter or search function at Prescription Line, when Dr. search a medicament by pressing letter A, he/she expect the medicament starting with a letter A comes up, but it doesn't, all he saw is Search or create, even he knows there are many medicament on the list start with a letter A.

Any help is appreciated. 

Best Regards;

Bounmy Sihaphom

Calat factory Co. Ltd.

Ban Nahai,Hatsaiphong District,Vientiane ,Laos

Mobile:020-5663 6285

mail. address@hidden

Disclaimer:

Confidential information may be contained in this message and may be subject to legal privilege. Access to this e-mail by anyone other than the intended is unauthorized. If you are not the intended recipient (or responsible for delivery of the message to such person), you may not use, copy, distribute or deliver to anyone this message (or any part of its contents ) or take any action in reliance on it. In such case, you should destroy this message, and notify us immediately. 

On Wed, Jul 23, 2014 at 8:05 PM, Luis Falcon <address@hidden> wrote:

Team,

I just updated the Amsterdam community server with patchset 2.6.1 .

Please login and check that everything goes smoothly . If so, tonight
we'll release the patchset itself, along with the full version, and the
demo database.

Best,

Luis