2019-04-23 GnuCash IRC logs
00:56:47 *** Mechtilde has joined #gnucash
00:56:48 *** ChanServ sets mode: +v Mechtilde
01:11:59 *** Mechtilde has quit IRC
01:23:29 *** Mechtilde has joined #gnucash
01:23:29 *** ChanServ sets mode: +v Mechtilde
01:25:16 *** fell has quit IRC
01:25:35 *** fell has joined #gnucash
01:25:35 *** ChanServ sets mode: +o fell
01:26:02 *** Mechtilde has quit IRC
01:26:23 *** Mechtilde has joined #gnucash
01:26:23 *** ChanServ sets mode: +v Mechtilde
01:39:10 *** kapil___ has joined #gnucash
01:40:15 *** Mechtilde has quit IRC
01:55:36 *** fell has quit IRC
01:56:56 *** fell has joined #gnucash
01:56:56 *** ChanServ sets mode: +o fell
02:17:46 *** nicoroumeau has joined #gnucash
02:19:52 *** nicoroumeau has quit IRC
02:35:28 *** jcamos has joined #gnucash
02:35:29 *** ChanServ sets mode: +v jcamos
02:43:08 *** linas has quit IRC
02:48:03 *** linas has joined #gnucash
02:52:31 *** storyjesse has quit IRC
02:55:20 *** jcamos has quit IRC
02:57:07 *** fabior has joined #gnucash
03:19:51 *** fabior has quit IRC
03:20:46 <gjanssens> jralls: good work on the guile 2.2 build !
03:22:04 <gjanssens> That looks like an important step forward.
03:23:17 <gjanssens> It's time I create myself a Windows VM to play with your work...
03:24:03 <gjanssens> BTW I forgot to shut down my PC on Saturday... I was in Paris for the last two days
03:27:13 *** jcamos has joined #gnucash
03:27:13 *** ChanServ sets mode: +v jcamos
03:29:05 *** Mechtilde has joined #gnucash
03:29:05 *** ChanServ sets mode: +v Mechtilde
03:33:48 *** jcamos has quit IRC
03:39:20 *** fabior has joined #gnucash
03:41:16 *** jcamos has joined #gnucash
03:41:16 *** ChanServ sets mode: +v jcamos
03:46:06 *** KevinDB has quit IRC
03:50:48 *** KevinDB has joined #gnucash
03:50:48 *** ChanServ sets mode: +v KevinDB
03:51:58 *** Mechtilde has quit IRC
03:52:16 *** Mechtilde has joined #gnucash
03:52:16 *** ChanServ sets mode: +v Mechtilde
04:12:39 *** fabior has quit IRC
04:33:06 *** Aussie_matt has quit IRC
04:37:15 *** fabior has joined #gnucash
04:52:13 *** Aussie_matt has joined #gnucash
04:59:28 *** Mechtilde has quit IRC
05:15:26 *** Mechtilde has joined #gnucash
05:15:26 *** ChanServ sets mode: +v Mechtilde
06:27:36 *** oozer has joined #gnucash
06:35:34 *** Jimraehl1 has joined #gnucash
06:36:06 *** Jimraehl1 has left #gnucash
06:55:24 *** fabior has quit IRC
06:59:46 *** storyjesse has joined #gnucash
08:15:00 *** nicoroumeau has joined #gnucash
08:18:10 *** nicoroumeau has quit IRC
08:28:07 *** oozer has quit IRC
08:44:25 *** jervin has joined #gnucash
08:50:35 *** jervin has quit IRC
09:04:04 *** chris has quit IRC
09:07:55 *** fabior has joined #gnucash
09:11:07 *** chris has joined #gnucash
09:11:07 *** ChanServ sets mode: +v chris
09:37:58 *** Mechtilde has quit IRC
09:41:51 *** Mechtilde has joined #gnucash
09:41:51 *** ChanServ sets mode: +v Mechtilde
09:59:33 *** Mechtilde has quit IRC
10:30:23 *** oozer has joined #gnucash
11:23:45 *** Mechtilde has joined #gnucash
11:23:45 *** ChanServ sets mode: +v Mechtilde
11:26:17 *** fabior has quit IRC
11:35:59 *** nicoroumeau has joined #gnucash
11:38:04 *** nicoroumeau has quit IRC
11:38:27 *** nicoroumeau has joined #gnucash
11:40:13 *** nicoroumeau has quit IRC
11:41:30 *** jerryq has joined #gnucash
11:41:55 *** gjanssens has quit IRC
11:42:56 *** gjanssens has joined #gnucash
11:42:56 *** ChanServ sets mode: +o gjanssens
11:44:25 *** nicoroumeau has joined #gnucash
11:45:42 <Mechtilde> jralls, ping
11:46:28 <Mechtilde> do you have more questions? Otherwise I will correct the transyctions as I described in the bugreport
11:46:46 <Mechtilde> transactions
11:50:19 *** guak has joined #gnucash
11:50:33 *** Aussie_matt has quit IRC
12:05:19 <jralls> Mechtilde: When it fails to store the transaction changes does it put up an error dialog or just fail silently?
12:06:58 <Mechtilde> Open gnucash, reassign three or more entries, close gnucash. When I open gnucash again I saw the old entries
12:07:24 <Mechtilde> Open gnucash, reassign three or more entries, close gnucash with the right entries. When I open gnucash again I saw the old entries
12:07:46 *** nicoroumeau has quit IRC
12:08:12 <Mechtilde> no error message displayed
12:08:31 <Mechtilde> jralls, ^
12:08:36 *** fabior has joined #gnucash
12:11:22 <jralls> I saw. ;-) So maybe it's not even trying to write. Try running with --logto=stderr and --log gnc.backend.dbi=debug. It will spew all of your queries to the terminal while it loads. When it's loaded you can try changing a txn and see if an update query shows up on the terminal.
12:22:32 <Mechtilde> I will try "$ gnucash --logto=stderr --log gnc.backend.dbi=debug
12:35:11 <Mechtilde> jralls, first I send it privately to you, you can decide what is important for the bugtracker
12:35:52 <jralls> Mechtilde: Can't you just look and see if it spits out an update query after you change the transaction?
12:37:31 <jralls> If it does and there's more output after that then post just the update query and what came after. Feel free to obfuscate anything you think sensitive like the description or account name.
12:37:50 <jralls> But I suspect that it won't.
12:38:00 <Mechtilde> there are delete statements
12:38:04 *** nicoroumeau has joined #gnucash
12:38:12 <Mechtilde> which I don't understand
12:38:36 <jralls> Is there an insert or an update?
12:38:54 <Mechtilde> first an update
12:39:28 <Mechtilde> then a delete statement
12:39:36 <jralls> Interesting. OK, post everything starting with the update.
12:48:25 *** gncbot has joined #gnucash
12:48:35 *** nicoroumeau has quit IRC
12:49:51 <jralls> The first delete is just clearing the slots for the split. There probably weren't any.
12:54:38 *** nicoroumeau has joined #gnucash
12:55:02 <jralls> And although the raft of deletes at shutdown seems odd, it doesn't affect either the split or the transaction you modified. If you open mysql on the database and `select account_guid from splits where guid = '10f80439e4a2417c8ce52c433f2fadfc';` do you get 8c48b4719808b41a0ddadef5c428b01d?
12:55:39 *** fabior has quit IRC
12:56:14 <jralls> And does 'select name from accounts where guid = '8c48b4719808b41a0ddadef5c428b01d'; return the new account name or the old one?
12:58:54 *** nicoroumeau has quit IRC
12:59:53 <Mechtilde> it shows the new one after deleting gnucash
13:00:02 <Mechtilde> now I open it again
13:00:32 <jralls> "after deleting gnucash"?
13:00:40 <Mechtilde> I didn't see the new entry in the GUI
13:01:01 <Mechtilde> sorrry
13:01:07 <Mechtilde> s/deleting/closing
13:01:25 <jralls> Ah, that makes a difference! ;-)
13:02:48 <jralls> If you go to the bank account is the transfer account still Imbalance-EUR?
13:03:10 <Mechtilde> yes
13:05:55 <jralls> OK, rerun the split query in mysql. Is it also changed back?
13:07:12 <Mechtilde> the query shows the right entry
13:07:53 <Mechtilde> but not the bank account in the GUI
13:11:35 <jralls> That's *really* strange. How about `select name from accounts where guid = (select account guid from splits where tx_guid = 'c925e82c760242108042fc30aff0d32c');`
13:13:13 *** Mechtilde has quit IRC
13:13:30 *** Mechtilde has joined #gnucash
13:13:30 *** ChanServ sets mode: +v Mechtilde
13:13:58 *** storyjesse has quit IRC
13:16:21 <jralls> Mechtilde, did you see my last query?
13:16:49 <Mechtilde> yes
13:16:59 <Mechtilde> is there an underscore missing?
13:17:08 <Mechtilde> account_guid
13:17:37 <Mechtilde> then I get the Name of the bank account
13:18:16 <jralls> Yes, sorry. You should get two accounts.
13:19:09 *** jcamos has quit IRC
13:19:14 <Mechtilde> I get only one
13:19:56 <Mechtilde> select name from accounts where guid = (select account_guid from splits where tx_guid = 'c925e82c760242108042fc30aff0d32c')
13:19:57 <jralls> So maybe the txn_id on the split got changed? What does `select tx_guid from splits where guid = '10f80439e4a2417c8ce52c433f2fadfc';` produce?
13:20:32 <Mechtilde> empty
13:21:07 *** jcamos has joined #gnucash
13:21:07 *** ChanServ sets mode: +v jcamos
13:22:41 <jralls> OK, that explains why it's going back to imbalance, the split is getting separated from the txn. I bet `select guid from splits where tx_guid is null;` will return all of the splits you've tried to change.
13:23:22 <Mechtilde> I will try it
13:23:40 <Mechtilde> its empty
13:23:47 <Mechtilde> it's empty
13:24:55 <jralls> OK, empty string instead of null: `select guid from splits where tx_guid = '';`
13:25:35 <jralls> Anyway, try rerunning the update query: `UPDATE splits SET guid='10f80439e4a2417c8ce52c433f2fadfc',tx_guid='c925e82c760242108042fc30aff0d32c',account_guid='8c48b4719808b41a0ddadef5c428b01d',memo='',action='',reconcile_state='n',reconcile_date='1970-01-01 00:00:00',value_num=25956,value_denom=100,quantity_num=25956,quantity_denom=100 WHERE guid = '10f80439e4a2417c8ce52c433f2fadfc''`
13:25:45 <Mechtilde> is empy too
13:26:35 <Mechtilde> and now the update query
13:27:19 <jralls> Oh, got a ' at the end where I should have put a ;
13:27:50 <Mechtilde> I saw it
13:28:27 <Mechtilde> Query OK, 0 rows affected (0.000 sec)
13:30:21 <Mechtilde> You want to know what the problem is?
13:30:48 <Mechtilde> I can change the 12 entries new from importing the bank data
13:32:31 <jralls> Does `select * from splits where guid = '10f80439e4a2417c8ce52c433f2fadfc';` also return empty?
13:33:07 <Mechtilde> yes, empty set
13:33:57 <jralls> OK, so that split must have been deleted when the database loaded and GnuCash created a new imbalance split for the transaction.
13:35:28 <Mechtilde> that is what I understand from : * 18:26:04 DEBUG <gnc.backend.dbi> [GncDbiSqlConnection::execute_nonselect_statement] SQL: DELETE FROM slots WHERE obj_guid = '10f80439e4a2417c8ce52c433f2fadfc'
13:36:33 <jralls> No, that's deleting the slots for the split. Deleting the split itself would be "DELETE FROM splits WHERE guid = '10f80439e4a2417c8ce52c433f2fadfc'"
13:44:56 <jralls> The split existed when you closed gnucash so it must have been deleted when you restarted it and reloaded the database.
13:46:21 <Mechtilde> do you want to know the reason to fix sonething?
13:47:06 <jralls> You mean besides gnucash shouldn't be silently deleting splits?
13:47:15 <Mechtilde> or is it easier and quicker to renew the 12 entries manually
13:48:44 <Mechtilde> I have no knowlegde what happen but I guess it can't write the new date ober the old date because of changing the format of the column
13:49:37 <Mechtilde> so the "silently deleted splits are only the few entries till to that entry after changing the format of the column
13:50:13 <Mechtilde> so the "silently deleted splits" are only the few entries till to that entry after changing the format of the column
13:52:12 <Mechtilde> the entries I already renewed are ok. So for me it is ok to renew the other ones manually
13:52:23 <jralls> That's not what happened. It wrote the changed split just fine. We showed that with the first queries in mysql. You can prove it to yourself by rerunning the update query but change "update" to "insert".
13:53:20 <jralls> Anyway, if you're tired of debugging this it's OK. I have enough that I can set up a test database and debug on my own.
13:53:55 *** calvinct has joined #gnucash
13:54:18 <Mechtilde> you are the expert
13:57:18 *** Mechtilde has quit IRC
14:08:26 *** frakturfreak has joined #gnucash
14:08:52 *** nimish2711 has quit IRC
14:32:57 <fell> linas, can you check www.gnucash.org?
14:36:44 <mdf> Hi! I am working on testing old bugs to see if they are still relevant (I sent an email to the list a few weeks ago to introduce myself). I'm trying to go about things with certainty so I don't offend anyone, so what would the folks here thoughts on this bug be? https://bugs.gnucash.org/show_bug.cgi?id=722903 I know there has been a lot of GUI changed between 2.6 and 3 as well as there was quite a bit of performance tweaks over
14:36:44 <mdf> the past 8 months or so as well. Should this be left open and just asked for comments or should it be closed with a comment with my summary?
14:37:19 <fell> And dont forget to "/Msg Nickserv ..." or "@identify ..."
14:45:01 <fell> mdf: Oha, the meta bug about performance loss from 2.4 to 2.6. Perhaps the O.P. gjanssens should decide.
14:46:08 <mdf> fair. I'll let him have a chance to weigh in and revisit it later. I'm just hitting easy ones for now. :)
14:46:58 <jralls> fell: I got to linas by email, fixed now.
14:47:16 <fell> Thx. jralls!
15:02:29 *** kapil___ has quit IRC
15:08:44 *** calvinct has quit IRC
15:45:17 *** link has joined #gnucash
15:46:48 *** Unhammer has quit IRC
15:53:05 *** fell has quit IRC
15:54:50 *** fell has joined #gnucash
15:54:50 *** ChanServ sets mode: +o fell
15:56:37 *** Unhammer has joined #gnucash
16:09:27 *** Agfarmer18 has joined #gnucash
16:11:37 *** Agfarmer18 has quit IRC
16:12:02 *** nicoroumeau has joined #gnucash
16:14:02 *** jervin has joined #gnucash
16:14:56 *** nicoroumeau has quit IRC
16:38:35 *** jervin has quit IRC
16:48:20 <fell> Jralls, recently a few people got git write access. Should they also be promoted on uservoice, github, sourceforge, ...
16:50:34 <fell> bugzilla
16:54:29 <jralls> fell: They're already set up on Github and BZ. Sourceforge is just for the releases, no need for there. I don't know if they have any need for UserVoice. gjanssens?
16:55:48 <fell> I think scheme suggestins are of interest for chris as example.
16:56:53 *** frakturfreak has quit IRC
16:57:05 *** calvinct has joined #gnucash
17:11:36 <jralls> fell: Well, he does have an account there, but if I try "edit permissions" I just get a dialog with his name and Cancel and Submit buttons, nothing to edit.
17:16:18 <fell> jralls: Same here, probably because chris never confirmed his email address.
17:17:48 <jralls> So if he decides he wants more access he can ask when he's ready.
17:19:36 *** jcamos has quit IRC
17:20:17 *** tienne has joined #gnucash
17:20:36 <fell> BTW he has at least 2 adresses there.
17:20:53 <jralls> He does? I only found one.
17:21:21 <jralls> I searched for "lam". What did you search for?
17:21:51 <fell> mmr...uk and chris...com
17:22:21 <fell> searching for "christopher lam"
17:27:29 *** Agfarmer18 has joined #gnucash
17:27:48 <chris> jralls: guile-2.2 - if a report has unicode in report-title, the unicode is saved in 2 places in book.gcm
17:27:49 <jralls> With that search I get mmr... as Chris Lam (with Lam highlighted) and 4 other Christophers with no reason to think that they're chris.
17:27:51 <chris> 1) PageName is UTF8 and is reloaded intact
17:27:55 <chris> 2) SchemeOptions is UTF8 and is reloaded mangled.
17:27:58 *** Agfarmer18 has quit IRC
17:27:58 <chris> might be worth while repeat https://bugs.gnucash.org/show_bug.cgi?id=796728#c19 experiment with unicode in report-title
17:28:01 <chris> gnc-plugin-page-report.c:935
17:28:09 <jralls> Speak of the devil. ;-)
17:28:43 <fell> The 2. last was used on core
17:29:09 <jralls> I'm working on the Guile side ATM, getting a bug and a patch ready to submit to them.
17:29:17 <jralls> fell: I don't understand.
17:30:11 *** jcamos has joined #gnucash
17:30:11 *** ChanServ sets mode: +v jcamos
17:30:23 <fell> chistopher...@gmail,,, was reported by gjanssens on core.
17:31:22 *** gjanssens has quit IRC
17:40:31 *** jcamos has quit IRC
17:40:42 *** jcamos has joined #gnucash
17:40:42 *** ChanServ sets mode: +v jcamos
17:41:04 <jralls> OK, I've looked at that chris's comments and it's the same. He hasn't confirmed that email either so there's nothing we can do with it until he does.
17:45:01 *** calvinct has quit IRC
17:46:31 *** nicoroumeau has joined #gnucash
17:46:50 *** jcamos has quit IRC
17:48:09 *** nicoroumeau has quit IRC
17:48:14 *** jcamos has joined #gnucash
17:48:14 *** ChanServ sets mode: +v jcamos
17:52:40 *** jcamos has quit IRC
17:52:50 *** jcamos has joined #gnucash
17:52:50 *** ChanServ sets mode: +v jcamos
17:53:17 *** guak has quit IRC
17:55:05 *** jcamos has quit IRC
18:02:58 *** jcamos has joined #gnucash
18:02:59 *** ChanServ sets mode: +v jcamos
18:05:12 *** jcamos has quit IRC
18:17:07 *** jerryq has quit IRC
18:53:15 *** jervin has joined #gnucash
18:56:47 *** jervin has quit IRC
19:06:22 *** Agfarmer18 has joined #gnucash
19:13:30 *** Agfarmer18 has quit IRC
19:15:45 *** jerryq has joined #gnucash
19:29:46 *** tienne has quit IRC
19:32:05 *** Aussie_matt has joined #gnucash
19:44:40 <jralls> chris: I just pushed your new CMakeLists.txt to your repo.
21:54:51 *** bertbob has quit IRC
21:59:38 *** bertbob has joined #gnucash
21:59:40 *** ChanServ sets mode: +v bertbob
22:06:46 *** link has quit IRC
22:40:44 *** jralls has quit IRC
22:48:20 *** oozer has quit IRC
22:48:32 *** Cork has quit IRC
22:49:11 *** Cork has joined #gnucash
22:51:58 *** jralls has joined #gnucash
22:51:59 *** ChanServ sets mode: +o jralls
23:02:06 *** bertbob has quit IRC
23:22:02 *** nimish2711 has joined #gnucash
23:28:48 *** FoxT has quit IRC
23:35:12 *** FoxT has joined #gnucash