Re: [Gnumed-bugs] Unhandled exception re-signing one measurement in multi-value cell

[Karsten Hilbert]

On Wed, Jul 24, 2013 at 10:06:56PM +0000, Jim Busser wrote:

> The exception seems to relate to a trigger and notification, lines 1572 - 
> 1576 which I will separately email
> 
> 2013-07-24 15:00:43  DEBUG     gm.logging 
> (/Users/djb/Downloads/gnumed-client.1.3.7/Gnumed/pycommon/gmLog2.py::log_stack_trace()
>  #170):               pg_exc = relation "dem.item_inbox_category" does not 
> exist
> LINE 1: ..._category, description ) values ( (select pk from dem.item_i...
>                                                              ^
> QUERY:  insert into dem.inbox_item_type ( fk_inbox_item_category, description 
> ) values ( (select pk from dem.item_inbox_category where description = 
> 'clinical'), 'results review change' )
> CONTEXT:  PL/pgSQL function "trf_notify_reviewer_of_review_change" line 28 at 
> SQL statement

This is fixed for 1.3.8.

For immediate relieve the attached file can be applied to a
v18 database.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

v18-clin-results_review_change-fixup.sql
Description: application/sql