[GNC] save as sqlite3 error
Geoff
cleanoutmyshed at gmail.com
Fri Oct 22 21:42:34 EDT 2021
Looks like that approach could work, but I'm afraid I don't know enough
about the inner workings of GnuCash to advise you authoritatively.
Good luck!
Regards
Geoff
=====
On 22/10/2021 11:52 pm, Public Address wrote:
> 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/
> <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
> <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
> <https://go.microsoft.com/fwlink/?LinkId=550986>> for Windows
> >
> > *From: *Geoff <mailto:cleanoutmyshed at gmail.com
> <mailto:cleanoutmyshed at gmail.com>>
> > *Sent: *20 October 2021 04:29
> > *To: *David Carlson <mailto:david.carlson.417 at gmail.com
> <mailto:david.carlson.417 at gmail.com>>
> > *Cc: *Public Address <mailto:public.address at hotmail.co.uk
> <mailto:public.address at hotmail.co.uk>>;
> > gnucash-user at gnucash.org <mailto: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
> <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>>
> > > <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
> <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 <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>>
> > > <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>>
> > > <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 <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>>
> > > <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>>
> > > <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