2018-05-19 GnuCash IRC logs
00:20:45 *** pilotauto has quit IRC
01:03:06 *** Mechtilde has joined #gnucash
01:22:04 *** fell_laptop has joined #gnucash
01:23:42 *** fell has quit IRC
01:24:31 *** frank_laptop_ has quit IRC
01:24:55 *** fell has joined #gnucash
01:29:03 *** Mechtilde has quit IRC
02:25:39 *** storyjesse has joined #gnucash
02:31:14 *** Mechtilde has joined #gnucash
02:59:12 *** Mechtilde has quit IRC
03:19:49 *** gour has joined #gnucash
03:55:49 *** Mechtilde has joined #gnucash
04:19:10 *** mikee has quit IRC
04:19:12 *** gjanssens has joined #gnucash
04:19:12 *** ChanServ sets mode: +o gjanssens
04:20:17 <gjanssens> .
04:50:37 *** mikee has joined #gnucash
04:50:38 *** gncbot sets mode: +o mikee
05:15:55 *** Mechtilde has quit IRC
05:16:19 *** Mechtilde has joined #gnucash
05:26:45 *** Mechtilde has quit IRC
05:28:16 *** Mechtilde has joined #gnucash
05:40:11 *** mipesom has quit IRC
05:51:04 *** Mechtilde has quit IRC
05:52:28 *** Mechtilde has joined #gnucash
05:56:57 *** mipesom has joined #gnucash
06:10:54 *** fabior has joined #gnucash
06:11:33 *** Aussie_matt has joined #gnucash
06:34:16 *** Mechtilde has quit IRC
06:52:15 *** fabior has quit IRC
06:54:10 *** fabior has joined #gnucash
06:55:34 *** Mechtilde has joined #gnucash
07:10:43 *** Mechtilde has quit IRC
07:11:14 *** harshitaneja has joined #gnucash
07:13:44 *** fabior has quit IRC
07:45:01 *** ncv has joined #gnucash
07:50:23 *** GabrieleV has quit IRC
07:55:41 *** GabrieleV has joined #gnucash
08:09:16 *** harshitaneja has quit IRC
08:09:49 *** harshitaneja has joined #gnucash
08:16:22 *** harshitaneja has quit IRC
08:19:08 *** harshitaneja has joined #gnucash
08:24:36 *** Mechtilde has joined #gnucash
08:43:06 *** oozer has joined #gnucash
08:50:41 *** fabior has joined #gnucash
08:52:17 *** harshitaneja has quit IRC
08:55:17 *** harshitaneja has joined #gnucash
09:01:57 *** Jimraehl1 has joined #gnucash
09:02:19 *** Jimraehl1 has left #gnucash
09:28:22 *** Cuare has quit IRC
09:53:24 *** chris has joined #gnucash
09:53:29 *** chris has quit IRC
09:53:47 *** chris has joined #gnucash
09:53:53 <chris> .
09:53:53 <gncbot> chris: Sent 21 hours and 38 minutes ago: <gjanssens> I quickly looked at test-invoice.scm yesterday and I see your issue. I haven't had time to figure it out yet...
09:54:55 <chris> @tell gjanssens thank you for looking into this for me. at least I know I'm not seeing things. I've tried various combinations of (gnc-numeric-create) instead of numbers directly, still no dice. Ah well.
09:54:55 <gncbot> chris: The operation succeeded.
10:06:09 *** chris has quit IRC
10:31:33 *** chris has joined #gnucash
10:32:07 *** Mechtilde has quit IRC
10:33:25 <chris> @tell gjanssens - further experiments - 100% discount does successfully nullify gncEntry invoice amount, and 200% discount also works.
10:33:25 <gncbot> chris: The operation succeeded.
10:52:12 *** rob has joined #gnucash
10:53:22 *** User has joined #gnucash
10:53:24 *** Mechtilde has joined #gnucash
10:54:47 *** storyjesse has quit IRC
10:56:27 *** User has quit IRC
11:06:45 *** eagles0513875 has quit IRC
11:36:12 *** Aussie_matt has quit IRC
12:05:28 <rob> I’m running into a problem where postgresql has reset my primary keys, does anyone have any pointers of where I can look to figure out how to find the sequence names used in the default gnucash database?
12:09:26 *** badger92 has quit IRC
12:21:16 *** robert has joined #gnucash
12:26:49 <rob> found it… ‘\d+’ is the postgresql equivalent of ‘DESCRIBE’, which showed the sequences used with the table
12:26:57 <rob> problem resolved with: select setval('slots_new_id_seq', (SELECT max(id) FROM slots));
12:30:32 *** ncv has quit IRC
12:30:51 *** ncv has joined #gnucash
12:54:59 *** gour_ has joined #gnucash
12:57:17 *** gour has quit IRC
12:57:18 *** rob has quit IRC
13:02:32 *** ncv has quit IRC
13:02:42 *** ncv has joined #gnucash
13:11:35 *** james has joined #gnucash
13:12:16 *** fabior has quit IRC
13:12:25 <james> Can anyone help me understand how to migrate my mysql db from 2.6.19 to 3.1.x?
13:12:36 <james> When I connect, it's dropping ALL my data
13:12:46 <james> (thank God for database backups)
13:13:42 <james> I know the schema has changed, so maybe there's a migration script I can run from my backup to convert to the new schema?
13:19:01 *** ncv has quit IRC
13:22:21 *** harshitaneja has quit IRC
13:23:13 <james> I'm going to restore the db, then try 'saving as' from 2.6.19 to a new db, and comparing the results to see if that exports the new schema
13:27:48 <james> this is related to the bugzilla item I filed (https://bugzilla.gnome.org/show_bug.cgi?id=796117)
13:27:55 *** Mechtilde has quit IRC
13:36:21 <james> nope; 'save as' kept the old schema
13:38:51 <james> going to try with 2.6.21
13:47:47 *** oozer has quit IRC
13:52:43 *** gour_ is now known as gour
14:07:43 <jralls> james: Try running GnuCash with --log gnc.backend.dbi=debug. That will show all of the queries sent to MySql in the tracefile.
14:09:34 <jralls> james: The only schema change is timestamp->datetime, which should be transparent.
14:11:25 <james> I agree, it should be
14:11:40 <james> but I also noticed I never changed from the default encoding of latin-1-swedish
14:11:53 <james> in some of the log files, I see "weird" characters
14:12:04 <james> so I wonder if the conversion balked at that?
14:12:12 <james> I'll try your suggestion of --log ...
14:12:53 <james> do the command line arguments work for windows?
14:13:19 <james> (i dual boot with Ubuntu, so I could switch to that if needed)
14:13:51 *** frakturfreak has joined #gnucash
14:14:13 <jralls> james: That's on you, then. The default encoding must be UTF-8.
14:14:41 <jralls> james: Yes, the command line arguments work from Windows.
14:14:42 <james> sorry, I used the wrong term
14:15:02 <james> it's the "table collation" that is "latin1_swedish_ci"
14:15:07 <james> which is (was?) the default
14:15:50 <james> the "default character set" is reporting as "latin1"
14:15:59 <james> I'll try updating that to UTF-8
14:16:09 <james> (why that isn't standard for my hosting provider, I don't know)
14:17:06 <jralls> james: It's the well-documented default for MySQL. You seem to be failing the prerequisite of being an experienced MySQL DBA, you should switch to SQLite3 or XML.
14:17:38 <james> I used mysql to enable me to work from multiple machines (I move around too much)
14:17:44 <james> and for custom reportings
14:17:46 <james> and for custom reporting
14:17:57 <james> though, true, I'm no dba, just a software guy
14:18:31 <jralls> You can get the same from SQLite3 on a service like dropbox or google drive.
14:21:36 <james> since I can open the data in 2.6.19/21, would "Save as" to sqlite3 "just work"? If so, I take the hit on the ego and go that route
14:22:27 <james> that and verify my reporting tool supports sqlite
14:24:33 <jralls> The save as in 2.6.19 should "just work". Then you can copy the SQLite3 file and try opening it with 3.1 with the gnc.backend.dbi=debug and read the queries to see where it's failing. It seems from the presence of accounts_back that restoring the tables from a full save is going horribly wrong.
14:24:53 <jralls> GTG, back in a couple of hours.
14:25:11 <james> thanks :)
14:28:08 <james> I see reports that my report tool ought to support sqlite; going to give that a go
14:28:17 <james> Thanks for the support!
14:35:58 *** Mechtilde has joined #gnucash
14:57:04 *** oozer has joined #gnucash
14:59:06 *** marusich has joined #gnucash
15:57:29 *** Mechtilde has quit IRC
16:12:11 *** gjanssens has quit IRC
16:32:49 *** mdf has joined #gnucash
16:51:01 *** ncv has joined #gnucash
16:54:59 *** ncv has quit IRC
16:56:36 *** ncv has joined #gnucash
17:22:01 *** boldstripe has quit IRC
17:42:48 *** jonas_ has joined #gnucash
17:44:48 *** jonas has quit IRC
18:14:22 *** ncv has quit IRC
18:25:08 *** james has quit IRC
18:57:07 *** luc14n0 has quit IRC
18:57:14 *** luc14n0 has joined #gnucash
19:28:37 *** harshitaneja has joined #gnucash
19:42:46 *** harshitaneja has quit IRC
19:43:23 *** harshitaneja has joined #gnucash
19:47:28 *** harshitaneja has quit IRC
19:48:06 *** harshitaneja has joined #gnucash
20:15:09 *** paul has joined #gnucash
20:15:18 *** paul has left #gnucash
20:33:19 *** gour has quit IRC
20:41:39 *** fell_laptop has quit IRC
20:44:42 *** fell_laptop has joined #gnucash
21:12:00 *** fell_laptop has quit IRC
21:16:03 *** bertbob has quit IRC
21:19:37 *** bertbob has joined #gnucash
21:35:54 *** oozer has quit IRC
23:22:43 *** boldstripe has joined #gnucash