Re: 2.4 and sqlite...

[Derek Atkins]

Are you sure this isn't the libdbi numeric bug?  Check the archives

-derek

----- Reply message -----
From: "Jeff Kletsky" <gnucash at allycomm.com>
Date: Fri, Dec 31, 2010 6:39 pm
Subject: 2.4 and sqlite...
To: "John Gray" <gray at agora-net.com>
Cc: "Gnucash Devel Mailing List" <gnucash-devel at gnucash.org>


I'm seeing data corruption under Ubuntu 10.10 and SQLite3 on builds from 
tag 2.4.0 -- in my case budgets are unable to display their values 
properly. I'm not seeing that using MySQL 5.1 on the same system.

If http://wiki.gnucash.org/wiki/Release_Schedule is still current, then 
I wouldn't be surprised if there are SQLite3 issues in general.

    SQL (dbi) backend with SQLite3 Generally: Still occasional reports
    about data parts which disappear when saving into sqlite, e.g.
    #627831 <https://bugzilla.gnome.org/show_bug.cgi?id=627831>;
    Database lock still needed
    <http://lists.gnucash.org/pipermail/gnucash-devel/2010-August/029177.html>;
    Linux: #611936 <https://bugzilla.gnome.org/show_bug.cgi?id=611936>,
    OSX: Stable



Jeff


On 12/31/2010 01:51 PM, John Gray wrote:
> This morning I built 2.4 from source on an x64 Ubuntu 10.10 box.  I read
> in the xml file and wrote out a sqlite file.  Everything seemed to work
> fine.
>
> Then I built 2.4 on a x86 Ubuntu 10.10 box, and it doesn't display any
> data when reading in a sqlite file.  Not the one generated on the x64
> box, or a fresh one generated from the xml.
>
> I talked someone else today who was seeing this too.
>
> We are the guys working on a version for android.  Looks like sqlite
> will be much easier to deal with under android, but its not helpful if
> it doesn't work reliably on our desktops.
>
> Speaking of the android implementation, can anybody tell me what the
> Collation on the sqlite data is? I have android reading in the sqlite,
> but something isn't just right, I suspect its a collation mismatch.  Is
> it unicode?  utf8 maybe?
>
> Thanks,
> John
> _______________________________________________
> gnucash-devel mailing list
> gnucash-devel at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
_______________________________________________
gnucash-devel mailing list
gnucash-devel at gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel