Re: [Gnumed-bugs] <bug>: on edit 'Verlaufsnotizen'

[Karsten Hilbert]

On Thu, Oct 08, 2015 at 06:50:45PM +0200, Marc Angermann wrote:

Thanks for reporting this problem.

> user comment  : on edit 'Verlaufsnotizen'
> 
> client version: 1.5.7

You have found a real bug (fallout from fixing the
tooltip-on-non-issue-problem bug):

> 2015-10-08 18:50:13  DEBUG     gm.gui 
> (/home/marc/gnumed/client/gnumed-client.1.5.7/Gnumed/wxpython/gmExceptionHandlingWidgets.py::handle_uncaught_exception_wx()
>  #219): unhandled exception caught:
> Traceback (most recent call last):
>   File "/usr/lib/python2.7/dist-packages/wx-2.8-gtk2-unicode/wx/_core.py", 
> line 14665, in <lambda>
>     lambda event: event.callable(*event.args, **event.kw) )
>   File 
> "/home/marc/gnumed/client/gnumed-client.1.5.7/Gnumed/wxpython/gmListWidgets.py",
>  line 472, in _set_refresh_callback_helper
>     self.refresh_callback(lctrl = self._LCTRL_items)
>   File 
> "/home/marc/gnumed/client/gnumed-client.1.5.7/Gnumed/wxpython/gmNarrativeWidgets.py",
>  line 219, in refresh
>     providers = [ gmStaff.gmCurrentProvider()['short_alias'] ]
>   File 
> "/home/marc/gnumed/client/gnumed-client.1.5.7/Gnumed/business/gmClinicalRecord.py",
>  line 551, in get_clin_narrative
>     rows, idx = gmPG2.run_ro_queries(queries = [{'cmd': cmd, 'args': args}], 
> get_col_idx = True)
>   File 
> "/home/marc/gnumed/client/gnumed-client.1.5.7/Gnumed/pycommon/gmPG2.py", line 
> 1302, in run_ro_queries
>     curs.execute(query['cmd'], args)
>   File "/usr/lib/python2.7/dist-packages/psycopg2/extras.py", line 120, in 
> execute
>     return super(DictCursor, self).execute(query, vars)
> ValueError: unsupported format character '
> ' (0xa) at index 277
> 2015-10-08 18:50:14  DEBUG     gm.logging 
> (/home/marc/gnumed/client/gnumed-client.1.5.7/Gnumed/pycommon/gmLog2.py::log_stack_trace()
>  #160): exception: unsupported format character ' ' (0xa) at index 277
> 2015-10-08 18:50:14  DEBUG     gm.logging 
> (/home/marc/gnumed/client/gnumed-client.1.5.7/Gnumed/pycommon/gmLog2.py::log_stack_trace()
>  #161): type: <type 'exceptions.ValueError'>
> 2015-10-08 18:50:14  DEBUG     gm.logging 
> (/home/marc/gnumed/client/gnumed-client.1.5.7/Gnumed/pycommon/gmLog2.py::log_stack_trace()
>  #162): list of attributes:
> 2015-10-08 18:50:14  DEBUG     gm.logging 
> (/home/marc/gnumed/client/gnumed-client.1.5.7/Gnumed/pycommon/gmLog2.py::log_stack_trace()
>  #164):   args: ("unsupported format character '\n' (0xa) at index 277",)
> 2015-10-08 18:50:14  DEBUG     gm.logging 
> (/home/marc/gnumed/client/gnumed-client.1.5.7/Gnumed/pycommon/gmLog2.py::log_stack_trace()
>  #164):   message: unsupported format character ' ' (0xa) at index 277
> 2015-10-08 18:50:14  DEBUG     gm.logging 
> (/home/marc/gnumed/client/gnumed-client.1.5.7/Gnumed/pycommon/gmLog2.py::log_stack_trace()
>  #187): stack trace follows:
...
> 2015-10-08 18:50:14  DEBUG     gm.logging 
> (/home/marc/gnumed/client/gnumed-client.1.5.7/Gnumed/pycommon/gmLog2.py::log_stack_trace()
>  #194): >>> execution frame [get_clin_narrative] in 
> [/home/marc/gnumed/client/gnumed-client.1.5.7/Gnumed/business/gmClinicalRecord.py]
>  at line 551 <<<
...
> 2015-10-08 18:50:14  DEBUG     gm.logging 
> (/home/marc/gnumed/client/gnumed-client.1.5.7/Gnumed/pycommon/gmLog2.py::log_stack_trace()
>  #209):                query = 
>                       SELECT
>                               c_vn.*,
>                               c_scr.rank AS soap_rank
>                       FROM
>                               clin.v_narrative c_vn
>                                       LEFT JOIN clin.soap_cat_ranks c_scr on 
> c_vn.soap_cat = c_scr.soap_cat

This line ...

>                       WHERE pk_patient = %(pat)s AND pk_episode IN %(epis)s 
> AND pk_encounter IN %(encs)s AND c_vn.modified_by IN %(docs)
                                                                                
                                              ^
... is lacking an 's'. Given that ...

> 2015-10-08 18:50:14  DEBUG     gm.logging 
> (/home/marc/gnumed/client/gnumed-client.1.5.7/Gnumed/pycommon/gmLog2.py::log_stack_trace()
>  #209):                 vars = {'docs': (u'MaAn',), 'epis': (12180,), u'pat': 
> 3819, 'encs': (15648,)}

... has {'docs': ...} it's _not_ a case of the ')' needing to move  (  %(doc)s  
)

Fixed and attached.

Karsten
-- 
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

gmTopPanel.py
Description: Text Data

gmClinicalRecord.py
Description: Text Data