Re: <bug>: ich suchte nach der Telefonnummer

[Karsten Hilbert]

Dear Eberhard,

thanks for your report. As you did not provide an email address

> sender email  : <bitte geben Sie Ihre E-Mail-Adresse ein>

we can only answer via the bugs mailing list.

The problem you encountered:

> 2019-11-03 17:24:04  DEBUG     gm.gui        [140166760843072 MainThread]  
> (/usr/share/gnumed/Gnumed/wxpython/gmExceptionHandlingWidgets.py::handle_uncaught_exception_wx()
>  #252): unhandled exception caught:
> Traceback (most recent call last):
>   File "/usr/share/gnumed/Gnumed/wxpython/gmGuiMain.py", line 2959, in 
> __on_search_emr
>     return gmNarrativeWorkflows.search_narrative_in_emr(parent=self)
>   File "/usr/share/gnumed/Gnumed/wxpython/gmNarrativeWorkflows.py", line 313, 
> in search_narrative_in_emr
>     rows = emr.search_narrative_simple(val)
>   File "/usr/share/gnumed/Gnumed/business/gmClinicalRecord.py", line 981, in 
> search_narrative_simple
>     {'cmd': cmd, 'args': {'pat': self.pk_patient, 'term': search_term}}
>   File "/usr/share/gnumed/Gnumed/pycommon/gmPG2.py", line 1754, in 
> run_ro_queries
>     curs.execute(query['cmd'], args)
>   File "/usr/lib/python2.7/dist-packages/psycopg2/extras.py", line 144, in 
> execute
>     return super(DictCursor, self).execute(query, vars)
> ProgrammingError: relation "clin.v_narrative4search" does not exist
> LINE 14:    from clin.v_narrative4search vn4s
>                  ^

while doing

> user comment  : ich suchte nach der Telefonnummer

is due to a missing view in the database. This issue had
popped up before and was fixed by this commit:

        commit 50bdcb2341e2971a85fa1b2e820a247ba4e9674b
        Author: Karsten Hilbert <address@hidden>
        Date:   Mon Mar 18 15:47:29 2019 +0100

            Fix exception on searching across all EMRs

                    During the v21->v22 upgrade the clin.v_narrative4search
                    view got lost. Adding it back in will modify the database
                    hash which is not very opportune now that 1.7 is to be in
                    the next Debian stable. Now, we can always create the
                    needed view as a TEMPORARY one just before running the
                    search query :)

which was included in 1.7.6:

        FIX: searching across all EMRs

The fix failed to appreciate, however, the fact that said
view might be used elsewhere, too. One of which places you
just found.

This will be fixed in the 1.7.8 release.

Best,
Karsten
--
GPG  40BE 5B0E C98E 1713 AFA6  5BC0 3BEA AC80 7D4F C89B