Unable to open sqlite3 files with 2.3.13 on Fedora 13.

[Phil Longstaff]

Type "file" covers both XML and sqlite3, so you will always see "file" in the selection list.  The list includes "postgres" if 1) you have build with dbi enabled, and 2) the postgres DBD (libdbi driver) is available.  Between 2.3.12 and 2.3.13, there was a change regarding DBD directory handling.  Since you have specified the directory explicitly, I assume it should work, but the problem may be there.

 Phil
---------
I used to be a hypochondriac AND a kleptomaniac. So I took something for it.




________________________________
From: Rick Rankin <rrankin1424-gnucash at yahoo.com>
To: gnucash-devel at gnucash.org
Sent: Mon, June 7, 2010 4:09:50 AM
Subject: Unable to open sqlite3 files with 2.3.13 on Fedora 13.

[Sorry for the repost. I accidently hit "send" before the message was complete.]

Hello,

For a while now, I've been using gnucash 2.3.x with the 
sqlite3 backend
on Fedora 64-bit systems. A few days ago, I 
downloaded and built
gnucash-2.3.13 on Fedora 13. The problem I'm 
seeing is that 2.3.13
won't open my sqlite3 database. It fails with 
the message:

    Can't parse the URL 
file:///data/register.sqlite3.

This file opens just fine with 
gnucash 2.3.12. I've used the exact same configure line for both builds:

    ./configure --prefix=/tools/local --enable-dbi 
--with-dbi-dbd-dir=/usr/lib64/dbd

If I attempt to use the File 
--> Open dialog with 2.3.13, the only format the appears in the "Data Format:" selection list is "file". With 2.3.12, I see both "file" and 
"postgres" as options.

Has something in the build process changed to enable sqlite/postgres?

I was also having some issues with 2.3.12 on 32-bit Fedora-13. I was unable to open an sqlite3 file from an NFS share. IIRC, I got the same "Can't parse" message I quoted above. When I copied the file to the local hard drive, though, I could open the file and see all my transactions, but all the transaction amounts were zero. I was getting ready to report those errors to this list when I saw that 2.3.13 had been released. I thought I'd try 2.3.13 before reporting anything against 2.3.12. Unfortunately, I'm not able to get sqlite3 to work at all in either 32-bit or 64-bit Fedora-13. Any suggestions would be appreciated.

Thanks,

--Rick

_______________________________________________
gnucash-devel mailing list
gnucash-devel at gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel