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 returned > (null) > * 11:46:51 INFO <gnc.gui> [Gnucash::CoreApp::start] Effective locale set > to English_United States.1252. > * 11:46:51 INFO <gnc.engine> [gnc_hook_num_args] no hook lists > * 11:46:51 MESSG <gnc.report.core> loading saved reports > * 11:46:51 MESSG <gnc.report.core> loading stylesheets > * 11:46:51 INFO <gnc.app-utils.gsettings> [gnc_gsettings_register_cb] > schema: general, key: retain-days, settings_ptr: 01534078, handler_id: 1 > * 11:46:51 INFO <gnc.app-utils.gsettings> [gnc_gsettings_register_cb] > schema: general, key: retain-type-never, settings_ptr: 01534078, > handler_id: 2 > * 11:46:51 INFO <gnc.app-utils.gsettings> [gnc_gsettings_register_cb] > schema: general, key: retain-type-days, settings_ptr: 01534078, handler_id: > 3 > * 11:46:51 INFO <gnc.app-utils.gsettings> [gnc_gsettings_register_cb] > schema: general, key: retain-type-forever, settings_ptr: 01534078, > handler_id: 4 > * 11:46:52 INFO <gnc.app-utils.gsettings> [gnc_gsettings_register_cb] > schema: general, key: file-compression, settings_ptr: 01534078, handler_id: > 5 > * 11:46:52 INFO <gnc.gui> [scm_run_report] Loading datafile > 'C:\Users\******\Downloads\gnuCash-test-2\t14.sqlite3.gnucash'... > * 11:46:52 INFO <gnc.account> [xaccAccountRecomputeBalance] acct=Template > Root starting baln=0/1 > * 11:46:52 INFO <gnc.commodity> [gnc_commodity_table_insert] insert > 0726ec30 template into nsp=0702b1a0 template > * 11:46:52 INFO <gnc.commodity> [gnc_commodity_table_insert] insert > 097add18 ADF into nsp=0702b220 CURRENCY > * 11:46:52 INFO <gnc.commodity> [gnc_commodity_table_insert] insert > 097adcf8 ADP into nsp=0702b220 CURRENCY > * 11:46:52 INFO <gnc.commodity> [gnc_commodity_table_insert] insert > 097adc08 AED into nsp=0702b220 CURRENCY > ..................... > * 11:47:02 INFO <gnc.commodity> [gnc_commodity_table_insert] insert > 098a4228 XPD into nsp=0702b220 CURRENCY > * 11:47:02 INFO <gnc.commodity> [gnc_commodity_table_insert] insert > 098a4258 XPT into nsp=0702b220 CURRENCY > * 11:47:02 INFO <gnc.commodity> [gnc_commodity_table_insert] insert > 098a42a8 XSU into nsp=0702b220 CURRENCY > * 11:47:02 INFO <qof.session> [QofSessionImpl::load_backend] Selected > provider GnuCash Libdbi (SQLITE3) Backend > * 11:47:02 INFO <gnc.backend.dbi> > [QofDbiBackendProvider<Type>::type_check] doesn't exist (errno=5) -> DBI > * 11:47:02 WARN <gnc.backend.dbi> [GncDbiBackend<Type>::session_begin()] > Sqlite3 file 'C:\Users\******\Downloads\gnuCash-test-2\t14.sqlite3.gnucash' > not found > * 11:47:02 INFO <qof.session> [QofSessionImpl::begin] Done running > session_begin on backend > * 11:47:02 ERROR <gnc.gui> [scm_cleanup_and_exit_with_failure()] Session > Error: Sqlite3 file > 'C:\Users\******\Downloads\gnuCash-test-2\t14.sqlite3.gnucash' not found > * 11:47:02 INFO <qof.engine> [qof_collection_foreach] Hash Table size of > gncVendor before is 0 > * 11:47:02 INFO <qof.engine> [qof_collection_foreach] Hash Table size of > gncVendor after is 0 > * 11:47:02 INFO <qof.engine> [qof_collection_foreach] Hash Table size of > gncEntry before is 0 > * 11:47:02 INFO <qof.engine> [qof_collection_foreach] Hash Table size of > gncEntry after is 0 > * 11:47:02 INFO <qof.engine> [qof_collection_foreach] Hash Table size of > gncEmployee before is 0 > * 11:47:02 INFO <qof.engine> [qof_collection_foreach] Hash Table size of > gncEmployee after is 0 > * 11:47:02 INFO <qof.engine> [qof_collection_foreach] Hash Table size of > gncCustomer before is 0 _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
