[GNC] save as sqlite3 error
Public Address
public.address at hotmail.co.uk
Fri Oct 22 08:52:18 EDT 2021
Thanks, interesting that deleting the “NULL” text and leaving it empty allowed it to go through.
“but direct database manipulation may void your GnuCash warranty.”
I was thinking about direct upload to the postgres table (creating my own guid and checking for duplication) but that doesn’t sound like a good idea?
Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows
From: Geoff<mailto:cleanoutmyshed at gmail.com>
Sent: 20 October 2021 11:15
To: Public Address<mailto:public.address at hotmail.co.uk>; David Carlson<mailto:david.carlson.417 at gmail.com>
Cc: gnucash-user at gnucash.org<mailto:gnucash-user at gnucash.org>
Subject: Re: [GNC] save as sqlite3 error
That would do it - the schema prohibits NULLs.
I don't believe it is possible to import securities, it is not an option
on the Import menu. Depending how many you have, you could consider:-
Learning to script AutoHotKey - https://www.autohotkey.com/ - which is
excellent for automating Windows applications.
Or (big stretch) have a look at PieCash - the securities table is called
"commodities" -
https://github.com/sdementen/piecash/blob/master/piecash/core/commodity.py
- but direct database manipulation may void your GnuCash warranty.
I reckon you will probably find it quicker to type them in yourself -
you can import price data from CSV once the securities themselves are
set up.
Hope this helps.
Regards
Geoff
=====
On 20/10/2021 7:25 pm, Public Address wrote:
> Thank you all. Someone last night pointed me to the trace file. I
> tried to save as sqlite3, failed then closed down. The last lines are
> as follows:
>
> * 17:59:21 ERROR <gnc.engine> gboolean qof_book_is_readonly(const
> QofBook*): assertion 'book != NULL' failed
> * 17:59:26 ERROR <gnc.backend.dbi> [error_handler()] DBI error: 19: NOT
> NULL constraint failed: splits.memo
> * 17:59:26 ERROR <gnc.backend.dbi>
> [GncDbiSqlConnection::execute_nonselect_statement()] Error executing SQL
> INSERT INTO
> splits(guid,tx_guid,account_guid,memo,action,reconcile_state,reconcile_date,value_num,value_denom,quantity_num,quantity_denom)
> VALUES('[xxx]','[xxy]','[xxz]',NULL,'','c','2021-01-24
> 17:57:12',46353,100,46353,100)
> * 17:59:26 ERROR <gnc.backend.sql>
> [GncSqlBackend::execute_nonselect_statement()] SQL error: INSERT INTO
> splits(guid,tx_guid,account_guid,memo,action,reconcile_state,reconcile_date,value_num,value_denom,quantity_num,quantity_denom)
> VALUES('[xxx]','[xxy]','[xxz]',NULL,'','c','2021-01-24
> 17:57:12',46353,100,46353,100)
>
> I am not sure how to look for transactions via the guid_tx, but I
> searched for 463.53. I was then shown a split transaction view of a
> transaction that was put into the imbalance account. The description
> was “NULL” where the rectangle is in the attached. Some of my other
> imbalance entries had this entry, some did not. So I removed them all
> and now it writes.
>
> I don't believe I put these “NULL”s in, I think gnucash did it so might
> be something to look into.
>
> Not sure if you saw my other question – can import securities (not the
> security transactions) or can I only add them via the GUI?
>
> Many Thanks
>
> Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for Windows
>
> *From: *Geoff <mailto:cleanoutmyshed at gmail.com>
> *Sent: *20 October 2021 04:29
> *To: *David Carlson <mailto:david.carlson.417 at gmail.com>
> *Cc: *Public Address <mailto:public.address at hotmail.co.uk>;
> gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
> *Subject: *Re: [GNC] save as sqlite3 error
>
> Good pickup David - Thunderbird dropped the attachment, but I can see it
> via Gmail {:--(
>
> Not that it helps much PA, as John said, please check the trace file.
>
> Geoff
> =====
>
> On 20/10/2021 2:04 pm, David Carlson wrote:
> > It is odd that PA's screenshot made it to my Gmail account in Windows OS
> > when it did not get to Geoff's email client, or maybe it did but Geoff
> > did not see it because for some reason there was an inline link as well
> > as an attachment at the end. In either case I cannot comment on the
> > sqlite issue as I have no experience with that. Did I see an email
> > elsewhere suggesting that sometimes an incorrect version of some library
> > program was incorrectly selected by the installation program?
> >
> > On Tue, Oct 19, 2021 at 8:16 PM Geoff <cleanoutmyshed at gmail.com
> > <mailto:cleanoutmyshed at gmail.com <mailto:cleanoutmyshed at gmail.com>>>
> wrote:
> >
> > Hi PA
> >
> > I can't help you with this error except to say that I am running
> on the
> > same build on Windows 10 and cannot reproduce your problem. BUT I do
> > not have Trading Accounts switched on.
> >
> > I successfully saved a 35MB XML file to SQLite and can access
> that file
> > in both GnuCash and the SQLite DB Browser. See attached screenshot.
> >
> > (Your screenshot didn't come through - try attaching instead of
> > pasting).
> >
> > Have you tried debugging: https://wiki.gnucash.org/wiki/Logging
> <https://wiki.gnucash.org/wiki/Logging>
> > <https://wiki.gnucash.org/wiki/Logging
> <https://wiki.gnucash.org/wiki/Logging>>
> >
> > Start gnucash.exe from the command line with the "--debug"
> switch. In
> > my case, the log files are called gnucash.traceXXXXXX.log in
> > ~\AppData\Local\Temp
> >
> > Being Windows, perhaps a reboot may help?
> >
> > Good luck.
> >
> > Regards
> >
> > Geoff
> > =====
> >
> > On 19/10/2021 6:27 pm, Public Address wrote:
> > > Hi - In xml format
> > >
> > > Trying to save as sqlite3 getting error when file gets to 213kb.
> > Plenty of room on disk. I have tried different drives, different
> > filenames no luck.
> > >
> > > [cid:image001.png at 01D7C4C2.F1FEDBF0]
> > >
> > >
> > > Many thanks
> > >
> > > Windows 10
> > > GNU 4.8
> > > Build ID 4.8a+ (2021-09-28)
> > > Finance::Quote 1.49
> > >
> > > Trading Accounts: on
> > >
> > > Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986
> > <https://go.microsoft.com/fwlink/?LinkId=550986
> <https://go.microsoft.com/fwlink/?LinkId=550986>>> for Windows
> > >
> > >
> > >
> > > _______________________________________________
> > > gnucash-user mailing list
> > > gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org
> <mailto:gnucash-user at gnucash.org>>
> > > To update your subscription preferences or to unsubscribe:
> > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
> > <https://lists.gnucash.org/mailman/listinfo/gnucash-user
> <https://lists.gnucash.org/mailman/listinfo/gnucash-user>>
> > > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists
> <https://wiki.gnucash.org/wiki/Mailing_Lists>
> > <https://wiki.gnucash.org/wiki/Mailing_Lists
> <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 at gnucash.org <mailto:gnucash-user at gnucash.org
> <mailto:gnucash-user at gnucash.org>>
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
> > <https://lists.gnucash.org/mailman/listinfo/gnucash-user
> <https://lists.gnucash.org/mailman/listinfo/gnucash-user>>
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists
> <https://wiki.gnucash.org/wiki/Mailing_Lists>
> > <https://wiki.gnucash.org/wiki/Mailing_Lists
> <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.
> >
> >
> >
> > --
> > David Carlson
>
More information about the gnucash-user
mailing list