Re: [Gnumed-bugs] <bug>: error

[Karsten Hilbert]

Hello un,

thanks for your report.

> user comment  : error
> 
> client version: 1.6.5
...
> 2017-10-24 00:43:55  INFO      gm.launcher (<string>::log_startup_info() 
> #326): os.getcwd(): 
> [C:\a_portable\1\2\3\4\portable_apps\PortableApps\GNUmed-client\App\GNUmed]

You are running GNUmed as a portable app, which is only
available as version 1.6.5 (which is missing 10 minor bug fix
releases (so you may be happier using the latest direct
release). I am CC'ing our portable app package maintainer for
good measure.

The problem you see

> 2017-10-24 00:44:05  ERROR     gm.db 
> (D:\workplace\gnumed-client.1.6.5\build\pyi.win32\gnumed\outPYZ1.pyz\Gnumed.pycommon.gmPG2::run_ro_queries()
>  #1549): query failed: [select md5(gm.concat_table_structure(21::integer)) as 
> md5]
> 2017-10-24 00:44:05  ERROR     gm.db 
> (D:\workplace\gnumed-client.1.6.5\build\pyi.win32\gnumed\outPYZ1.pyz\Gnumed.pycommon.gmPG2::run_ro_queries()
>  #1553): PG error code: 42883
> 2017-10-24 00:44:05  ERROR     gm.db 
> (D:\workplace\gnumed-client.1.6.5\build\pyi.win32\gnumed\outPYZ1.pyz\Gnumed.pycommon.gmPG2::run_ro_queries()
>  #1555): PG error message: ERROR:  function 
> gm.concat_table_structure(integer) does not exist
> LINE 1: select md5(gm.concat_table_structure(21::integer)) as md5
>                    ^
> HINT:  No function matches the given name and argument types. You might need 
> to add explicit type casts.

happens because your local gnumed_v21 database

> 2017-10-24 00:44:04  INFO      gm.ui 
> (D:\workplace\gnumed-client.1.6.5\build\pyi.win32\gnumed\outPYZ1.pyz\Gnumed.wxpython.gmAuthWidgets::GetLoginInfo()
>  #740): backend profile "GNUmed database on this machine ("TCP/IP": 
> Windows/Linux/Mac)" selected
> 2017-10-24 00:44:04  INFO      gm.ui 
> (D:\workplace\gnumed-client.1.6.5\build\pyi.win32\gnumed\outPYZ1.pyz\Gnumed.wxpython.gmAuthWidgets::GetLoginInfo()
>  #747):  details: <any-doc> on address@hidden:5432 (UTF8, public)

does not contain the function "gm.concat_table_structure(integer)".

The most likely reason is that the database exists as such
but hasn't been bootstrapped to contain the GNUmed database
schema.

How was that database created ?

Eventually, when attempting to view the log file

> 2017-10-24 00:44:21  DEBUG     gm.gui 
> (D:\workplace\gnumed-client.1.6.5\build\pyi.win32\gnumed\outPYZ1.pyz\Gnumed.wxpython.gmExceptionHandlingWidgets::handle_uncaught_exception_wx()
>  #195): unhandled exception caught:
> Traceback (most recent call last):
>   File 
> "D:\workplace\gnumed-client.1.6.5\build\pyi.win32\gnumed\outPYZ1.pyz\Gnumed.wxpython.gmExceptionHandlingWidgets",
>  line 485, in _on_view_log_button_pressed
>   File 
> "D:\workplace\gnumed-client.1.6.5\build\pyi.win32\gnumed\outPYZ1.pyz\Gnumed.pycommon.gmMimeLib",
>  line 320, in call_viewer_on_file

GNUmed encounters an exception which Windows prides itself to
throw (WindowsError, subclass of OSError) when unable to
import a module -- which really should be mapped to
ImportError by Python (if WindowsError.winerror==126) ...

>   File "d:\workplace\pyinstaller-trunk\PyInstaller\loader\iu.py", line 449, 
> in importHook
>   File "d:\workplace\pyinstaller-trunk\PyInstaller\loader\iu.py", line 539, 
> in doimport
>   File 
> "D:\workplace\gnumed-client.1.6.5\build\pyi.win32\gnumed\outPYZ1.pyz\extractor",
>  line 39, in <module>
>   File 
> "D:\workplace\gnumed-client.1.6.5\build\pyi.win32\gnumed\outPYZ1.pyz\ctypes", 
> line 435, in __getattr__
>   File 
> "D:\workplace\gnumed-client.1.6.5\build\pyi.win32\gnumed\outPYZ1.pyz\ctypes", 
> line 365, in __init__
> WindowsError: [Error 126] The specified module could not be found

I have now enhanced GNUmed to also check for this problem.

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