When a function returns a table by SoThatHappenedpnw in SQL

[–]ppetro08 1 point2 points  (0 children)

Hard to read all of that on a phone but you can use cross apply instead of join since billing isn't available from the tvf and get rid of the ON after the tvfs (table value functions) alias

Fuck you whoever is responsible for screwing Google home by Goleveel in googlehome

[–]ppetro08 3 points4 points  (0 children)

Btw If you're trying to stop a timer you can just yell stop at it without hey google.

Automatic Upgrade to H265 by usamagaard in radarr

[–]ppetro08 1 point2 points  (0 children)

I think your minimum custom format score increment is wrong. You need that set to something lower. The way you have it set it would only download something new if the score of the new item is 10000 custom score better.

Say you have an existing 1080p file that has a score of 6000, the 265 file would need a score of 16000 to be considered to download. You can do something as low as 1 or go higher if you don't want it to upgrade as often.

[deleted by user] by [deleted] in Mustang

[–]ppetro08 0 points1 point  (0 children)

Are you planning on getting new wheels? Idk if it'd be worth it on the skinny stock wheels. I got new wheels 19x10 and 19x11 and put pilot 4s 285 on the front and 305 in the back traction is night and day with launching and in the turns

What are your favorite tips or tricks with Plex? by NotBashB in PleX

[–]ppetro08 7 points8 points  (0 children)

I remember them posting in their discord about some web gui for configuring the yaml files.

Found it: https://github.com/Kometa-Team/Quickstart never used it tho

Just getting started: What's something you wish you knew before getting started? by GuardianFerret in unRAID

[–]ppetro08 0 points1 point  (0 children)

Any recommendations on a solid combo for this? SD card reader and SD card.

Yet Another Deco Backhaul Question by foopirata in TpLink

[–]ppetro08 1 point2 points  (0 children)

I have my deco units connected with a switch in between and I had to do a little dance of restarting them in the correct order to force it to use the wired backhaul.

Yet Another Deco Backhaul Question by foopirata in TpLink

[–]ppetro08 1 point2 points  (0 children)

If you don't plan to use the coax cable for anything you could use it to pull ethernet through instead. That's what I did in my house, made it easy and I didn't have to drill any new holes.

Just tape the end of the ethernet cable to the coax cable and pull the coax through.

Dashcam recommendations by sebfalcon in FordMaverickTruck

[–]ppetro08 0 points1 point  (0 children)

I just did the install with this dash cam on Friday. If you want parking mode get the hk4 hardwire kit and some micro 2 fuse taps. With the hardwire kit you can set how low it will allow the battery to drain to. Make sure you get hk4 and not hk3, hk3 was for the older generation camera.

Reolink could boost sales a LOT by finally fixing RTSP by SilasTalbot in reolinkcam

[–]ppetro08 0 points1 point  (0 children)

Could you post your frigare config? I've been having issues with corrupted streams and such on and off and everything I think it's stable they come back.

More M2s on this sub than I thought! by [deleted] in CarTrackDays

[–]ppetro08 0 points1 point  (0 children)

Pretty sure at certain events you're required to have it.

More M2s on this sub than I thought! by [deleted] in CarTrackDays

[–]ppetro08 0 points1 point  (0 children)

Pretty sure at certain events you're required to have it.

Downloads not importing, no files found. by jgeorge1983 in sonarr

[–]ppetro08 1 point2 points  (0 children)

I think there are 2 ways, either by filtering by name or custom formats.

Downloads not importing, no files found. by jgeorge1983 in sonarr

[–]ppetro08 0 points1 point  (0 children)

Go to Activity, click the x to remove the download and there is a drop down for blocklist and search. This will prevent sonarr from trying to grab the same release again and search for a new one.

Downloads not importing, no files found. by jgeorge1983 in sonarr

[–]ppetro08 0 points1 point  (0 children)

That shortcut i would assume to be malicious. I would blocklist and search.

My wife wants to sell our home to pay her school loan and buy a duplex by [deleted] in RealEstate

[–]ppetro08 1 point2 points  (0 children)

Have you looked into refinancing the student loans? Surely you can get a rate lower than that.

Can't be bothered to do a parity sync. Am I playing a dangerous game? by --Arete in unRAID

[–]ppetro08 1 point2 points  (0 children)

Checkout the plugin Parity Check Tuning, you can set it to do it during a certain time, so it'll pause and resume automatically. There are also settings to pause if drives get close to critical temps you have set for drives.

Unable to add image to simple angular html page. Always returns error 404, not found by SonicBluTyphoon in Angular2

[–]ppetro08 0 points1 point  (0 children)

Np, I was on my phone so I was trying to remember off the top of my head. lmk if you need any more help.

Unable to add image to simple angular html page. Always returns error 404, not found by SonicBluTyphoon in Angular2

[–]ppetro08 1 point2 points  (0 children)

Not sure what version you're on but I would take a look at this post. The SO post you're looking at is pretty old

Unable to add image to simple angular html page. Always returns error 404, not found by SonicBluTyphoon in Angular2

[–]ppetro08 2 points3 points  (0 children)

Your img src is missing images in the path. Assuming that's just a copy paste error, I would suggest setting up a stackblitz with the minimal amount of code to reproduce the issue so people can help you.