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-gnuc...@yahoo.com>
To: gnucash-devel@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@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
_______________________________________________
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Reply via email to