VBA Rubberducking

FreeMan

20:00

Yeah. The first 10 seasons of the new Who were excellent. Well, there was one that I consider iffy but everyone else seems to love. The latest couple... they're just trying too hard.

Duga

> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=h1) Report
> Merging [#5368](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/3da2aa0963ff51f60a42226ddeb6d0f57daf62d4?src=pr&el=desc) will **decrease** coverage by `0.33%`.
> The diff coverage is `n/a`.

```diff
@@ Coverage Diff @@
## next #5368 +/- ##
==========================

this

a bit of tangent but I did enjoy BBC's Being Human. When I found out that there was a US based version, I couldn't get into it.

on the flip side, the UK version of Office was just a bit too out there compared to US's.

FreeMan

Actually, I think that once a TV show hits 10 seasons, it's done. M*A*S*H, Little House on the Prairie both ended after 10. Murdoch Mysteries is into 13 now and has been fading, as is Doctor Who

Duga

> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=h1) Report
> Merging [#5368](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/3da2aa0963ff51f60a42226ddeb6d0f57daf62d4?src=pr&el=desc) will **decrease** coverage by `0.33%`.
> The diff coverage is `n/a`.

```diff
@@ Coverage Diff @@
## next #5368 +/- ##
==========================

this

Simpsons is the exception.

FreeMan

20:04

I'm somewhat shocked and slightly appalled that both The Simpsons and SpongeBob are going on 20 years.

this

but I think that's because of the fact that the Simpsons don't age.

what?

SpongeBob's still circulating?!?

IvenBach

Tough question. For the vertical scroll bar the part that left click and hold to drag, what's that called?

FreeMan

Can't vouch for either. I quit watching the Simpsons when my oldest started repeating words he heard.

this

slider?

FreeMan

scroll thumb

Spongebob: circulating? Yes. New episodes? haven't a clue. I don't think I've ever seen more than a few short snippets of it

IvenBach

20:06

@FreeMan I'd trade you that for quite a few things.

this

it's not uncommon for a series to keep syndicating for several decades after.

IvenBach

Wife and daughter really enjoy the show. :sadface:

^^ Gilligan's Island much?

FreeMan

@IvenBach I'd settle for a simple yellow duckie. :)

this

See: Gilligan's Island, MASH, *Star Trek

@IvenBach jinx

FreeMan

oh yeah, syndication FTW!

this

20:07

TBH I never really watched it.

Duga

> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=h1) Report
> Merging [#5368](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/3da2aa0963ff51f60a42226ddeb6d0f57daf62d4?src=pr&el=desc) will **decrease** coverage by `0.33%`.
> The diff coverage is `n/a`.

```diff
@@ Coverage Diff @@
## next #5368 +/- ##
==========================

FreeMan

SpongeBob or Simpsons?

this

So I can see SpongeBob syndicating.

I hope SpongeBob. Kids shouldn't be watching Simpsons.

IvenBach

@this I watched it all the time as a kid. Truth be told I think I had a crush on Ginger/Maryann. Definitely not Mrs. Howell :shudder:.

FreeMan

@this all 4 (or is it 5. No, make that 6!) Star Trek series.

this

20:09

IKR?

FreeMan

Oh yeah, "Ginger or Maryann?" was the question in middle/high school!

Duga

> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=h1) Report
> Merging [#5368](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/3da2aa0963ff51f60a42226ddeb6d0f57daf62d4?src=pr&el=desc) will **decrease** coverage by `0.33%`.
> The diff coverage is `n/a`.

```diff
@@ Coverage Diff @@
## next #5368 +/- ##
==========================

IvenBach

Star Trek: Original, TNG, DS9, Voyager, Enterprise. What else were there?

Hosch250

99-bottles-of-beer.net/language-malbolge-995.html

FreeMan

The Orville is a pretty decent spoof, yet more-or-less serious take on Star Trek

this

20:11

that makes me think of the popcorn....

FreeMan

@IvenBach new one just out last week: Picard

this

Pop Trek

Corn Trek

FreeMan

lol

this

To cornily go where no man has popped before

FreeMan

of course, a lot of die-hard Trekkies totally disavow the existence of Enterprise

I've not seen it, so no ideas why

this

20:13

TBH I don't get it.

I've seen it and I think it's OK

it's an interesting take.

FreeMan

@IvenBach Also Original = The Original Series = TOS

this

OTOH, DS9.... snorefest

Duga

> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=h1) Report
> Merging [#5368](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/3da2aa0963ff51f60a42226ddeb6d0f57daf62d4?src=pr&el=desc) will **decrease** coverage by `0.33%`.
> The diff coverage is `n/a`.

```diff
@@ Coverage Diff @@
## next #5368 +/- ##
==========================

FreeMan

DS9 To boldly go nowhere at all

IvenBach

@FreeMan ~~All I see is Terms of Services (ToS)~~ Capitalization of O duly noted.

this

20:14

@FreeMan no, To boringly go nowhere at all

FreeMan

TOS: really corny. I've tried sitting down to watch, but I just. can't. get through. more. than a couple. of. episodes at. a time. for some values of time > 365 days

@IvenBach ha!

this

oh c'mon! Kirk karate chopping a Klingon twice his size is hilarious

so is fighting a ~~man in green suit~~ Gorn!

IvenBach

Episode of #HippiesInSpace was one of the few I've actually seen. Far far far too campy.

FreeMan

I keep trying, I... just don't get where all the letter writing campaigns came from back in the mid-60s to get it back on the air.

this

hmm. which's more campier -- ST: ToS or Batman (Adam West)

FreeMan

20:17

I guess it was pretty new and adventurous for back then

Hosch250

@this Is that like, I dunno, a terrier biting a horse? The result is a yeet?

this

I would think Batman is far more campy than ToS

@Hosch250 no it's how they did it. it's... scripted.

Hosch250

How do they do it?

IvenBach

That's because the spelled out the words on the screen.

Hosch250

I mean, the Klingon would just headbutt him into space, right?

Duga

20:19

> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=h1) Report
> Merging [#5368](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/3da2aa0963ff51f60a42226ddeb6d0f57daf62d4?src=pr&el=desc) will **decrease** coverage by `0.33%`.
> The diff coverage is `n/a`.

```diff
@@ Coverage Diff @@
## next #5368 +/- ##
==========================

this

This is Bones, not Kirk but same idea:

Best Kirk Fight Moves - Bones's "Kirk Chop"

►

Duga

> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=h1) Report
> Merging [#5368](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/3da2aa0963ff51f60a42226ddeb6d0f57daf62d4?src=pr&el=desc) will **decrease** coverage by `0.33%`.
> The diff coverage is `n/a`.

```diff
@@ Coverage Diff @@
## next #5368 +/- ##
==========================

Hosch250

@this I'll watch it after work.

this

I think you can see that regardless of size, you just can't knock a person unconsicious just by chopping on the back.

Hosch250

It actually really depends. Kidney chops can kill.

The ribs, eh....

FreeMan

20:23

@this unless, of course, the script calls for the chopee to collapse after the first whack.

Hosch250

The neck, certainly can kill as well.

Duga

> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=h1) Report
> Merging [#5368](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/3da2aa0963ff51f60a42226ddeb6d0f57daf62d4?src=pr&el=desc) will **decrease** coverage by `0.33%`.
> The diff coverage is `n/a`.

```diff
@@ Coverage Diff @@
## next #5368 +/- ##
==========================

this

Trust me, none of that. It's just on the back, in the place that would not even hurt

Duga

> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=h1) Report
> Merging [#5368](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/3da2aa0963ff51f60a42226ddeb6d0f57daf62d4?src=pr&el=desc) will **decrease** coverage by `0.33%`.
> The diff coverage is `n/a`.

```diff
@@ Coverage Diff @@
## next #5368 +/- ##
==========================

Mathieu Guindon

deactivated the codecov webhook

Duga

20:39

> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=h1) Report
> Merging [#5368](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/3da2aa0963ff51f60a42226ddeb6d0f57daf62d4?src=pr&el=desc) will **decrease** coverage by `0.33%`.
> The diff coverage is `n/a`.

```diff
@@ Coverage Diff @@
## next #5368 +/- ##
==========================

jcrizk

@MathieuGuindon did i happen to break something re: github.com/rubberduck-vba/Rubberduck/pull/5368 ?

Duga

> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=h1) Report
> Merging [#5368](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/3da2aa0963ff51f60a42226ddeb6d0f57daf62d4?src=pr&el=desc) will **decrease** coverage by `0.33%`.
> The diff coverage is `n/a`.

```diff
@@ Coverage Diff @@
## next #5368 +/- ##
==========================

Hosch250

@MathieuGuindon Oh yeah?

Time to bring in Simon?

Mathieu Guindon

@SimonForsberg any idea why @Duga is outta control?

Duga

> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=h1) Report
> Merging [#5368](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/3da2aa0963ff51f60a42226ddeb6d0f57daf62d4?src=pr&el=desc) will **decrease** coverage by `0.33%`.
> The diff coverage is `n/a`.

```diff
@@ Coverage Diff @@
## next #5368 +/- ##
==========================

Mathieu Guindon

20:47

@jcrizk not sure what happened, but I'm 100% positive it's not your fault

this

@MathieuGuindon I did that earlier.

but the problem is either (or between) duga & codecovv, not GH

jcrizk

gotcha. i just wanted to make sure if i'd not pulled or something prior to making the PR

Duga

> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=h1) Report
> Merging [#5368](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/3da2aa0963ff51f60a42226ddeb6d0f57daf62d4?src=pr&el=desc) will **decrease** coverage by `0.33%`.
> The diff coverage is `n/a`.

```diff
@@ Coverage Diff @@
## next #5368 +/- ##
==========================

Mathieu Guindon

pretty sure the 2 commits can still be cherry-picked into a new PR

Hosch250

It may have stopped?

Duga

20:51

> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=h1) Report
> Merging [#5368](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/3da2aa0963ff51f60a42226ddeb6d0f57daf62d4?src=pr&el=desc) will **decrease** coverage by `0.33%`.
> The diff coverage is `n/a`.

```diff
@@ Coverage Diff @@
## next #5368 +/- ##
==========================

FreeMan

crawls back out from under his desk Is it safe?

nope.

Hosch250

LOL. Should I kick her?

FreeMan

perfect timing, @Duga, thanks.

Hosch250

I doubt anything else can get through anyway because of rate-limiting.

Simon Forsberg

@Hosch250 Kicking @Duga doesn't help.

FreeMan

20:52

That's not the right way to treat a lady, @Hosch250. I think we need to buy her flowers and some chocolate.

Simon Forsberg

I will check

FreeMan

and maybe enough Vodka that she just slumps to the floor.

Hosch250

@SimonForsberg OK. I thought if I repeatedly kicked her it might prevent her from posting.

Simon Forsberg

@MathieuGuindon How long has this been going on? How often does it happen?

this

it only started today but has been for last 2 - 3 hours, I think

Mathieu Guindon

20:53

I think it started when I merged a revert PR

Duga

> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=h1) Report
> Merging [#5368](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/3da2aa0963ff51f60a42226ddeb6d0f57daf62d4?src=pr&el=desc) will **decrease** coverage by `0.33%`.
> The diff coverage is `n/a`.

```diff
@@ Coverage Diff @@
## next #5368 +/- ##
==========================

Mathieu Guindon

and now she's like stuck in a loop or something

Simon Forsberg

> Code Review ERROR net.zomis.duga.chat.StackExchangeChatBot - Failure body: The message is too long.

Mathieu Guindon

interesting

Simon Forsberg

Huh, if you write [main] in chat, it becomes Code Review

Mathieu Guindon

20:54

#TIL

Code Review Meta

ha

this

3 hours ago, by Duga

> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=h1) Report
> Merging [#5368](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/3da2aa0963ff51f60a42226ddeb6d0f57daf62d4?src=pr&el=desc) will **decrease** coverage by `0.33%`.
> The diff coverage is `n/a`.

```diff
@@ Coverage Diff @@
## next #5368 +/- ##
==========================

Simon Forsberg

Ouch.

this

that's the first one that start to repeat, I think

jcrizk

Code Review

lol

Simon Forsberg

Please ping me ASAP when this kind of stuff happens.

Mathieu Guindon

20:55

will do!

this

i thought it was mabye codecov acting up, not duga

Mathieu Guindon

wanted to be sure it wasn't the webhook first :)

this

^

Simon Forsberg

@this What do you think is more tested? :)

IvenBach

Code Review

FreeMan

20:57

@SimonForsberg hrm... scratches head...

ok, fine Code Review

Simon Forsberg

Hint: It's not @Duga

this

Duga. Codecov thing is recent

Duga

> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=h1) Report
> Merging [#5368](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/3da2aa0963ff51f60a42226ddeb6d0f57daf62d4?src=pr&el=desc) will **decrease** coverage by `0.33%`.
> The diff coverage is `n/a`.

```diff
@@ Coverage Diff @@
## next #5368 +/- ##
==========================

FreeMan

OK, if Duga don't start drinkin' soon, I think the rest of us will!

Simon Forsberg

@Duga Yeah thanks, we got it.

IvenBach

20:58

@Duga Yes we know you're here. Quit begging for attention.

Mathieu Guindon

lol

FreeMan

@IvenBach Howser?

IvenBach

~.~ FML #Words

Duga

> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=h1) Report
> Merging [#5368](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/3da2aa0963ff51f60a42226ddeb6d0f57daf62d4?src=pr&el=desc) will **decrease** coverage by `0.33%`.
> The diff coverage is `n/a`.

```diff
@@ Coverage Diff @@
## next #5368 +/- ##
==========================

FreeMan

@FreeMan that's only funny to you now, since @IvenBach edited his post...

IvenBach

21:01

I rwsea I mstu eb dlxcysie ro thomegnis.

Simon Forsberg

@IvenBach I love the fact that that's actually readable.

[rubberduck-vba/Rubberduck] build for commit 8bcd3cf8 on revert-5364-RemoveRefLibraryStrings: Coverage not affected when comparing 7fbdab4

...8bcd3cf

10 bloody chars made a message unpostable, which is what caused the loop

IvenBach

If you leave the first and last letter of a word untouched and rearrange all the other characters everything else is near immediately readable by native speakers.

mansellan

@this I tried watching the US version, couldn't get into it. The original is a masterpiece so the bar was too high I think. Very british though, I can see it might not travel well.

Mathieu Guindon

@SimonForsberg odd that it happens now, after like 5 years of posting many, many long messages

Simon Forsberg

@MathieuGuindon Must have been a mistake in the migration to AWS

this

21:07

@mansellan Interesting. But if I'm not mistaken, Ricky was involved in both.

Simon Forsberg

@MathieuGuindon What @Duga URL webhook is this?

GitHub or something else? AppVeyor?

4 mins ago, by Simon Forsberg

[rubberduck-vba/Rubberduck] build for commit 8bcd3cf8 on revert-5364-RemoveRefLibraryStrings: Coverage not affected when comparing 7fbdab4

^^ this specific thing

mansellan

@this did not know that, #til

Simon Forsberg

Does it show in the regular GitHub webhook payloads? Or did it come from AppVeyor?

mansellan

maybe I'll give the us one another look

IvenBach

An example of that would be taking this scentence and rearranging all the letters to kinda sorta but not really scramble it up.

An elmpxa of taht wulod be tnkaig tihs stecnnece and rrrnnaeaigg all the lteerts to kdnia stroa but not rlaely sblrmcae it up.

this

21:11

just checked, he's one of producers so I don't actually know how much control / involvement he had

but he was involved in some way.

mansellan

tbf I think I only saw a couple of eps, and iirc the first 2 seasons were just remakes of the UK eps. maybe I should try some of the new stuff.

Mathieu Guindon

@SimonForsberg https://codecov.io/webhooks/github

mansellan

also, star trek, y'all missed Discovery and TAS (the animated series)

this

there might have been some elements that got incorporated but there were also definite differences between the first 1st season.

(don't remember if I got to see british 2nd season - Netflix had it available only temporarily)

Simon Forsberg

@MathieuGuindon What webhook to @Duga I mean. Did it go to duga.zomis.net/github or duga.zomis.net/... wait a minute, it's only that one and splunk that goes to AWS... so it went to codecov, then back to github, then to @Duga probably

Mathieu Guindon

21:17

yeah

mansellan

random thought - p-code runs on a virtual machine. In theory it should be possible to target it from different source languages, similar to the java and .net runtimes.

that could be a fun phd :-)

Mathieu Guindon

https://duga.zomis.net/github?roomId=14929

@mansellan haha yeah, ...without the specs!

huh, how is the "Stars" event disabled on that hook and yet @Duga still tells us about stars? #confused

mansellan

I think some early versions on MSVC could target pcode, I assume that got dropped at some point (not ever installed the C workflow)

@MathieuGuindon sure, adds to the fun!

this

@MathieuGuindon that's why reverse engineering is a thing

Quack Exchange

-1

Q: Evaluating formulas greater than 255 characters

Recently I was receiving Error 2015 when trying to use Application.Evaluate, then I realized it was because my formula was greater than 255 characters. As a workaround, I came up with this UDF: Function AdvancedEvaluate(eformula As String) ThisWorkbook.Worksheets("Scripting Worksheet").Rang...

FreeMan

21:23

@mansellan oh, Lord, that's 8!!!

this

@FreeMan OTOH, Star Wars has more, I'm sure.

wonders why Hollywood hasn't already made a Trek Wars movie

FreeMan

yeah, but SW jumped the shark with Episode I as far as I'm concerned

I'm pretty sure some fans, some where have made some version of Trek Wars

this

@FreeMan Better not tell ol'Georgie.

@FreeMan FanFics isn't really the same thing.

FreeMan

He's not been involved. at least for the last 3 (as I understand it), but yeah, that whole Jar Jar thing...

jcrizk

@FreeMan i keep thinking this one is hilarious lol

especially when i see memes referencing it

Simon Forsberg

21:26

Ok, I think the problem should be fixed now, I have re-enabled @Duga and she has some stuff in the queue that she should be posting soon

FreeMan

I swear I remember an interview with Lucas on GMA or the Today Show back in the mid-80s where he explained that the original trilogy was the middle of the 9-part series and that he was never going to make or sell the rights to make the other 6.

this

@FreeMan Really?

Duga

> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=h1) Report
> Merging [#5368](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5368?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/3da2aa0963ff51f60a42226ddeb6d0f57daf62d4?src=pr&el=desc) will **decrease** coverage by `0.33%`.
> The diff coverage is `n/a`.

```diff
@@ Coverage Diff @@
## next #5368 +/- ##
==========================

FreeMan

I guess the lure of the lucre was just too much

Duga

[rubberduck-vba/Rubberduck] build for commit 8bcd3cf8 on revert-5364-RemoveRefLibraryStrings: 61.34% (target 0%)

[rubberduck-vba/Rubberduck] retailcoder pushed 1 commit to next

[rubberduck-vba/Rubberduck] web-flow pushed commit 231bac55 to next

Merge pull request #5368 from rubberduck-vba/revert-5364-RemoveRefLibraryStrings

Revert "Replace string ReferenceLibrary keys"

[rubberduck-vba/Rubberduck] rubberduck-vba-releasebot prereleased draft prerelease Prerelease-v2.5.0.5325

FreeMan

21:27

@this Just saw Ep IX - directed by JJ Abrams

Duga

[rubberduck-vba/Rubberduck] rubberduck-vba-releasebot published prerelease Prerelease-v2.5.0.5325

[rubberduck-vba/Rubberduck] rubberduck-vba-releasebot created tag Prerelease-v2.5.0.5325

Simon Forsberg

@MathieuGuindon Because the stars event is actually a watch event. Unsure why.

Duga

[rubberduck-vba/Rubberduck] rubberduck-vba-releasebot created draft prerelease Prerelease-v2.5.0.5325

[rubberduck-vba/Rubberduck] build for commit 231bac55 on next: 61.67% (target 0%)

this

@FreeMan Lucas' lucre lure

FreeMan

Yay @Duga & @SimonForsberg!!!!

Duga

21:27

[rubberduck-vba/Rubberduck] build for commit 231bac55 on next: Coverage not affected when comparing 8bcd3cf...231bac5

[rubberduck-vba/Rubberduck] MDoerner synchronized pull request #5365: Additional top level exception handling and better status message sequencing

FreeMan

@this that

Duga

[rubberduck-vba/Rubberduck] build for commit a51d3565 on unknown branch: Coverage not affected.

[rubberduck-vba/Rubberduck] codecov[bot\] edited comment on pull request #5365: Additional top level exception handling and better status message sequencing

Mathieu Guindon

@SimonForsberg hm, but does the stars event tell us when a star ~~dies~~ is removed?

Duga

> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5365?src=pr&el=h1) Report
> :exclamation: No coverage uploaded for pull request base (`next@e42e633`). [Click here to learn what that means](https://docs.codecov.io/docs/error-reference#section-missing-base-commit).
> The diff coverage is `n/a`.

```diff
@@ Coverage Diff @@
## next #5365 +/- ##
=======================================
Coverage ? 61.64%
=================

[rubberduck-vba/Rubberduck] build for commit f9326944 on unknown branch: AppVeyor build succeeded

FreeMan

now @Duga's gonna spam us with all the stuff she's been saving up all day because her needle was stuck?

Mathieu Guindon

21:28

yep

Duga

[rubberduck-vba/Rubberduck] build for commit f9326944 on unknown branch: 61.64% (target 0.00%)

Simon Forsberg

@MathieuGuindon Not that I know of. Didn't even know there was a "stars" event

Duga

[rubberduck-vba/Rubberduck] codecov[bot\] edited comment on pull request #5365: Additional top level exception handling and better status message sequencing

this

subtitle: Jaws of Jowls

Mathieu Guindon

@SimonForsberg could be new

Duga

21:28

> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5365?src=pr&el=h1) Report
> Merging [#5365](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5365?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/231bac55e6e0d00babecf4f3e7c0b7241f544049&el=desc) will **decrease** coverage by `0.03%`.
> The diff coverage is `n/a`.

```diff
@@ Coverage Diff @@
## next #5365 +/- ##
=================================

[rubberduck-vba/Rubberduck] BZngr created comment on pull request #5364: Replace string ReferenceLibrary keys

FreeMan

@this eh?

Simon Forsberg

@FreeMan There was only 25 or so messages in her queue from what I could see.

Duga

> Not sure what the remedy is here. I'm thinking it is to re-sync after updating my branch with the recently merged PRs(?). Also, this PR no longer shows up on GitHub...will re-syncing load it back into the queue?

FreeMan

Man, I feel like I'm shouting to be heard over Duga now! :)

BigBen

SHOUT LOUDER!

FreeMan

21:29

@SimonForsberg no worries! It's kinda fun poking fun at her foibles. :)

Simon Forsberg

@FreeMan Isn't that the usual situation around here?

this

@FreeMan sheldoncomics.com/archive/070409.html

FreeMan

@this HAHAHAHAHA

Mathieu Guindon

that would be a nice improvement though - "$(github_user) unstarred us. Sad!"

FreeMan

@SimonForsberg eh. not so much, usually...

@MathieuGuindon I'm not so sure that qualifies as "nice"... :(

Mathieu Guindon

21:32

meh

IvenBach

Simon Forsberg

Now it might be possible that some messages will not be delivered here, if you miss anything, let me know. I'll try to keep track of the logs as well.

FreeMan

@IvenBach pretty much

keeps eyes open for missing unknown messages.

Mathieu Guindon

@SimonForsberg could @Duga not post a specific error message when that happens? a short one, without the stack trace (so it's not too long)... like, "Could not deliver payload to chat. @SimonForsberg you're up!"

this

I wonder if it'll keep up, though. It seems more often than not, buyouts leads to devaluation.

Simon Forsberg

21:38

@MathieuGuindon Well, yeah, sure... but what if there's an error delivering that message? Would she then try to post a message to chat saying there was an error posting an error to chat, because there was an error posting a message to chat?

At the moment she doesn't filter out why it fails

FreeMan

once again, notes interesting line spacing. This time @Phrancis has a long name, but this time it overlaps milleniumbug instead of taking up width*1.5 pixels

@SimonForsberg notes 1 Infinite Loop. Hears replay of today.

this

@SimonForsberg the error message should be its own thing with only fail-once

but yeah that is an extra complexity

Mathieu Guindon

hmm, not familiar with the source at all, but presumably there's a ChatMessage class, with a RetriesAttempted property?

#MutableBad

Simon Forsberg

@MathieuGuindon No such thing as RetriesAttempted property.

in Coding Projects and Twitter Heaven :), 7 mins ago, by Duga

[Zomis/Duga] Zomis pushed commit d6a3b0e8 to aws

Mathieu Guindon

ha, see :)

Simon Forsberg

21:41

this is the quick-fix I just did

The problem was that when I did throw Exception, the message was never removed from the SQS queue

FreeMan

@this I dunno... seems that folks can't get oversaturated by more of the same these days. They're on Fast and Furious 88 or something like that, and there are 20+ MCU movies currently with 4 or 5 more slated over the next 2-3 years...

Duga

[rubberduck-vba/Rubberduck] build for commit f9326944 on unknown branch: 61.64% (target 0%)

[rubberduck-vba/Rubberduck] codecov[bot\] edited comment on pull request #5365: Additional top level exception handling and better status message sequencing

> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5365?src=pr&el=h1) Report
> :exclamation: No coverage uploaded for pull request base (`next@e42e633`). [Click here to learn what that means](https://docs.codecov.io/docs/error-reference#section-missing-base-commit).
> The diff coverage is `100%`.

```diff
@@ Coverage Diff @@
## next #5365 +/- ##
=======================================
Coverage ? 61.64%
================

[rubberduck-vba/Rubberduck] build for commit f9326944 on unknown branch: 100% of diff hit (target 60%)

Mathieu Guindon

@SimonForsberg makes sense, and rings a very very familiar bell (made a windows service that pulls from Shopify REST API, had a similar issue)

Simon Forsberg

I think it should be possible to use a "Dead Letter Queue" in case of an error like this, but I've never dared play with that yet.

this

2 hours ago, by this

TBH it does annoys me a bit that hollywood is in the "let's remake original!" glut for a good while.

FreeMan

21:45

@this Yup.

Heck there's a new Rambo coming out for heavens sake!!!

this

ooo ooo, here's an original movie idea!

Failing to make a good movie

FreeMan

shhhhh it might be a flop

I'm done. TTFN!

this

hmm. might come out as a documentary rather than a movie.

later!

IvenBach

Nameless Executive1: We've run out of ideas.
Nameless Executive2: What do we do?
Nameless Executive3: I can't afford to be fired. I have to pay alimony for me 3 previous wives.
Nameless Executive1: I know... Remakes and Reboots.
Nameless Executive2: The Pineapples will LOVE it. Suckers for nostalgia.
Nameless Executive3: Excellent...

@FreeMan WTAF?

this

They've pretty much chopped it down to an assembly line.

Instead of MGM, you get McDonald's.

Warner Bros? Wendy's.

IvenBach

22:34

Mug. I've got a brain-tickle telling me that xltrail mentioned rubberduck. Did they ever reach out to you for any free trials?

this

confused Rubberduck is... free?

IvenBach

#Wrods. IIRC xltrail.com mentioned RD at one point. I can't recall if they ever offered any free trials to contributors.

Vogel612

Seems like I missed some fun there....

Mathieu Guindon

@IvenBach that might have been. I think there might be an Excel MVP behind that tool...

(or I'm confusing it for something else)

IvenBach

Before when it came up I didn't understand VC or git well enough. Now that I have more experience I'd be able to make use of it.

Mathieu Guindon

22:47

hm is it @Qharr behind it?

Mathieu Guindon

23:06

TFW it's 6PM and you gotta leave work but just realized the extent of the damage a recent change to your overnight ETL has done to the data, and know full well that tonight is going to make things worse.

disables SQL Server Agent job, leaves

this

@MathieuGuindon Wally would be so proud.

Mathieu Guindon

hm?

#REF! :)

this

Makes sense if you've read Dilbert comics

He's the kind of worker who works hard to avoid any extra work while ensuring that his job remains secure.

Don't worry - I'm sure we'll have a better day. :-)

Mathieu Guindon

so... I should pack up my laptop and work from home all evening to ensure it's fixed for tonight's run?

this

No no no no

#jokefail

Mathieu Guindon

23:10

lol

<~ easily swooshed

this

I can empathize with the feeling of leaving something incomplete, and when I do, I feel like Wally even though I don't want be like him.

Sorry!

Mathieu Guindon

eh, disabling a job to avoid further damaging the database felt like The Right Thing :)

this

Yep

Mathieu Guindon

I'll even schedule the staging package, so I have everything ready tomorrow morning

this

Better safe than sorry

Mathieu Guindon

23:16

crap, how do I schedule a job with a timestamp

can a SSIS package parameter value be GETDATE()?

this

can't remember, sorry. if it's just one time, just type in a timestamp?

Mathieu Guindon

yeah just did that :)

this

and I thought you had left. :)

Mathieu Guindon

ok, leaving now

IvenBach

Would you consider Wally a subset of Mort?

this

23:28

I don't think so.

there was a number of strips showing Wally to be very knowledgeable and skilled

It's simply that the big corp has sucked the life out of him so he's basically an empty husk

IvenBach

~~Reason being Mort is absolutely clueless~~ Mkay. So Wally could be an Elvis. He just doesn't put forth effort.

Dilbert ran long before I was an a-dult and worked in office culture.

this

yeah. The funny thing is that the current comics makes me a bit sad

When I think Dilbert, I think of tie & white shirt, not polo shirt and badge

IvenBach

@this You're a mind reader then.

I didn't realize Dilbert was in color now.

this

23:45

probably a side effect of being on interweb. Color on newspaper was not exactly cheap.

but I think even back then, Sundays was in color.

Transcript for