Re: [Gnumed-bugs] v17 ... v19 bootstrapping and client unable to access resulting v19

[Karsten Hilbert]

On Tue, Nov 12, 2013 at 04:56:39PM +0100, Karsten Hilbert wrote:

> >     return _core_.PyApp__BootstrapApp(*args, **kwargs)
> >   File 
> > "/Users/dad/Downloads/gnumed-client.1.4.0/Gnumed/wxpython/gmGuiMain.py", 
> > line 3071, in OnInit
> >     if not self.__verify_praxis_branch():
> >   File 
> > "/Users/dad/Downloads/gnumed-client.1.4.0/Gnumed/wxpython/gmGuiMain.py", 
> > line 3283, in __verify_praxis_branch
> >     if not gmPraxisWidgets.set_active_praxis_branch(no_parent = True):
> >   File 
> > "/Users/dad/Downloads/gnumed-client.1.4.0/Gnumed/wxpython/gmPraxisWidgets.py",
> >  line 412, in set_active_praxis_branch
> >     branches = gmPraxis.get_praxis_branches()
> >   File 
> > "/Users/dad/Downloads/gnumed-client.1.4.0/Gnumed/business/gmPraxis.py", 
> > line 136, in get_praxis_branches
> >     rows, idx = gmPG2.run_ro_queries(queries = [{'cmd': cmd}], get_col_idx 
> > = True)
> >   File "/Users/dad/Downloads/gnumed-client.1.4.0/Gnumed/pycommon/gmPG2.py", 
> > line 1190, in run_ro_queries
> >     curs.execute(query['cmd'], args)
> >   File 
> > "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/psycopg2/extras.py",
> >  line 120, in execute
> >     return super(DictCursor, self).execute(query, vars)
> > psycopg2.ProgrammingError: relation "dem.v_praxis_branches" does not exist
> > LINE 1: SELECT * FROM dem.v_praxis_branches WHERE true
> 
> This means that you either connected to the wrong database (v18 ?)
> or else the v18 -> v19 upgrade failed despite saying it succeeded.
> 
> As for the latter only the log can tell as - upon checking - the
> code is clearly supposed to do the right thing.

The log you sent said that the SQL which creates the
dem.v_praxis_branches view was run properly.

Thusly you'll need to check whether that conforms to
reality by looking at the database trying to find

        dem.v_praxis_branches

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