subject:"Re\: \[GNC\] save as sqlite3 error"

Re: [GNC] save as sqlite3 error

2021-10-23 Thread Public Address

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:cleanoutmys...@gmail.com>
Sent: 20 October 2021 11:15
To: Public Address<mailto:public.addr...@hotmail.co.uk>; David 
Carlson<mailto:david.carlson@gmail.com>
Cc: gnucash-user@gnucash.org<mailto:gnucash-user@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  gboolean qof_book_is_readonly(const
> QofBook*): assertion 'book != NULL' failed
> * 17:59:26 ERROR  [error_handler()] DBI error: 19: NOT
> NULL constraint failed: splits.memo
> * 17:59:26 ERROR 
> [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 
> [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:cleanoutmys...@gmail.com>
> *Sent: *20 October 2021 04:29
> *To: *David Carlson <mailto:david.carlson....@gmail.com>
> *Cc: *Public Address <mailto:public.addr...@hotmail.co.uk>;
> gnucash-user@gnucash.org <mailto:gnucash-user@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   > <mailto:cleanoutmys...@gmail.com <mailto:cleanoutmys...@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 successful

Re: [GNC] save as sqlite3 error

2021-10-22 Thread Peter West

FWIW, I just tried to save my postgresql-based data as sqlite3 and GnuCash 
crashed.

Peter
—
Peter West
p...@ehealth.id.au
“And why do you not judge for yourselves what is right?”

> On 23 Oct 2021, at 11:42 am, Geoff  wrote:
> 
> 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 
>> <https://go.microsoft.com/fwlink/?LinkId=550986>> for Windows
>> *From: *Geoff <mailto:cleanoutmys...@gmail.com 
>> <mailto:cleanoutmys...@gmail.com>>
>> *Sent: *20 October 2021 11:15
>> *To: *Public Address <mailto:public.addr...@hotmail.co.uk 
>> <mailto:public.addr...@hotmail.co.uk>>; David Carlson 
>> <mailto:david.carlson@gmail.com <mailto:david.carlson@gmail.com>>
>> *Cc: *gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> 
>> <mailto:gnucash-user@gnucash.org <mailto:gnucash-user@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/> <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><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  gboolean qof_book_is_readonly(const
>> > QofBook*): assertion 'book != NULL' failed
>> > * 17:59:26 ERROR  [error_handler()] DBI error: 19: NOT
>> > NULL constraint failed: splits.memo
>> > * 17:59:26 ERROR 
>> > [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 
>> > [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 GU

Re: [GNC] save as sqlite3 error

2021-10-22 Thread Geoff

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:cleanoutmys...@gmail.com>
*Sent: *20 October 2021 11:15
*To: *Public Address <mailto:public.addr...@hotmail.co.uk>; David 
Carlson <mailto:david.carlson@gmail.com>

*Cc: *gnucash-user@gnucash.org <mailto:gnucash-user@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  gboolean qof_book_is_readonly(const
 > QofBook*): assertion 'book != NULL' failed
 > * 17:59:26 ERROR  [error_handler()] DBI error: 19: NOT
 > NULL constraint failed: splits.memo
 > * 17:59:26 ERROR 
 > [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 
 > [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:cleanoutmys...@gmail.com 
<mailto:cleanoutmys...@gmail.com>>

 > *Sent: *20 October 2021 04:29
 > *To: *David Carlson <mailto:david.carlson@gmail.com 
<mailto:david.carlson@gmail.com>>
 > *Cc: *Public Address <mailto:public.addr...@hotmail.co.uk 
<mailto:public.addr...@hotmail.co.uk>>;
 > gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org 
<mailto:gnucash-user@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

Re: [GNC] save as sqlite3 error

2021-10-22 Thread Public Address

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  gboolean qof_book_is_readonly(const QofBook*): 
assertion 'book != NULL' failed
* 17:59:26 ERROR  [error_handler()] DBI error: 19: NOT NULL 
constraint failed: splits.memo
* 17:59:26 ERROR  
[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  
[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:cleanoutmys...@gmail.com>
Sent: 20 October 2021 04:29
To: David Carlson<mailto:david.carlson@gmail.com>
Cc: Public Address<mailto:public.addr...@hotmail.co.uk>; 
gnucash-user@gnucash.org<mailto:gnucash-user@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  <mailto:cleanoutmys...@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>
>
> Start gnucash.exe from the command line with the "--debug" switch.  In
> my case, the log files are called gnucash.traceXX.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@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>> for Windows
>  >
>  >
>  >
>  > ___
>  > gnucash-user mailing list
>  > gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
>  > To update your subscription preferences or to unsubscribe:
>  > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> <https://lists.gnu

Re: [GNC] save as sqlite3 error

2021-10-20 Thread Geoff


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  gboolean qof_book_is_readonly(const 
QofBook*): assertion 'book != NULL' failed
* 17:59:26 ERROR  [error_handler()] DBI error: 19: NOT 
NULL constraint failed: splits.memo
* 17:59:26 ERROR  
[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  
[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:cleanoutmys...@gmail.com>
*Sent: *20 October 2021 04:29
*To: *David Carlson <mailto:david.carlson@gmail.com>
*Cc: *Public Address <mailto:public.addr...@hotmail.co.uk>; 
gnucash-user@gnucash.org <mailto:gnucash-user@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  > <mailto:cleanoutmys...@gmail.com <mailto:cleanoutmys...@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.traceXX.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.
 >

Re: [GNC] save as sqlite3 error

2021-10-19 Thread Geoff

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 > 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

Start gnucash.exe from the command line with the "--debug" switch.  In
my case, the log files are called gnucash.traceXX.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@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> for Windows
 >
 >
 >
 > ___
 > gnucash-user mailing list
 > gnucash-user@gnucash.org 
 > To update your subscription preferences or to unsubscribe:
 > https://lists.gnucash.org/mailman/listinfo/gnucash-user

 > If you are using Nabble or Gmane, please see
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@gnucash.org 
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user

If you are using Nabble or Gmane, please see
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

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
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.

Re: [GNC] save as sqlite3 error

2021-10-19 Thread David Carlson

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  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
>
> Start gnucash.exe from the command line with the "--debug" switch.  In
> my case, the log files are called gnucash.traceXX.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@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 for
> Windows
> >
> >
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> 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@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> 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
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
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.

Re: [GNC] save as sqlite3 error

2021-10-19 Thread john

The actual error information should be in the trace file, see 
https://wiki.gnucash.org/wiki/Tracefile 
 for details.

Regards,
John Ralls

> On Oct 19, 2021, at 12:27 AM, 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@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 for Windows
> 
> <10E0DE93BF7D45FAB1E3DE7E42DF495B.png>___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> 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@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
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.

Re: [GNC] save as sqlite3 error

Re: [GNC] save as sqlite3 error

Re: [GNC] save as sqlite3 error

Re: [GNC] save as sqlite3 error

Re: [GNC] save as sqlite3 error

Re: [GNC] save as sqlite3 error

Re: [GNC] save as sqlite3 error

Re: [GNC] save as sqlite3 error

8 matches

Site Navigation

Mail list logo

Footer information