2018-12-14 GnuCash IRC logs
00:03:17 *** jrp has joined #gnucash
00:06:14 *** jrp has quit IRC
00:17:30 *** dex_john7777777 has joined #gnucash
00:20:49 *** dex_john7777777 has left #gnucash
00:44:43 *** nimish has joined #gnucash
00:46:10 *** nimish has quit IRC
00:46:37 *** nimish has joined #gnucash
00:56:16 *** storyjesse has joined #gnucash
01:04:00 *** jrp has joined #gnucash
01:07:00 *** jrp has quit IRC
01:37:34 *** fell has quit IRC
01:37:53 *** gour has joined #gnucash
01:38:52 *** fell has joined #gnucash
02:02:56 *** Mechtilde has quit IRC
02:05:00 *** jrp has joined #gnucash
02:08:00 *** jrp has quit IRC
02:13:45 *** storyjesse has quit IRC
02:32:33 *** jotrago has quit IRC
02:39:12 *** CDB-Man has quit IRC
02:39:15 *** CDB-Away has quit IRC
02:43:12 *** CDB-Man has joined #gnucash
02:44:02 *** CDB-Away has joined #gnucash
03:05:45 *** jrp has joined #gnucash
03:06:49 *** Mechtilde has joined #gnucash
03:07:22 *** GabrieleV has quit IRC
03:08:45 *** jrp has quit IRC
03:09:25 *** GabrieleV has joined #gnucash
03:25:28 *** _StratoSwitch_ has joined #gnucash
03:56:48 *** finster_ has joined #gnucash
04:06:30 *** jrp has joined #gnucash
04:09:33 *** jrp has quit IRC
04:16:29 *** nimish has quit IRC
04:16:58 *** nimish has joined #gnucash
04:19:29 *** ncv has joined #gnucash
04:31:49 *** nimish has quit IRC
04:32:18 *** nimish has joined #gnucash
04:33:14 *** Aussie_matt has quit IRC
04:36:57 *** bertbob has quit IRC
04:43:30 *** bertbob has joined #gnucash
04:46:34 *** bertbob has quit IRC
04:52:10 *** nimish has quit IRC
04:52:39 *** nimish has joined #gnucash
05:02:19 *** bertbob has joined #gnucash
05:07:15 *** jrp has joined #gnucash
05:10:20 *** ncv has quit IRC
05:10:20 *** ncv_ has joined #gnucash
05:13:02 *** bertbob has quit IRC
05:15:21 *** jrp has quit IRC
05:18:59 *** bertbob has joined #gnucash
05:22:35 *** User_ has joined #gnucash
05:26:55 *** Mechtilde has quit IRC
05:44:32 *** CrtxReavr has joined #gnucash
05:44:42 *** User_ has quit IRC
05:47:32 *** nimish has quit IRC
05:48:06 *** nimish has joined #gnucash
05:53:05 *** Aussie_matt has joined #gnucash
06:08:21 *** oozer has joined #gnucash
06:13:13 *** jrp has joined #gnucash
06:16:13 *** jrp has quit IRC
06:26:21 *** Jimraehl1 has joined #gnucash
06:28:10 *** Jimraehl1 has left #gnucash
06:40:01 *** Aussie_matt has quit IRC
06:42:59 *** nimish has quit IRC
06:43:30 *** nimish has joined #gnucash
06:48:22 *** nimish has quit IRC
06:48:57 *** nimish has joined #gnucash
06:52:19 *** finster_ has quit IRC
06:53:43 *** nimish has quit IRC
06:54:18 *** nimish has joined #gnucash
06:58:16 *** Mechtilde has joined #gnucash
06:59:10 *** nimish has quit IRC
06:59:40 *** nimish has joined #gnucash
07:08:48 *** KaiForce has joined #gnucash
07:09:31 *** nimish has quit IRC
07:09:59 *** nimish has joined #gnucash
07:21:53 *** darkalia has joined #gnucash
07:23:39 *** mueslix has joined #gnucash
07:54:35 *** kapil___ has quit IRC
08:12:49 *** philippirrip has joined #gnucash
08:14:24 *** jrp has joined #gnucash
08:17:33 *** jrp has quit IRC
08:23:00 *** jotrago has joined #gnucash
08:28:42 *** nimish has quit IRC
08:35:32 <warlord> .
08:49:49 *** nimish has joined #gnucash
08:53:09 *** ajibade_ has joined #gnucash
08:59:26 *** ajibade_ has quit IRC
08:59:59 *** kapil___ has joined #gnucash
09:15:17 *** jrp has joined #gnucash
09:18:18 *** jrp has quit IRC
09:21:08 *** jrok has joined #gnucash
09:24:03 <jrok> Sorry, I got disconnected yesterday afternoon, but did anyone have any ideas why my data amounts would have zeroed out after the migration from 2.6.19 to 3.3? is this a known issue?
09:24:55 <warlord> jrok: sorry, don't think I was around yesterday -- how are they zeroed out?
09:25:44 <jrok> the transactions seem to all be there but all the splits are zero.. ?
09:26:19 <warlord> How do you know the splits are zero?
09:26:33 <warlord> What OS/Distro?
09:27:04 <jrok> actually, check that - the splits appear blank in the application
09:27:10 <jrok> ubuntu 18.04
09:27:19 <jrok> the txn shows zero
09:27:30 <warlord> Do you have values in your CoA?
09:28:09 <jrok> database looks right
09:28:17 <warlord> database?
09:28:58 <jrok> postgresql backend
09:29:05 <jrok> all balances are 0
09:29:40 *** nimish has quit IRC
09:30:10 *** nimish has joined #gnucash
09:30:14 <warlord> Chart of Account shows 0 balances... So could be a PG backend issue.
09:30:34 <warlord> If you go back to 2.6.19, save-as XML, and then load the XML into 3.3, do you have valid data?
09:30:53 *** User_ has joined #gnucash
09:31:06 <warlord> (For the record, we still don't completely recommend using SQL backends)
09:31:11 <warlord> s/we/I
09:32:52 <jrok> fair, but the sql backend brings a ton of value for me. :)
09:33:24 <jrok> can i go from xml back to postgres?
09:33:56 *** User_ has quit IRC
09:39:29 <jrok> not arguing, just providing perspective - being able to run raw sql queries against the database is huge for me & my business, was one of the things that drew me to gnucash to begin with...
09:39:50 <jrok> anyway, i'm trying to revert to 2.6.19 to see what happens saving to xml
09:42:33 <warlord> jrok: yes, File -> Save As should work in both directions.
09:43:13 <warlord> The SQL backends are still "new", and I suspect upgrade from 2.6 to 3.x was not fully tested.
09:43:45 <warlord> Another possible issue is that your system currency could have changed -- did you upgrade the system at the same time as you upgraded gnucash?
09:45:18 <jrok> using a sandbox and a database dump, I didn't update on my "prod" system
09:45:35 <jrok> okay, amounts came over after reverting to 2.6 and then upgrading to 3.x
09:46:34 <warlord> so you reverted to 2.6, sql -> xml, upgrade to 3.3... that's where you are now? Next try xml -> sql
09:47:45 <jrok> yep!
09:48:07 <jrok> got it. was able to successfully save to sql and change a db record
09:48:07 <warlord> Interesting. Can you please save a copy of the original database for future testing?
09:48:39 <warlord> This is clearly a bug -- 3.3 should be able to successfully read a 2.6 sql db
09:48:44 <warlord> please file a bug report.
09:49:06 <warlord> It would be even more useful if you could somehow submit a "test DB" that shows the bug (but this might not be possible)
09:49:22 <jrok> was able to successfully exit the application and return and values show up
09:49:59 <warlord> okay.
09:50:17 <warlord> So now let's see if we can narrow it down for developer debugging (and bug reporting)
09:50:32 <warlord> Assuming you're willing to help us debug (and fix) the problem?
09:51:03 <jrok> warlord: you maybe weren't in here yesterday but initially i was unable to import my business database, which came down to the application not liking data in the taxtables table
09:51:23 <jrok> import is the wrong word
09:51:54 <jrok> application crashed when trying to launch after updating
09:52:37 <jrok> absolutely I'm willing to help!
09:53:18 <warlord> Great. Thanks.
09:53:52 <warlord> Hopefully jralls or gjanssens can pipe up about what they would need. Or you could try to find a minimal database, that you're willing to share, that exhibits the problem.
09:54:24 <jrok> my personal database had the same problem, where the amounts didn't display in the application after upgrade
09:54:59 <jrok> you folks are awesome - thanks
09:55:03 *** nimish has quit IRC
09:55:44 *** nimish has joined #gnucash
10:01:36 <jrok> bug 796977
10:06:59 *** boldstripe has joined #gnucash
10:15:30 *** nimish has quit IRC
10:16:01 *** nimish has joined #gnucash
10:16:25 *** jrp has joined #gnucash
10:18:21 <chris> jrok would be good to populate the bug report with types of data e.g. currencies used, tax-table entries, account currencies & types
10:19:08 <chris> it would help devs create the offending data, replicate the bug and fix it.
10:19:20 <chris> also: OS, gnucash versions used, and if possible, a test datafile
10:19:25 *** jrp has quit IRC
10:21:02 * chris wonder if http://i.imgur.com/MTs4dHS.png would be a good UI for envelope-budget
10:34:45 *** boldstripe_ has joined #gnucash
10:34:55 *** boldstripe has quit IRC
10:34:55 *** boldstripe_ is now known as boldstripe
10:39:30 <jrok> chris: I can do that
10:46:02 <fell> jrok: More questions: locale settings;? DB on localhost or some remote machine?
10:49:47 *** tcsc has joined #gnucash
10:51:47 *** Mechtilde has quit IRC
10:56:07 <warlord> chris: unless jrok can upload a DB dump! :)
11:00:53 *** nimish has quit IRC
11:01:22 *** nimish has joined #gnucash
11:11:28 <jrok> db on localhost
11:13:16 <jrok> not 100% sure where you want me to look for locale settings... on the db?
11:14:55 <jrok> in gnucash it's USD
11:15:42 <fell> Your language settings of OS and DB.
11:17:12 *** jrp has joined #gnucash
11:17:46 <jrok> en_US.UTF8
11:18:53 <warlord> jrok: please make sure all this is in the bug report, too :)
11:20:12 *** jrp has quit IRC
11:21:14 *** nimish has quit IRC
11:21:42 *** nimish has joined #gnucash
11:21:52 <jrok> added locale and OS to bug report
11:44:07 *** GabrieleV has quit IRC
11:44:35 *** kapil___ has quit IRC
11:50:39 *** GabrieleV has joined #gnucash
12:01:55 *** nimish has quit IRC
12:02:19 *** KevinDB has quit IRC
12:05:46 *** KevinDB has joined #gnucash
12:06:11 *** gjanssens has joined #gnucash
12:06:12 *** ChanServ sets mode: +o gjanssens
12:12:34 <gjanssens> .
12:18:12 *** jrp has joined #gnucash
12:21:12 *** jrp has quit IRC
12:21:12 *** tienne has joined #gnucash
12:29:41 *** tienne has quit IRC
12:30:13 *** tienne has joined #gnucash
12:32:27 *** tienne has quit IRC
12:33:00 *** tienne has joined #gnucash
12:37:58 *** boldstripe has quit IRC
12:42:22 *** Mechtilde has joined #gnucash
12:49:32 *** Agfarmer18 has joined #gnucash
12:54:51 *** calvinct has joined #gnucash
13:03:06 *** Mechtilde has quit IRC
13:03:45 *** Mechtilde has joined #gnucash
13:12:46 *** ncv_ has quit IRC
13:13:05 *** tienne has quit IRC
13:16:38 *** tienne has joined #gnucash
13:18:57 *** jrp has joined #gnucash
13:21:58 *** jrp has quit IRC
13:46:26 *** tienne has quit IRC
13:48:12 *** tienne has joined #gnucash
13:48:21 *** boldstripe has joined #gnucash
14:04:49 *** kirkland has joined #gnucash
14:10:19 *** frakturfreak has joined #gnucash
14:14:57 *** puck has quit IRC
14:18:38 *** puck has joined #gnucash
14:20:00 *** jrp has joined #gnucash
14:23:00 *** jrp has quit IRC
14:35:41 *** calvinct has quit IRC
14:40:56 *** finster has joined #gnucash
14:48:50 *** lavish__ has joined #gnucash
15:20:26 *** jrp has joined #gnucash
15:23:26 *** jrp has quit IRC
15:51:35 *** boldstripe has quit IRC
15:58:12 *** Mechtilde has quit IRC
16:21:00 *** calvinct has joined #gnucash
16:21:17 *** jrp has joined #gnucash
16:24:17 *** jrp has quit IRC
16:36:35 *** gjanssens has quit IRC
16:39:20 *** calvinct has quit IRC
16:55:15 *** gour1 has joined #gnucash
16:57:02 *** gour has quit IRC
17:20:21 *** storyjesse has joined #gnucash
17:22:32 *** jrp has joined #gnucash
17:25:32 *** jrp has quit IRC
17:35:36 *** Agfarmer18 has quit IRC
17:35:44 *** Agfarmer18 has joined #gnucash
17:37:05 *** Agfarmer18 has quit IRC
17:40:55 *** Agfarmer18 has joined #gnucash
17:42:25 *** Agfarmer18 has quit IRC
17:47:09 *** jrok has quit IRC
18:01:33 *** frakturfreak has quit IRC
18:06:14 *** gour1 has quit IRC
18:10:42 *** KaiForce has quit IRC
18:11:49 *** jrok has joined #gnucash
18:21:12 *** Aussie_matt has joined #gnucash
18:27:19 *** jrok has quit IRC
18:32:14 *** jrok has joined #gnucash
18:35:35 *** jrok has quit IRC
18:37:05 *** jrok has joined #gnucash
18:40:38 *** jrok has quit IRC
18:57:15 *** stoffepojken7 has joined #gnucash
18:58:39 *** Aussie_matt has quit IRC
18:59:00 *** atomicman has joined #gnucash
19:08:49 *** jrok has joined #gnucash
19:16:19 *** jrok has quit IRC
19:24:08 *** jrp has joined #gnucash
19:27:08 *** jrp has quit IRC
19:29:49 *** jrok has joined #gnucash
19:45:16 *** jrok has quit IRC
19:48:34 *** jrok has joined #gnucash
19:54:44 *** jrok has quit IRC
20:09:30 *** jrok has joined #gnucash
20:18:16 *** storyjesse has quit IRC
20:24:59 *** jrp has joined #gnucash
20:27:59 *** jrp has quit IRC
20:29:05 *** mpeters-wrs has joined #gnucash
20:44:46 *** oozer has quit IRC
20:55:33 *** jrok has quit IRC
21:08:44 *** jrok has joined #gnucash
21:11:47 *** jrok has quit IRC
21:21:14 *** jrok has joined #gnucash
21:24:31 *** kusmario has joined #gnucash
21:24:40 *** jrok has quit IRC
21:25:38 *** jrp has joined #gnucash
21:28:39 *** jrp has quit IRC
21:53:39 *** Aussie_matt has joined #gnucash
22:02:31 *** marusich has joined #gnucash
22:11:19 *** tienne has quit IRC
22:13:07 *** jrok has joined #gnucash
22:19:19 *** jrok has quit IRC