| Time |
Nick |
Message |
| 00:23 |
|
sandbergja joined #evergreen |
| 03:06 |
|
troy__ joined #evergreen |
| 06:00 |
pinesol |
News from qatests: Testing Success <http://testing.evergreen-ils.org/~live> |
| 08:13 |
|
Dyrcona joined #evergreen |
| 08:35 |
|
mmorgan joined #evergreen |
| 08:37 |
|
mantis joined #evergreen |
| 09:17 |
|
rfrasur joined #evergreen |
| 10:07 |
|
sandbergja joined #evergreen |
| 12:31 |
|
jihpringle joined #evergreen |
| 13:34 |
|
khuckins joined #evergreen |
| 13:42 |
Dyrcona |
So, I'm definitely getting a duplicate row because of the code in money.payment_by_billing_type() and not from data in the table. |
| 13:53 |
Dyrcona |
Although the billing table is a mess of "voided for backdate" and other entries. |
| 14:06 |
Dyrcona |
That's a complicated function! |
| 14:07 |
JBoyer |
I think it used to have a line in the comment about being straightforward. Used to. |
| 14:09 |
Dyrcona |
I haven't actually figure out why, but I get two credit card payments on the same exact and billing, 1 for 2.20 and one for 0.00, when there is only 1 credit card payment in the tables. |
| 14:09 |
Dyrcona |
@blame Friday for typos |
| 14:09 |
pinesol |
Dyrcona: Friday was monkeying around too much on the prod servers! for typos |
| 14:12 |
Dyrcona |
So, it looks like a bug in the code. |
| 14:12 |
jeff |
I may make time to run the committed version of the function against our data, since we've run a previous/different version of that function for several years now. |
| 14:13 |
jeff |
If nothing else, it could give me differences to focus on, or tell me that our data doesn't trip the bug. |
| 14:14 |
jeff |
it might be simpler to isolate the data that does trigger it, assuming it can be limited to a single xact and its associated billings and payments. |
| 14:14 |
jeff |
because then we can craft a similar bit of data and make sure its in concerto for the next time. :-) |
| 14:16 |
Dyrcona |
Yeah. I have an example transaction that I'm looking at. |
| 14:16 |
Dyrcona |
I've dumped the payments and billings to CSVs along with the output of the query that feeds the payment by billing type update. |
| 14:20 |
Dyrcona |
So, the money.payment table adds up to $8.40, while the payment_by_biling_type function output adds up to $8.30. |
| 14:26 |
Dyrcona |
So, I think the forgive payment with a payment_ts that is older than the billig_ts is hosing things up. |
| 14:28 |
Dyrcona |
The pile of voided ten cent billings don't help matters, either. |
| 14:30 |
Dyrcona |
The not-voided bills add up to $8.40. |
| 14:30 |
* Dyrcona |
wanted to eliminate voiding of bills for ... reasons. |
| 14:31 |
Dyrcona |
"De Do Do Do, De Da Da." |
| 14:33 |
Dyrcona |
.. Da |
| 14:35 |
Dyrcona |
Well, unrelated, but it seems people may be stealing the "banned" Dr. Seuss books from libraries to sell them on Ebay, even though I think Ebay supposedly won't let you list them. |
| 14:47 |
Dyrcona |
Here's a question, I understand putting voided billings last, but when grab voided billings at all? |
| 14:48 |
Dyrcona |
Here's another question: Why does it look like we're doing this twice? Maybe it's Friday, maybe it's the headache, maybe I'm just dumb, but I'm having a hard time understand what all of this is doing. |
| 14:49 |
Dyrcona |
!-2:s/when/why/ :) |
| 14:51 |
Dyrcona |
@blame Sting |
| 14:51 |
pinesol |
Dyrcona: It really IS Sting's fault! |
| 14:54 |
Dyrcona |
I think I'll dump the whole output of the function to a csv to see if any other transactions cause problems. |
| 15:12 |
Dyrcona |
Hm. That's harder than it seems. |
| 15:13 |
mmorgan |
Dyrcona: Everything is harder than it seems on a Friday afternoon :) |
| 15:13 |
Dyrcona |
mmorgan++ |
| 15:14 |
Dyrcona |
I should be able to get what I want using a WITH query. |
| 15:18 |
|
sandbergja joined #evergreen |
| 15:19 |
Dyrcona |
I hope the output is not too big to sort later. |
| 15:21 |
Dyrcona |
"Too much information running through my brain. Too much information drivin' me insane." |
| 16:03 |
|
mantis left #evergreen |
| 16:19 |
mmorgan |
I'm trying to follow berick's instructions for ansible on a virtualbox vm https://github.com/berick/evergreen-ansible-installer/tree/ubuntu-18.04 |
| 16:19 |
mmorgan |
sudo apt-add-repository ppa:ansible/ansible times out every time. |
| 16:20 |
mmorgan |
Any ideas? Been trying off and on for over a week :-( |
| 16:20 |
JBoyer |
mmorgan, ansible is available in debian and ubuntu default repositories now, provided it doesn't need a particularly fresh version those may work. |
| 16:21 |
JBoyer |
Alternatively you can just add the proper repo manually (that's all that PPA ends up doing) like this: https://docs.ansible.com/ansible/latest/installation_guide/intro_installation.html#installing-ansible-on-debian |
| 16:22 |
mmorgan |
JBoyer++ |
| 16:22 |
mmorgan |
If I just skip to the install step, it looks like it's working :) |
| 16:23 |
mmorgan |
Thanks! |
| 16:23 |
JBoyer |
mmorgan++ |
| 16:43 |
|
mmorgan1 joined #evergreen |
| 17:04 |
|
sandbergja joined #evergreen |
| 17:08 |
|
mmorgan1 left #evergreen |
| 17:09 |
|
mmorgan joined #evergreen |
| 17:10 |
|
mmorgan left #evergreen |
| 18:02 |
pinesol |
News from qatests: Testing Success <http://testing.evergreen-ils.org/~live> |
| 20:35 |
|
devted joined #evergreen |
| 20:36 |
|
dluch joined #evergreen |
| 21:25 |
|
sandbergja joined #evergreen |
| 22:38 |
|
sandbergja joined #evergreen |
| 23:18 |
|
sandbergja joined #evergreen |
