2014-01-08 GnuCash IRC logs
00:41:32 *** raeburn has quit IRC
00:46:23 *** raeburn has joined #gnucash
01:22:32 *** fuzzybunny69y has quit IRC
01:39:13 *** fell has quit IRC
02:00:52 *** goibhniu has joined #gnucash
02:00:58 *** uXus has quit IRC
02:25:57 *** goibhniu has quit IRC
02:34:40 *** aqua___ has joined #gnucash
02:46:27 *** jmd has joined #gnucash
03:00:13 *** jmd has quit IRC
03:46:17 *** jmd has joined #gnucash
03:47:19 *** jmd has quit IRC
04:02:07 *** aqua___ has quit IRC
04:09:57 *** john has quit IRC
04:56:19 *** jmd has joined #gnucash
05:06:35 *** jmd has joined #gnucash
05:11:58 *** jmd has quit IRC
06:34:45 *** fuzzybunny69y has joined #gnucash
06:41:47 *** Jimraehl has joined #gnucash
06:46:52 *** Jimraehl has quit IRC
07:02:34 *** Jimraehl has joined #gnucash
07:05:44 *** jmd has joined #gnucash
07:08:41 *** jmd has quit IRC
07:08:42 *** Jimraehl has quit IRC
08:04:19 *** aqua___ has joined #gnucash
08:14:28 *** mikee_ is now known as mikee
08:14:37 <mikee> @op
08:14:37 <gncbot> mikee: Error: You don't have the #gnucash,op capability. If you think that you should have this capability, be sure that you are identified before trying again. The 'whoami' command can tell you if you're identified.
08:14:49 *** mikee is now known as mikee_
08:14:55 *** mikee_ is now known as mikee
08:15:31 <mikee> @op
08:15:31 *** gncbot sets mode: +o mikee
08:17:40 *** jmd has joined #gnucash
08:36:01 *** fell has joined #gnucash
08:36:01 *** gncbot sets mode: +o fell
08:44:12 *** jmd has quit IRC
08:44:13 *** jmd has joined #gnucash
08:53:43 *** jmd has quit IRC
08:53:43 *** jmd has joined #gnucash
09:06:23 <warlord> wiggin: did you get it working?
09:07:15 <warlord> noughth: You mean single quotes in e.g. account names?>
09:15:17 <noughth> warlord: yes. I actually came up with a possible patch last night after I posted that: https://bugzilla.gnome.org/show_bug.cgi?id=721768
09:15:59 <noughth> that patch fixes the issue that I was seeing, but I'm not all sure its the *right* way to go about doing so
09:16:14 <noughth> not at all*
09:20:00 *** rpg has joined #gnucash
09:27:09 <warlord> noughth: Yeah, probably not the right solution. We probably want to call a "html_escape" api..
09:27:38 <warlord> because < or > chars (amongst others) might also cause issues.
09:30:11 <noughth> warlord: well, since these end up inside JavaScript strings, HTML characters ought to be fine, right?
09:31:19 <noughth> or are you saying jqplot doesn't do any escaping of its own before turning those strings into actual HTML?
09:36:30 <warlord> noughth: I dont know...
09:37:33 <noughth> okay, I can test a few things later tonight when I have a little more time to see what screws it up
09:41:18 <warlord> Okay. If it's just a quote then that's fine (although I'd still make an 'escape-quote' procedure and use that instead of what you did..
09:41:39 <noughth> right, by no means am I trying to argue that my method is the best :P
09:43:57 <warlord> I know. I'm trying to help you improve it. :)
09:44:06 <noughth> I suspect there may be other places that need the same type of escaping, they just weren't close enough to match my grepping last night
09:44:53 <noughth> warlord: do you have a recommended scheme/guile tutorial? I learned *just* enough of it last night to cobble that patch together.
09:45:51 <warlord> google for "MIT Scheme Reference"
09:51:23 <noughth> warlord: okay, thanks for your help! I'll be back when I have another patch.
09:54:10 *** jmd has left #gnucash
09:56:11 <warlord> Good luck!
09:58:18 *** aqua___ has quit IRC
09:59:53 *** mikee has quit IRC
10:05:49 *** mikee has joined #gnucash
10:05:50 *** gncbot sets mode: +o mikee
10:07:24 *** mikee has quit IRC
10:19:05 *** mikee_ has joined #gnucash
10:19:49 *** mikee_ is now known as mikee
10:19:53 <mikee> @op
10:19:54 *** gncbot sets mode: +o mikee
10:26:29 *** mikee has quit IRC
10:28:45 *** mikee_ has joined #gnucash
10:28:46 *** gncbot sets mode: +o mikee_
10:31:17 <mikee_> @op
10:31:18 *** gncbot sets mode: +o mikee_
10:31:25 *** mikee_ is now known as mikee
11:28:20 *** ErKa has joined #gnucash
11:43:58 *** jmd has joined #gnucash
11:52:48 *** TradeBorG113 has joined #gnucash
11:54:16 *** benoitg has joined #gnucash
12:11:26 *** mikee has quit IRC
12:18:46 *** mikee_ has joined #gnucash
12:18:47 *** gncbot sets mode: +o mikee_
12:19:16 <mikee_> @op
12:19:17 *** gncbot sets mode: +o mikee_
12:48:12 *** Krzysiek_K has joined #gnucash
12:49:43 *** todd_ has joined #gnucash
12:50:09 *** todd has quit IRC
12:55:21 *** Krzysiek_K has left #gnucash
13:11:51 *** mikee_ has quit IRC
13:16:12 *** mikee_ has joined #gnucash
13:16:12 *** gncbot sets mode: +o mikee_
13:17:30 *** mikee_ is now known as mikee
13:44:29 *** mikee has quit IRC
14:04:34 *** mikee_ has joined #gnucash
14:04:35 *** gncbot sets mode: +o mikee_
14:04:38 *** mikee_ is now known as mikee
14:04:45 <mikee> @op
14:04:46 *** gncbot sets mode: +o mikee
14:04:51 *** mikee is now known as mikee-afk
15:08:56 *** goibhniu has joined #gnucash
15:37:38 *** fuzzybunny69y has quit IRC
15:38:37 *** aqua___ has joined #gnucash
15:48:40 *** TradeBorG113 has quit IRC
16:28:24 *** jmd has quit IRC
16:54:14 *** aqua___ has quit IRC
17:48:40 *** fuzzybunny69y has joined #gnucash
18:15:00 *** benoitg has quit IRC
19:26:37 *** ArtGravity has joined #gnucash
19:29:54 <ArtGravity> Has anyone dealt with billterms and taxtables creating duplicates of themselves? I use mysql backend on gnucash 2.6.0 on debian.
19:38:33 *** fuzzybunny69y has quit IRC
19:39:05 *** fuzzybunny69y has joined #gnucash
19:48:15 <warlord> ArtGravity: Huh, I thought that bug was fixed..
19:48:28 <ArtGravity> It might be
19:49:36 <ArtGravity> I just upgrade, but I did upgrade before the latest appearance of that symptom.
19:49:58 <warlord> Are you sure? Maybe you only just noticed it now?
19:50:09 <warlord> (i.e., maybe the items were there before the upgrade?)
19:50:26 <warlord> Alas, with MySQL there's no backup files to check your history; unless you're making regular mysql backups?
19:50:44 <warlord> (this is most definitely a sql issue)
19:51:03 <ArtGravity> Well some instances were definitely pre-upgrade and I just hadn't fixed them in the database yet.
19:51:47 <ArtGravity> I noticed some were from post-upgrade transactions, but the had a new characteristic of being created with a 'parent'
19:51:57 <ArtGravity> I had not seen that in the past
19:52:26 <ArtGravity> basically the new duplicate billing term had a parent field that pointed to the original term of the same name
19:52:36 <warlord> That is supposed to happen..
19:52:55 <ArtGravity> uh-oh
19:53:16 <ArtGravity> Am I breaking things by 'fixing' them?
19:53:47 <warlord> When you post an invoice it creates a child of the billterm; the child is "frozen", immutable. Only the parent can change. However it's only supposed to create a single child until you modify the parent.
19:53:51 <warlord> Possibly.
19:54:02 <ArtGravity> I ran UPDATE `invoices` SET `terms` = REPLACE (`terms`,'3862fccc922b9f34445d95dc4faeb55e','83a7cb0db231215c038065bdedffa645');
19:54:27 <warlord> I'm not sure what that is doing..
19:54:27 <ArtGravity> to eliminate the children thinking them to be duplicates
19:54:48 <ArtGravity> the first term is normally the duplicate and the replacement value is the correct billterm
19:54:51 <warlord> Um, no, there are *SUPPOSED* to be children in the DB. But each child should be "unique"
19:55:06 <warlord> think of it like copy-on-write.
19:55:13 <ArtGravity> This is the first I have seen of children
19:55:37 <warlord> That's because you're using SQL, where this feature has been broken for a long time
19:55:47 <ArtGravity> The real duplicates did not have the parent field
19:55:54 <warlord> Right...
19:56:38 <ArtGravity> Hopefully it won't cause any problems, and I will leave the children alone in the future
19:56:52 <warlord> here is the issue: Assume you post an invoice on date 1. On date 2 you modify the tax table (because the tax rate changed). On date 3 you go view the invoice. Woops! It's referencing the tax table that just changed...
19:57:14 <warlord> .. so now all your taxes are wrong when you view the invoice.
19:57:24 <warlord> (the posted transaction will be okay, but the printed invoice will be wrong)
19:58:32 <ArtGravity> OK - good to know. I don't use the tax tables much right now.
19:59:38 *** goibhniu has quit IRC
19:59:48 <ArtGravity> As long as the duplicates don't return, I won't have to go into the database to clear them out anymore anyway, so future entires should be okay.
20:00:06 <ArtGravity> Thanks for the info.
20:00:26 <warlord> the real dups shouldn't return in 2.6; the "dups with children" should appear, but shouldn't be in the "list"
20:00:45 <ArtGravity> As long as the list is clean, I am happy.
20:02:00 <ArtGravity> hard refs to the billing terms on the 7 invoices that stripped of parents today shouldn't hurt anything in my case.
20:04:57 <warlord> Was the list clean today?
20:05:03 <warlord> (after you posted more invoices with 2.6?)
20:05:57 <ArtGravity> It wasn't clean when I started working today, and I didn't cleant it until after I posted my invoices, so I won't really know until I post again.
20:06:55 <warlord> You could unpost/report
20:06:57 <warlord> repost
20:10:47 <ArtGravity> Looks okay after an unpost/repost
20:11:16 <warlord> Excellent.
20:11:22 <ArtGravity> It created a child bill term in the mysql, but the list is clean
20:11:25 <warlord> And in the DB, is there a child?
20:11:29 <warlord> Excellent.
20:11:35 <warlord> (the list is supposed to ignore children)
20:12:12 <ArtGravity> There was just the one child entry earlier today, so it was using that yet.
20:12:20 <ArtGravity> I'm pretty excited about this.
20:12:29 <warlord> :)
20:12:55 *** LiamH has joined #gnucash
20:14:04 <ArtGravity> Thanks for the help.
20:15:10 <warlord> you're welcome. enjoy!
20:15:22 <ArtGravity> The new export as PDF feature is great. I was already making PDFs with ghostscript, but the export button saves me time by streamlining the process.
20:18:50 <warlord> :)
20:36:12 *** kpreid has quit IRC
20:36:24 *** ArtGravity has quit IRC
20:36:37 *** kpreid has joined #gnucash
21:27:56 *** fuzzybunny69y has quit IRC
21:32:11 *** ErKa has quit IRC
23:36:51 *** LiamH has quit IRC
23:48:57 *** noughth has quit IRC
23:49:13 *** noughth has joined #gnucash