Not for me. Getting another error now. C:\tools\gnucash\bin>gnucash-cli.exe --debug --report run --name="Net Worth Linechart" --output-file=r-nwl.html 'sqlite3://C:\Users\******\Downloads\gnuCash-test-2\t14.sqlite3.gnucash'
* 14:46:12 INFO <gnc.backend.dbi> [gnc_module_init_backend_dbi] GNC_DBD_DIR not set: using libdbi built-in default * 14:46:12 INFO <gnc.backend.dbi> [gnc_module_init_backend_dbi] 3 DBD drivers found * 14:46:12 INFO <gnc.backend.dbi> [gnc_module_init_backend_dbi] Driver: mysql * 14:46:12 INFO <gnc.backend.dbi> [gnc_module_init_backend_dbi] Driver: pgsql * 14:46:12 INFO <gnc.backend.dbi> [gnc_module_init_backend_dbi] Driver: sqlite3 * 14:46:12 INFO <gnc.gui> [Gnucash::CoreApp::start] System locale returned (null) * 14:46:12 INFO <gnc.gui> [Gnucash::CoreApp::start] Effective locale set to English_United States.1252. * 14:46:13 INFO <gnc.engine> [gnc_hook_num_args] no hook lists * 14:46:13 MESSG <gnc.report.core> loading saved reports * 14:46:13 MESSG <gnc.report.core> loading stylesheets * 14:46:13 INFO <gnc.app-utils.gsettings> [gnc_gsettings_register_cb] schema: general, key: retain-days, settings_ptr: 04d04078, handler_id: 1 * 14:46:13 INFO <gnc.app-utils.gsettings> [gnc_gsettings_register_cb] schema: general, key: retain-type-never, settings_ptr: 04d04078, handler_id: 2 * 14:46:13 INFO <gnc.app-utils.gsettings> [gnc_gsettings_register_cb] schema: general, key: retain-type-days, settings_ptr: 04d04078, handler_id: 3 * 14:46:13 INFO <gnc.app-utils.gsettings> [gnc_gsettings_register_cb] schema: general, key: retain-type-forever, settings_ptr: 04d04078, handler_id: 4 * 14:46:13 INFO <gnc.app-utils.gsettings> [gnc_gsettings_register_cb] schema: general, key: file-compression, settings_ptr: 04d04078, handler_id: 5 * 14:46:13 INFO <gnc.gui> [scm_run_report] Loading datafile 'sqlite3://C:\Users\******\Downloads\gnuCash-test-2\t14.sqlite3.gnucash'... * 14:46:13 INFO <gnc.account> [xaccAccountRecomputeBalance] acct=Template Root starting baln=0/1 * 14:46:13 INFO <gnc.commodity> [gnc_commodity_table_insert] insert 070cb578 template into nsp=06e461a0 template * 14:46:13 INFO <gnc.commodity> [gnc_commodity_table_insert] insert 0960d550 ADF into nsp=06e46220 CURRENCY * 14:46:13 INFO <gnc.commodity> [gnc_commodity_table_insert] insert 0960d4e0 ADP into nsp=06e46220 CURRENCY .............. * 14:46:22 INFO <gnc.commodity> [gnc_commodity_table_insert] insert 08e390a0 XPT into nsp=06e46220 CURRENCY * 14:46:22 INFO <gnc.commodity> [gnc_commodity_table_insert] insert 08e39110 XSU into nsp=06e46220 CURRENCY * 14:46:22 INFO <qof.session> [QofSessionImpl::load_backend] Selected provider GnuCash Libdbi (SQLITE3) Backend * 14:46:22 INFO <gnc.backend.dbi> [QofDbiBackendProvider<Type>::type_check] doesn't exist (errno=22) -> DBI terminate called after throwing an instance of 'std::logic_error' what(): basic_string::_M_construct null not valid And same error for for getting quotes: C:\tools\gnucash\bin\gnucash-cli.exe --quotes get 'sqlite3://C:\Users\******\Downloads\gnuCash-test-2\t14.sqlite3.gnucash' On Wed, Jul 1, 2020 at 1:40 PM Chris Graves <mohaveba...@gmail.com> wrote: > Sorry, my bad. I can duplicate your failure. Does look like a bug. > However, this works: > > 'C:\Program Files (x86)\gnucash\bin\gnucash-cli.exe' --report run > --name='Net Worth Linechart' --output=rpt.html > 'sqlite3://C:\Users\chris\Documents\sqlite.gnucash' > > On Wed, Jul 1, 2020 at 9:56 AM Lipp F. <flipp...@gmail.com> wrote: > >> As long as the path to the book file does not have a directory, >> everything works fine. I mentioned that in an earlier message. >> >> On Wed, Jul 1, 2020 at 12:30 PM Chris Graves <mohaveba...@gmail.com> >> wrote: >> >>> Just as a point of reference, running the report on Win 10 from >>> Powershell works fine for me with GC files of XML and Sqlite3. >>> >>> 'C:\Program Files (x86)\gnucash\bin\gnucash-cli.exe' --report run >>> --name='Net Worth Linechart' --output=rpt.html sqlite.gnucash >>> >>> Chris >>> >>> On Wed, Jul 1, 2020 at 9:20 AM Geert Janssens < >>> geert.gnuc...@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 >>>> 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. >>>> >>> _______________________________________________ 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.
