Re: [Health] Question to local hosted demo database. Error column a.lab_confirmed does not exists

[EURAFRI Networking - Karl]

Hello Luis!

Thank you for your answer. I tried to run things as suggested, but got:



~/gnuhealth/tryton/server/trytond-5.0.25/bin $ ./trytond-admin --all
--database=hdemo02
1014 139994618644288 [2020-08-11 13:23:25,229] ERROR trytond.convert
Could not delete id: 12 of model res.user
There should be some relation that points to this resource
You should manually fix this and restart --update=module
Traceback (most recent call last):
  File
"/home/hdemo02/gnuhealth/tryton/server/trytond-5.0.25/trytond/convert.py",
line 797, in post_import
    Model.delete([Model(db_id)])
  File
"/home/hdemo02/gnuhealth/tryton/server/trytond-5.0.25/trytond/res/user.py",
line 414, in delete
    cls.raise_user_error('delete_forbidden')
  File
"/home/hdemo02/gnuhealth/tryton/server/trytond-5.0.25/trytond/error.py",
line 74, in raise_user_error
    raise UserError(error)
trytond.exceptions.UserError: Users can not be deleted for logging purpose.
Instead you must inactivate them. -
1014 139994618644288 [2020-08-11 13:23:25,237] ERROR trytond.convert
Could not delete id: 11 of model res.user
There should be some relation that points to this resource
You should manually fix this and restart --update=module
Traceback (most recent call last):
  File
"/home/hdemo02/gnuhealth/tryton/server/trytond-5.0.25/trytond/convert.py",
line 797, in post_import
    Model.delete([Model(db_id)])
  File
"/home/hdemo02/gnuhealth/tryton/server/trytond-5.0.25/trytond/res/user.py",
line 414, in delete
    cls.raise_user_error('delete_forbidden')
  File
"/home/hdemo02/gnuhealth/tryton/server/trytond-5.0.25/trytond/error.py",
line 74, in raise_user_error
    raise UserError(error)
trytond.exceptions.UserError: Users can not be deleted for logging purpose.
Instead you must inactivate them. -
1014 139994618644288 [2020-08-11 13:23:25,251] ERROR trytond.convert
Could not delete id: 13 of model res.user
There should be some relation that points to this resource
You should manually fix this and restart --update=module
Traceback (most recent call last):
  File
"/home/hdemo02/gnuhealth/tryton/server/trytond-5.0.25/trytond/convert.py",
line 797, in post_import
    Model.delete([Model(db_id)])
  File
"/home/hdemo02/gnuhealth/tryton/server/trytond-5.0.25/trytond/res/user.py",
line 414, in delete
    cls.raise_user_error('delete_forbidden')
  File
"/home/hdemo02/gnuhealth/tryton/server/trytond-5.0.25/trytond/error.py",
line 74, in raise_user_error
    raise UserError(error)
trytond.exceptions.UserError: Users can not be deleted for logging purpose.
Instead you must inactivate them. -


Greetings Karl

Am 11.08.20 um 14:22 schrieb Luis Falcon:
> Hi Karl
> 
> On Tue, 11 Aug 2020 10:55:47 +0200
> EURAFRI Networking - Karl <karl@eurafri.com> wrote:
> 
>> Hello,
>>
>> based on the request them, we have setup some demo instances for our
>> ambassadors in Africa to show GNU Health to the people. Everything
>> looks great till now.
> 
> Thank you for the feedback, and happy to know that things are rolling :)
>>
>> We build a auto reset demo instances behind separated OpenVPN VPN
>> Servers and load your demo database V 36 on the 3.6.4 system.
>>
>> Currently we only have this
>>
>>>>> Error: column a.lab_confirmed does not exists<<<  
>>
> 
> Make sure you update the the DB instance with the latest kernel.
> 
> ./trytond-admin --all --database=name_of_your_db
>       
> and restart the instance.
> 
> That should solve the issue.
> 
>> error when clicking on Lab Test Results  the first time. Would be nice
>> to adopt the database so it goes away.
>>
>> Searched the list, but found nothing.
>>
>> Happens on Linux Tryton Client 5.0.x on Debian and on 5.0.x Client on
>> Windows 10.
> 
> You would get the best from the native GNU Health client, on GNU/Linux
> or BSD machines. You can download it from pypi
> (https://pypi.org/project/gnuhealth-client/)
> 
> 
> Let us know how it goes.
> 
> ALl the best
> Luis
> 

-- 
--
Best regards,

Karl
EURAFRI.com

https://EURAFRI.com
karl@eurafri.com