[GNC] Session Error: failed to get_backend using access method "C"

[Geert Janssens]

Op woensdag 1 juli 2020 18:21:03 CEST schreef Lipp F.:
> I have 3.10 installed and there is no gnucash-cli in this release. What do
> you want me to test?
> 
Reread my examples. They try to load files in gnucash.exe instead of gnucash-cli.exe :)

Regards,

Geert

> On Wed, Jul 1, 2020 at 12:18 PM Geert Janssens <geert.gnucash at kobaltwit.be>
> 
> wrote:
> > Op woensdag 1 juli 2020 17:52:48 CEST schreef Lipp F.:
> > > It is a bug indeed. Standard Windows path works fine in some parts of
> > > the
> > > 
> > > code but not everywhere. You can see the book file loaded and identified
> > 
> > as
> > 
> > > sqlite3. See logs below.
> > 
> > While the logs may lead to that conclusion I'm not so sure that is really
> > the case.
> > 
> > 
> > 
> > When a file is loaded (as opposed to a URI for an actual database server)
> > gnucash doesn't know beforehand what type of data is in there. So it will
> > ask each backend in turn (sqlite3 or xml). The logs show the sqlite3
> > backend trying to find the file. But that's before it can determine
> > whether
> > the file is really sqlite3. On successful loading (which didn't happen
> > here), the first thing the backend would do is evaluate whether it can
> > parse the file. If not, just backs off and passes the file to the next
> > available backend (which would be xml). However in this case the backend
> > failed to even locate the file, so it aborts file loading with an error.
> > 
> > 
> > 
> > Back to the issue though. I asked you whether you see the same thing if
> > you try to load the file in gnucash rather than gnucash-cli (I would
> > expect
> > so), and whether this already is the case on gnucash 3.x. I would like to
> > know to determine whether it's a regression or a long-standing bug. That
> > helps when trying to fix it.
> > 
> > 
> > 
> > My example commands were a little mixed up unfortunately. Here they are
> > again:
> > 
> > 
> > 
> > C:\tools\gnucash\bin>gnucash.exe /C/Users/*****/Downloads/gnuCash-test-2/
> > 
> > t14.sqlite3.gnucash
> > 
> > 
> > 
> > C:\tools\gnucash\bin>gnucash.exe C:\Users\*****\Downloads\gnuCash-
> > 
> > test-2\t14.sqlite3.gnucash
> > 
> > 
> > 
> > Note there's an additional format you can use to pass file names. You can
> > try:
> > 
> > sqlite3:///c/Users/*****/Downloads.gnucash-test-2/t14.sqlite3.gnucash
> > 
> > or perhaps
> > 
> > sqlite3://c:\Users\*****\Downloads.gnucash-test-2\t14.sqlite3.gnucash
> > 
> > 
> > 
> > I can't test right now myself which one is the exact right one.
> > 
> > 
> > 
> > Regards,
> > 
> > 
> > 
> > Geert
> > 
> > > C:\tools\gnucash\bin>gnucash-cli.exe --debug --report run --name="Net
> > 
> > Worth
> > 
> > > Linechart" --output-file=r-nwl.html
> > > 
> > > 'C:\Users\******\Downloads\gnuCash-test-2\t14.sqlite3.gnucash'
> > > 
> > > * 11:46:50 INFO <gnc.backend.dbi> [gnc_module_init_backend_dbi]
> > > 
> > > GNC_DBD_DIR not set: using libdbi built-in default
> > > 
> > > * 11:46:51 INFO <gnc.backend.dbi> [gnc_module_init_backend_dbi] 3 DBD
> > > 
> > > drivers found
> > > 
> > > * 11:46:51 INFO <gnc.backend.dbi> [gnc_module_init_backend_dbi] Driver:
> > > 
> > > mysql
> > > 
> > > * 11:46:51 INFO <gnc.backend.dbi> [gnc_module_init_backend_dbi] Driver:
> > > 
> > > pgsql
> > > 
> > > * 11:46:51 INFO <gnc.backend.dbi> [gnc_module_init_backend_dbi] Driver:
> > > 
> > > sqlite3
> > > 
> > > * 11:46:51 INFO <gnc.gui> [Gnucash::CoreApp::start] System locale
> >