Phil Longstaff wrote: > Mark Johnson wrote: > >> Here is an excerpt (including the qof_session_load_backend) from the >> resulting gnucash.trace: >> * 23:11:30 INFO <gnc.commodity> [gnc_commodity_table_insert] insert >> 0x84856e0 XAG into nsp=0x84567c0 CURRENCY >> * 23:11:30 INFO <gnc.backend> [gnc_gda_check_sqlite_file] No '.db', >> doesn't exist (errno=2) -> GDA >> * 23:11:30 INFO <qof.session> [qof_session_load_backend] selected >> GnuCash LibGDA Backend >> * 23:11:50 INFO <qof.session> [qof_session_begin] Done running >> session_begin on backend >> * 23:11:50 INFO <gnc.gui> [gnc_post_file_open] >> logpath=/mnt/raid/home/mj/.gnucash/data/books_copy_2008-01-14.xac >> * 23:11:50 INFO <gnc.account> [xaccAccountRecomputeBalance] acct= >> starting baln=0/1 >> * 23:11:50 INFO <gnc.commodity> [gnc_commodity_table_insert] insert >> 0x847eb10 AFA into nsp=0x8543f20 CURRENCY >> >> > > errno=2 is ENOENT which indicates file or directory not found. > That makes sense. The sqlite file does not exist prior to the run. > >> To test if this is simply a problem with the display of the accounts >> tab, I tried a cash flow report. Its options dialog (accounts tab) >> also showed an empty display of accounts. >> >> To summarize, I am experiencing two problems: >> 1. Reading an xml file automatically creates a sqlite file. If I >> wanted to use the xml backend, this file should not be created. >> 2. Reading an xml file fails to read (create in memory? / display) any >> accounts. >> > except it's not finding your xml file. Therefore, it's creating a blank > sqlite file with no accounts. They are both from the same basic problem. > > When you normally start gnucash, do you start with --nofile and open > it? Normally, I run 2.2.3 and just let it open my only data file. Very convenient. My test system has had previous copies of gnucash installed for testing. It's very likely that gconf has stored paths to some old files. I used --no-file to have a definite start condition.
> Can you run another version of gnucash and open this file? This is a copy of my normal data file. Version 2.2.3 opens the original just fine. I do run 2.2.3 on a different system, used only for finance/banking. I am running gnucash-gda on a test system. > What is > /mnt/raid? g_fopen() is not finding whatever file you are trying to > load, and I'm trying to figure out why. /mnt/raid is actually an NFS mount point on the system where I am running gnucash-gda. This is the same as on the system where I run gnucash 2.2.3. Both client systems are running linux kernel 2.6.22. Gnucash-gda was built with the following configure: ./configure --enable-opt-style-install \ --prefix=$HOME/gnucash-gda/gnucash.16866 \ --enable-debug --enable-error-on-warning \ --enable-gda \ --enable-compile-warnings Gnucash was built with the following configure: ./configure --prefix=/usr --sysconfdir=/etc --disable-debug --enable-binreloc > Can you run gnucash-gda and > replace --nofile with the actual file, or with xml://<filename>? > > Phil > > First try: [EMAIL PROTECTED]:~/gnucash-gda/gnucash.16866/bin$ ./gnucash --debug ../../books_copy_2008-01-14.xac This opens the file successfully. No Sqlite file is created by the open operation. Here is the qof_session_load_backend portion of the gnucash-trace file: * 21:15:50 INFO <gnc.commodity> [gnc_commodity_table_insert] insert 0x843d6e8 XAG into nsp=0x8427260 CURRENCY * 21:15:50 INFO <gnc.backend> [gnc_gda_check_sqlite_file] No '.db', exists -> not GDA * 21:15:50 INFO <qof.session> [qof_session_load_backend] GnuCash LibGDA Backend not usable * 21:15:50 INFO <qof.session> [qof_session_load_backend] selected GnuCash File Backend Version 2 * 21:15:50 INFO <qof.session> [qof_session_begin] Done running session_begin on backend * 21:15:50 INFO <gnc.gui> [gnc_post_file_open] logpath=/mnt/raid/home/mj/gnucash-gda/gnucash.16866/bin/../../books_copy_2008-01-14.xac * 21:15:50 INFO <gnc.account> [xaccAccountRecomputeBalance] acct= starting baln=0/1 * 21:15:50 INFO <gnc.commodity> [gnc_commodity_table_insert] insert 0x83e7820 AFA into nsp=0x84272c0 CURRENCY Second try: [EMAIL PROTECTED]:~/gnucash-gda/gnucash.16866/bin$ ./gnucash --debug xml:///mnt/raid/home/mj/gnucash-gda/books_copy_2008-01-14.xac This opens the file successfully. No Sqlite file is created by the open operation. And the excerpt from this run's gnucash-trace: * 21:19:30 INFO <gnc.commodity> [gnc_commodity_table_insert] insert 0x84427d0 XAG into nsp=0x8416200 CURRENCY * 21:19:30 INFO <qof.session> [qof_session_load_backend] selected GnuCash File Backend Version 2 * 21:19:30 INFO <qof.session> [qof_session_begin] Done running session_begin on backend * 21:19:30 INFO <gnc.gui> [gnc_post_file_open] logpath=///mnt/raid/home/mj/gnucash-gda/books_copy_2008-01-14.xac * 21:19:30 INFO <gnc.account> [xaccAccountRecomputeBalance] acct= starting baln=0/1 * 21:19:30 INFO <gnc.commodity> [gnc_commodity_table_insert] insert 0x842c7f0 AFA into nsp=0x8443820 CURRENCY So starting with the file on the command line runs fine, but --no-file followed by the File Open dialog has problems. Mark _______________________________________________ gnucash-devel mailing list [email protected] https://lists.gnucash.org/mailman/listinfo/gnucash-devel
