2018-06-27 GnuCash IRC logs
00:18:46 *** fell has quit IRC
00:27:01 *** jeffpc has quit IRC
00:27:49 *** jeffpc has joined #gnucash
00:32:11 *** ArtGravity has quit IRC
01:03:21 *** Mechtilde has joined #gnucash
01:20:44 *** ncv has joined #gnucash
02:08:33 *** chris has joined #gnucash
02:10:56 <chris> jralls the balsheet-pnl is shaping up really nicely. I'll have a few renaming to do, and will write suitable tests. I
02:11:50 <chris> renaming variables to reflect evolving strategies
02:11:56 <chris> I'd think it'd be fair to make it a new report with different uuids...
02:12:07 *** Mechtilde has quit IRC
02:33:42 *** harshitaneja has joined #gnucash
02:47:33 *** chris has quit IRC
02:53:19 *** jotrago has quit IRC
03:22:56 *** gjanssens has joined #gnucash
03:22:56 *** ChanServ sets mode: +o gjanssens
03:23:12 <gjanssens> .
03:47:21 *** Mechtilde has joined #gnucash
03:56:26 *** gour has joined #gnucash
03:59:51 *** chris has joined #gnucash
04:17:47 *** wget has quit IRC
04:18:17 *** wget has joined #gnucash
04:44:56 *** jotrago has joined #gnucash
04:47:25 *** pilotauto has quit IRC
05:13:57 *** Aussie_matt has joined #gnucash
05:53:41 *** fekepp has joined #gnucash
06:07:37 *** harshitaneja has quit IRC
06:08:15 *** harshitaneja has joined #gnucash
06:12:32 *** chris has quit IRC
06:19:50 *** harshitaneja has quit IRC
06:20:35 *** jotrago1 has joined #gnucash
06:20:51 *** jotrago has quit IRC
06:20:55 *** harshitaneja has joined #gnucash
06:21:03 *** jotrago1 is now known as jotrago
06:21:24 *** Aussie_matt has quit IRC
06:23:57 *** fekepp has quit IRC
06:24:30 *** Aussie_matt has joined #gnucash
06:27:10 *** jotrago has quit IRC
06:29:37 *** harshitaneja has quit IRC
06:41:39 *** Mechtilde has quit IRC
06:43:24 *** chris has joined #gnucash
06:44:58 *** jotrago has joined #gnucash
06:47:19 *** Jimraehl1 has joined #gnucash
06:48:30 *** Jimraehl1 has left #gnucash
06:48:45 *** gour has quit IRC
06:51:18 *** chris has quit IRC
06:52:21 *** chris has joined #gnucash
06:59:12 *** chris has quit IRC
06:59:36 *** gour has joined #gnucash
07:01:40 *** harshitaneja_ has joined #gnucash
07:18:33 *** jotrago1 has joined #gnucash
07:18:58 *** jotrago has quit IRC
07:21:33 *** jotrago1 has quit IRC
07:24:19 *** jotrago has joined #gnucash
08:31:02 *** luwum[m] has joined #gnucash
08:51:19 *** mipesom has quit IRC
08:52:37 *** oozer has joined #gnucash
08:53:14 *** mipesom has joined #gnucash
09:03:22 *** boldstripe has joined #gnucash
09:06:41 *** Mechtilde has joined #gnucash
09:12:51 *** fabior has joined #gnucash
09:27:04 *** kael has joined #gnucash
09:28:22 *** GabrieleV has quit IRC
09:30:40 *** GabrieleV has joined #gnucash
09:30:42 <warlord> .
09:30:42 <gncbot> warlord: Sent 20 hours and 35 minutes ago: <jralls> The comment rpc returns both a bug_id and, if it was made on an attachement, an attachment_id. Maybe the import code is processing both?
09:34:43 *** jotrago1 has joined #gnucash
09:35:10 *** GabrieleV has quit IRC
09:35:37 *** jotrago has quit IRC
09:35:38 *** jotrago1 is now known as jotrago
09:41:50 *** GabrieleV has joined #gnucash
09:55:04 *** harshitaneja_ has quit IRC
09:55:07 *** Mechtilde has quit IRC
09:58:40 <warlord> jralls: Yes, it was doing that; if it was an attachment comment it was adding a TYPE and setting the attachment_id. My fear is that we might be losing data right now as a result of the way I'm importing it.
09:59:06 *** warlord has quit IRC
10:04:16 *** Agfarmer18 has joined #gnucash
10:05:46 *** jotrago has quit IRC
10:15:04 *** fell has joined #gnucash
10:16:55 *** boldstripe has quit IRC
10:17:44 *** gncbot sets mode: +o fell
10:19:34 *** Aussie_matt has quit IRC
10:20:26 *** Agfarmer18 has quit IRC
10:30:26 *** fabior has quit IRC
10:30:54 *** gour has quit IRC
10:45:04 *** fabior has joined #gnucash
10:46:48 *** gour has joined #gnucash
11:19:06 *** jotrago has joined #gnucash
11:26:39 *** Mechtilde has joined #gnucash
11:59:58 *** RASSRQ has joined #gnucash
12:09:08 *** Mechtilde has quit IRC
12:13:35 *** Mechtilde has joined #gnucash
12:34:40 *** Mechtilde has quit IRC
12:36:22 *** Mechtilde has joined #gnucash
12:48:26 *** calvinct has joined #gnucash
12:58:38 *** warlord has joined #gnucash
12:58:58 *** calvinct has quit IRC
13:17:26 *** ArtGravity has joined #gnucash
13:22:11 *** fabior has quit IRC
13:45:03 *** fabior has joined #gnucash
13:50:15 *** fabior has quit IRC
14:19:02 *** censor has joined #gnucash
14:20:31 <censor> hi all! i recently upgraded to MariaDB 10.2 and now it seems as if any changes to a book entry aren't saved anymore.
14:21:16 <censor> running gnucash 3.2, but it was the same with gnucash 3.1 (after i restored my database when it got dropped by that version, too)
14:21:20 <warlord> censor: what version of gnucash? What platform/OS
14:21:40 <warlord> is it a local server or a remote server?
14:22:12 <censor> gnucash 3.2 on win10 with a mariadb 10.2 on the local network. no errors in the mariadb logs
14:22:41 <warlord> It's possible that the client libs are incompatible
14:22:53 <censor> adding new book entries, either manually or from my online banking, still works
14:24:08 <warlord> censor: I dont understand -- do new entries get saved or not saved?
14:24:21 <warlord> Or what do you mean by "still works"?
14:24:50 <censor> i added a test entry, which got saved. but changing the account on an existing entry resets back when closing/opening gnucash
14:25:30 <censor> those older ones are booked to "Ausgleichskonto", so that default one. don't know the english translation
14:26:42 <warlord> Ah, so you can add new transactions but not change existing transactions?
14:27:01 <censor> it seems so, yes
14:27:01 <warlord> What happens if you try running 3.2 on a Linux or Mac platform against the same DB?
14:27:10 <warlord> (Can you try that?)
14:27:20 <censor> sorry, not possible :(
14:28:22 *** Mechtilde has quit IRC
14:29:06 <censor> IIRC, this was already the case with the 2.6.x i was running before, and that was also the reason i checked if there's a new version - which was 3.1, unfortunately
14:30:12 <warlord> Ah, so if 2.6 also had this issue then, most likely, the issue is an incompatibility with mariadb-10
14:30:46 <censor> yes, i had the same thought, that's why i opened with that line ;-)
14:31:13 <warlord> Can you downgrade your db server?
14:33:19 <censor> unfortunately also not an option because of other software using it, i could only upgrade to 10.3
14:34:47 <censor> i just synced my bank account, and the new transactions got matched to the correct account and survived a restart. the old ones still flip back
14:36:10 <warlord> Can you get a detailed SQL log to see why the UPDATE is failing?
14:36:26 <warlord> (I'm hoping jralls or gjanssens can chime in)
14:36:55 <censor> is there a way to log it client-side? on the db server i'd be sifting through thousands of line
14:37:09 <warlord> I honestly don't know.
14:37:45 <warlord> Can you file a bugzilla entry on this topic?
14:38:55 *** frakturfreak has joined #gnucash
14:39:34 <censor> i'll have a look
14:40:06 <censor> ah, "--log gnc.backend.dbi=debug"
14:41:44 <warlord> that sounds right.
14:45:15 <censor> now if i'd know where those logs get saved...
14:45:28 <censor> not in the ".gnucash\translog" folder
14:45:48 <warlord> the Trace File
14:47:09 <censor> ah, found it https://wiki.gnucash.org/wiki/Tracefile
14:47:33 <warlord> yeah
14:48:44 <censor> okay, got the queries
14:49:22 <warlord> And the error(s)?
14:49:31 <censor> no error
14:49:36 <warlord> Hmmm...
14:49:59 <censor> but i have the sneaking suspicion it has to do with the reconcile_date being set to '1970-01-01 00:00:00'
14:50:34 <warlord> Hmm. That could be a problem -- but not sure why it wouldn't throw an error if it IS an issue.
14:51:37 *** ncv has quit IRC
14:51:38 <censor> https://mariadb.com/kb/en/library/sql-mode/ -> STRICT_TRANS_TABLES
14:51:44 *** ncv has joined #gnucash
14:52:01 <censor> "Statements with invalid or missing data are aborted and rolled back"
14:53:03 <warlord> censor: that could be it. Please file a bug report with all this data.
14:53:11 <warlord> includng the SQL log, if you can.
14:53:18 <censor> hmm, i have that disabled already, i just noticed
14:55:33 <warlord> hmm
15:08:27 *** zai has joined #gnucash
15:11:30 <warlord> Gotta run.
15:11:39 *** warlord has quit IRC
15:14:13 <censor> bug opened: https://bugzilla.gnome.org/show_bug.cgi?id=796698
15:29:14 *** censor has quit IRC
15:33:03 *** fekepp has joined #gnucash
15:49:38 *** gjanssens has quit IRC
16:19:25 *** zai has quit IRC
16:28:46 *** frakturfreak has quit IRC
16:37:35 *** darix has joined #gnucash
16:37:40 <darix> I am a bit confused about the aqhbci-tool getaccsepa. how often do I need to do that?
17:14:09 *** gour has quit IRC
17:56:59 *** boldstripe has joined #gnucash
18:15:28 *** RASSRQ has quit IRC
18:25:02 *** User__ has joined #gnucash
18:27:27 *** RASSRQ has joined #gnucash
18:29:35 *** User__ has quit IRC
18:39:21 *** pilotauto has joined #gnucash
18:55:24 *** kael has quit IRC
19:27:59 *** Robert847 has joined #gnucash
19:32:45 *** fekepp has quit IRC
19:33:56 <Robert847> Hi, I have noticed in the Developers maillist that Christian Stimming is exploring ways to make GnuCash run faster. I have also noticed that in Windows in particular GnuCash seems to single thread everything, so having multiple processors is almost useless. Is it possible to restructure the code to take advantage of newer CPU?
20:45:17 *** O01eg has quit IRC
20:50:17 *** ArtGravity has quit IRC
20:58:58 *** O01eg has joined #gnucash
21:00:37 *** oozer has quit IRC
21:10:41 *** boldstripe has quit IRC
21:11:00 *** chris has joined #gnucash
21:12:42 *** boldstripe has joined #gnucash
21:23:48 *** kael has joined #gnucash
21:47:38 *** bertbob has quit IRC
21:50:02 *** bertbob has joined #gnucash
21:53:09 *** bertbob has quit IRC
21:55:01 *** ncv has quit IRC
21:55:10 *** O01eg has quit IRC
22:07:55 *** bertbob has joined #gnucash
22:09:42 *** O01eg has joined #gnucash
22:09:55 *** RASSRQ has quit IRC
22:40:04 *** chris has quit IRC
22:59:24 *** oozer has joined #gnucash
23:09:02 *** chris has joined #gnucash
23:10:33 *** Robert847 has left #gnucash
23:58:05 *** O01eg has quit IRC
23:58:39 *** O01eg has joined #gnucash