2018-12-13 GnuCash IRC logs

00:16:25 *** tienne has joined #gnucash
00:30:32 *** boldstripe has quit IRC
00:32:14 *** nimish has quit IRC
00:37:29 *** Mechtilde has joined #gnucash
00:42:44 *** jrp has joined #gnucash
00:45:44 *** jrp has quit IRC
01:30:36 *** Mechtilde has quit IRC
01:37:24 *** fell_laptop has joined #gnucash
01:39:07 *** fell has quit IRC
01:43:11 *** jrp has joined #gnucash
01:46:12 *** jrp has quit IRC
01:59:35 *** marusich has joined #gnucash
02:01:51 *** tienne has quit IRC
02:06:21 *** fell_laptop is now known as fell
02:06:32 *** gncbot sets mode: +o fell
02:06:56 *** nimish has joined #gnucash
02:26:37 *** jotrago has quit IRC
02:44:24 *** jrp has joined #gnucash
02:47:24 *** jrp has quit IRC
02:49:33 *** fabior has joined #gnucash
03:02:21 *** tienne has joined #gnucash
03:23:11 *** marusich has quit IRC
03:32:55 *** gjanssens has joined #gnucash
03:32:56 *** ChanServ sets mode: +o gjanssens
03:36:43 *** gour has joined #gnucash
03:36:48 *** nimish has quit IRC
03:37:18 *** nimish has joined #gnucash
03:45:03 *** jrp has joined #gnucash
03:47:09 *** nimish has quit IRC
03:47:38 *** nimish has joined #gnucash
03:48:03 *** jrp has quit IRC
03:53:57 <gjanssens> .
04:02:30 *** nimish has quit IRC
04:03:00 *** nimish has joined #gnucash
04:05:45 *** ncv has joined #gnucash
04:18:24 *** kapil___ has joined #gnucash
04:28:33 *** Aussie_matt has quit IRC
04:28:49 *** fabior has quit IRC
04:45:11 *** bertbob has quit IRC
04:46:20 *** jrp has joined #gnucash
04:49:20 *** jrp has quit IRC
04:53:14 <fell> gnomey: opening an existing account should not mark the book as modified, so file a bug.
04:56:36 <fell> Are you sure, it was not marked modified before?
04:57:39 <fell> I can not reproduce it. There must be some additional condition.
05:02:02 *** tienne has quit IRC
05:02:51 *** nimish has quit IRC
05:03:26 *** nimish has joined #gnucash
05:03:34 *** bertbob has joined #gnucash
05:19:31 *** fabior has joined #gnucash
05:38:20 *** nimish has quit IRC
05:41:49 *** nimish_ has joined #gnucash
05:43:21 *** nimish_ has quit IRC
05:43:56 *** nimish_ has joined #gnucash
05:45:26 *** Aussie_matt has joined #gnucash
05:47:16 *** jrp has joined #gnucash
05:48:31 *** nimish_ has quit IRC
05:49:39 *** fell has quit IRC
05:49:40 *** fell_laptop has joined #gnucash
05:50:16 *** jrp has quit IRC
05:54:59 *** fabior has quit IRC
06:02:29 *** tienne has joined #gnucash
06:18:52 *** nimish_ has joined #gnucash
06:22:27 *** fell has joined #gnucash
06:22:28 *** fell_laptop has quit IRC
06:28:33 *** nimish_ has quit IRC
06:29:44 *** nimish_ has joined #gnucash
06:30:34 *** Aussie_matt has quit IRC
06:31:48 *** Jimraehl1 has joined #gnucash
06:32:16 *** Jimraehl1 has left #gnucash
06:33:01 *** nimish_ has quit IRC
06:40:06 *** nimish_ has joined #gnucash
06:48:06 *** jrp has joined #gnucash
06:49:52 *** nimish_ has quit IRC
06:50:30 *** nimish_ has joined #gnucash
06:51:06 *** jrp has quit IRC
06:55:11 *** nimish_ has quit IRC
06:58:23 *** oozer has joined #gnucash
06:59:40 *** nimish_ has joined #gnucash
07:04:51 *** nimish_ has quit IRC
07:08:13 *** nimish_ has joined #gnucash
07:10:30 *** nimish_ has quit IRC
07:11:55 *** nimish has joined #gnucash
07:14:12 *** KaiForce has joined #gnucash
07:21:08 *** nimish has quit IRC
07:26:49 *** nimish has joined #gnucash
07:33:33 *** nimish has quit IRC
07:49:30 *** jrp has joined #gnucash
07:50:32 *** syntaxma1 has joined #gnucash
07:52:30 *** jrp has quit IRC
08:23:54 *** boldstripe has joined #gnucash
08:50:18 *** jrp has joined #gnucash
08:53:17 *** jrp has quit IRC
08:53:19 *** fabior has joined #gnucash
08:54:41 *** jferrero has joined #gnucash
09:38:55 *** nimish has joined #gnucash
09:51:12 *** jrp has joined #gnucash
09:53:43 *** nimish has quit IRC
09:54:12 *** jrp has quit IRC
09:54:13 *** nimish has joined #gnucash
09:59:17 *** jotrago has joined #gnucash
10:08:44 *** KevinDB has quit IRC
10:09:06 *** nimish has quit IRC
10:09:35 *** nimish has joined #gnucash
10:12:08 *** KevinDB has joined #gnucash
10:21:19 <fell> warlord, while pings are OK, https is not possible.
10:21:45 *** nimish has quit IRC
10:28:08 <warlord> fell: it's working for me.
10:28:31 <warlord> (just tried wiki)
10:28:52 <warlord> Granted, I'm local, so if the network is bottlenecking upstream somewhere that could affect it.
10:32:32 <fell> on all (wiki, code, bugs, lists) I get server not found. Although DNS resolves.
10:34:08 *** gour has quit IRC
10:34:36 <warlord> server not found? That sounds like a local issue on your end? :(
10:34:44 <warlord> gjanssens, jralls -- can you hit code?
10:35:37 <fell> Ah, it seems FF got confused.
10:35:53 <gjanssens> warlord: yes I can
10:36:39 <fell> On the console the names resolve, but not in firefox.
10:36:40 <warlord> gjanssens: okay.
10:36:49 <warlord> fell: that sounds like FF issue :(
10:37:43 *** gour has joined #gnucash
10:43:27 *** fabior has quit IRC
10:44:13 *** fabior has joined #gnucash
10:51:52 *** jrp has joined #gnucash
10:54:53 *** jrp has quit IRC
11:04:21 *** chris has joined #gnucash
11:08:29 *** fabior has quit IRC
11:23:34 *** fabior has joined #gnucash
11:30:48 *** tang^ has joined #gnucash
11:37:30 *** User_ has joined #gnucash
11:39:08 *** Mechtilde has joined #gnucash
11:43:34 *** User_ has quit IRC
11:45:38 *** calvinct has joined #gnucash
11:53:01 *** jrp has joined #gnucash
11:56:01 *** jrp has quit IRC
12:08:05 *** jrok has joined #gnucash
12:09:22 <jrok> hi! First off, I love gnucash and the flexibility it affords me! having an issue moving to v3.3, though....
12:11:23 <jrok> my datasource is postgres. os is ubuntu 18.04, going from 2.6 to 3.3, connecting to the same datasource, i get terminate called after throwing an instance of 'std::invalid_argument'
12:11:39 <jrok> what(): Requested integer from non-integer column.
12:11:50 <jrok> aborted (core dumped)
12:12:34 *** fabior has quit IRC
12:14:40 <jrok> if I'm violating any of the accepted norms of IRC chat, please let me know -- this is honestly the first time I've ever connected to an IRC channel... thanks again
12:18:07 *** jerryq has quit IRC
12:19:15 *** gour has quit IRC
12:19:37 *** gour has joined #gnucash
12:20:42 *** calvinct has quit IRC
12:26:55 *** fabior has joined #gnucash
12:27:20 <gjanssens> jrok: you are using irc correctly
12:27:55 *** calvinct has joined #gnucash
12:28:17 <gjanssens> What exact 2.6 version did you try to migrate from ?
12:30:41 <jrok> gjanssens: whatever version ships with ubuntu 18.04, which i believe is 2.6.19
12:32:18 <jrok> the data was migrated into 2.6.19 from 2.6.12 though, if that helps.
12:33:08 <jrok> via dumping the postgres db
12:46:22 <gjanssens> jrok: I don't know if that helps :(
12:46:45 <gjanssens> In any case gnucash should never crash while migrating. At worst it should report a migration issue
12:46:57 <gjanssens> So you have found an uncaught corner case.
12:48:21 <gjanssens> I think it's best you create a bug report for this as we'll need more details to track this down and irc is not a good place to provide this info
12:49:21 <gjanssens> Our bugtracker is here: https://bugs.gnucash.org
12:49:38 <gjanssens> If you haven't used bugzilla before, you will find some background information here: https://wiki.gnucash.org/wiki/Bugzilla
12:52:24 <gjanssens> There are two things you can do to provide more details
12:52:34 <jrok> gladly!
12:53:10 <gjanssens> 1. run gnucash under gdb and when it aborts generate a stack trace as explained here: https://wiki.gnucash.org/wiki/Stack_Trace
12:53:38 *** jrp has joined #gnucash
12:54:56 <gjanssens> 2. run gnucash with detailed db transaction logging enabled and when it aborts upload the generated gnucash.trace file (after removing any personally identifying information!)
12:56:32 <gjanssens> Or perhaps gnucash already did add the sql error in your current trace file. You may add that in any case as explained here: https://wiki.gnucash.org/wiki/Tracefile
12:56:40 *** fell has quit IRC
12:56:40 *** jrp has quit IRC
12:57:01 <gjanssens> I don't remember offhand what switch to add to make gnucash dump the sql queries as well (which is what I meant with detailed db logs)
12:57:13 <gjanssens> Perhaps jralls does
12:57:41 <gjanssens> But he was busy today so you may have to wait a bit before he replies
12:58:53 *** jerryq has joined #gnucash
13:04:55 *** calvinct has quit IRC
13:05:00 *** calvinct has joined #gnucash
13:05:28 <jrok> ok, i'll put it in the bug report.
13:09:11 <gjanssens> tx
13:09:39 *** fabior has quit IRC
13:32:39 *** boldstripe has quit IRC
13:50:10 *** nimish has joined #gnucash
13:51:21 *** boldstripe has joined #gnucash
13:53:11 *** boldstripe has quit IRC
13:53:38 *** boldstripe has joined #gnucash
13:54:29 *** jrp has joined #gnucash
13:57:29 *** jrp has quit IRC
13:59:52 *** nimish has quit IRC
14:05:39 *** jralls has quit IRC
14:06:22 *** jralls has joined #gnucash
14:06:22 *** ChanServ sets mode: +o jralls
14:11:22 *** ncv has quit IRC
14:12:56 *** JayC has quit IRC
14:15:01 *** jralls has quit IRC
14:16:00 *** jralls has joined #gnucash
14:16:00 *** ChanServ sets mode: +o jralls
14:16:28 *** puck has quit IRC
14:18:15 <jralls> gjanssens: To get the sql queries use --logging gnc.backend.dbi=debug.
14:18:36 <jralls> jrok: That's for you, too.
14:19:18 <gjanssens> jralls: thanks
14:20:33 *** puck has joined #gnucash
14:21:11 *** gjanssens has quit IRC
14:21:46 *** gour has quit IRC
14:22:18 *** JayC has joined #gnucash
14:24:43 *** gour has joined #gnucash
14:31:36 *** kapil___ has quit IRC
14:34:07 *** fell has joined #gnucash
14:34:08 *** gncbot sets mode: +o fell
14:34:45 <jrok> jralls: thx!
14:39:27 *** jerryq has quit IRC
14:42:51 *** SirNeo- has joined #gnucash
14:50:49 <jrok> [xaccOpenLog] Attempt to open disabled transaction log
14:50:50 <jrok> [xaccTransWriteLog] Attempt to write disabled transaction log
14:51:00 <jrok> lots of these messages showing up in stack trace
14:55:11 *** jrp has joined #gnucash
14:58:11 *** jrp has quit IRC
15:01:44 <warlord> jrok: how did you disable the transaction log?
15:03:55 <jrok> warlord: no idea - i definitely didn't do it on purpose!
15:07:10 <jrok> So, I have business and personal gnucash books (separate databases, both are postgres). My personal books will open but show zero balance for every account and transaction in 3.3.
15:09:22 <jrok> jralls: where does that flag for logging go? I tried it when launching gdb and gnucash and it doesn't like it. I've used --debug --extra ...
15:11:24 *** calvinct has quit IRC
15:12:29 <jralls> jrok: Sorry, `gnucash --log gnc.backend.dbi=debug`. Best to not use --debug with it so that you don't have to pick out the SQL messages from all the ones that --debug emits.
15:13:02 <jralls> jrok: The transaction log messages are normal during loading.
15:20:23 *** tienne has quit IRC
15:30:06 <jrok> jralls: cool i'll give it a whirl
15:54:55 *** boldstripe has quit IRC
15:55:55 *** jrp has joined #gnucash
15:58:56 *** jrp has quit IRC
16:10:55 <jrok> okay, it was puking on the taxtables table
16:11:11 <jrok> however, all balances and splits are 0!
16:12:07 <jrok> backing up -- to get it to quit crashing on the taxtables select query, i just dumped the 3 rows in taxtables
16:12:37 *** Motig has joined #gnucash
16:12:41 <jrok> it loaded, but as is also the case when i load my personal books, all transactions are zero, and so are balances.
16:12:58 *** Motig has quit IRC
16:20:52 *** tienne has joined #gnucash
16:50:51 *** gour has quit IRC
16:56:01 *** KaiForce has quit IRC
16:56:45 *** jrp has joined #gnucash
16:59:04 *** gour has joined #gnucash
16:59:45 *** jrp has quit IRC
17:05:30 *** Agfarmer18 has joined #gnucash
17:13:40 *** jrok has quit IRC
17:29:00 *** Agfarmer18 has quit IRC
17:44:53 *** jerryq has joined #gnucash
17:55:57 *** Aussie_matt has joined #gnucash
17:57:46 *** jrp has joined #gnucash
18:00:46 *** jrp has quit IRC
18:07:15 *** Agfarmer18 has joined #gnucash
18:14:28 *** jrok has joined #gnucash
18:25:29 *** jrok has quit IRC
18:33:58 *** tienne has quit IRC
18:43:24 *** jrok has joined #gnucash
18:50:58 *** gour has quit IRC
18:58:36 *** jrok has quit IRC
18:58:47 *** jrp has joined #gnucash
19:01:47 *** jrp has quit IRC
19:22:37 *** mdf has joined #gnucash
19:59:36 *** jrp has joined #gnucash
20:02:36 *** jrp has quit IRC
20:55:44 *** oozer has quit IRC
21:00:40 *** jrp has joined #gnucash
21:03:40 *** jrp has quit IRC
21:07:37 * chris just been trying combine balsheet-pnl and envelope-budgeting... *hard*
21:08:02 <chris> the target UI would be something like YNAB's spreadsheet
21:13:23 <chris> and there would have been a button to allocate unused budget monies to expense accounts <g>
21:23:56 <chris> it would have made multicolumn become its own monster report-and-dataentry module. let's abandon this.
21:44:56 *** kapil___ has joined #gnucash
22:01:29 *** jrp has joined #gnucash
22:04:29 *** jrp has quit IRC
22:57:02 *** Agfarmer18 has joined #gnucash
22:57:59 *** Agfarmer18 has quit IRC
23:02:17 *** jrp has joined #gnucash
23:05:15 *** jrp has quit IRC