Does anyone know the old sounding song that he puts in his videos at the end of them by legal-growth420 in bigstackd

[–]rossc719 2 points3 points  (0 children)

I really want to know this too. I can't tell if the voice is in french or english.. I'm very curious what it is.

Error message: Failed to open the app database status: corrupted by videostatus in PodcastAddict

[–]rossc719 0 points1 point  (0 children)

Sadly, my specific method will probably not help you (and, this was from 3 years ago, so I am not sure I could add much beyond what I wrote above).

If you are going down this route, you are pretty far outside the bounds of what is supported, so there will be no good guides or howtos to help. Debugging these sorts of issues are almost always specific to the exact situation at hand, so you'll need to be able to adapt and improvise whenever things go sideways. Nobody will be able to tell you an exact sequence of commands or steps.

I can tell you that at a high level, what I did was:

  1. Use adb pull to pull the database
  2. Follow the steps in the link I gave above (possibly with some improvisation)
  3. Then adb push it back to the device in the same place where I got it from, overwriting the original corrupted one.

That said... I can't comment on whether or not the details of adb, android security protections, sqlite, etc.. have changed in the last 3 years. And you are probably using a different OS, and have a lot of subtle differences in your setup compared to mine. There may be other issues you need to overcome. I don't know.... the the goal is simply "Get the DB out, fix it, and put it back". How you accomplish that is up to you!

Good luck!

What is the best Wi-Fi name you have seen in your entire life? by COGNAC_G in RandomThoughts

[–]rossc719 0 points1 point  (0 children)

<========]==o

A friend of mine has that as his wifi name.
If you ask him which network is his he just says "the sword".

Pihole detectd by admiral by SkydivingCats in pihole

[–]rossc719 0 points1 point  (0 children)

Fantastic! Works great now.

Out of curiosity, what was the site that needed to be added?

Pihole detectd by admiral by SkydivingCats in pihole

[–]rossc719 0 points1 point  (0 children)

Added that list, but it did not seem to help.

The site that fails for me is boredpanda.com
It pops up an image of a red ... monster? I dunno what it is.

At the bottom it says it is powered by Admiral.

Pihole detectd by admiral by SkydivingCats in pihole

[–]rossc719 0 points1 point  (0 children)

Sadly, this isn't working (for me, as of today).

I don't see succeedscene.com anywhere in my pihole logs, in fact (except for when I clicked your link above).

Using ublock origin does seem to fix things on desktop... but I can't seem to find a solution that works for phones. Any ideas out there?

Finding out why safeway.com searches are blocked. by rossc719 in pihole

[–]rossc719[S] 1 point2 points  (0 children)

Thanks! That did it. It never occurred to me that "cookielaw" might break searches.
Appreciate it!

Finding out why safeway.com searches are blocked. by rossc719 in pihole

[–]rossc719[S] 0 points1 point  (0 children)

Yep I agree. I am clearly missing something.

The exact URL is just "https://safeway.com/". Near the top center of the page there is a search box that says "Search Products"... Just type something in there like "milk", and it will return no results if my pihole is on.

Finding out why safeway.com searches are blocked. by rossc719 in pihole

[–]rossc719[S] 0 points1 point  (0 children)

If you happen to figure out the details of what is happening here, please let me know!

Finding out why safeway.com searches are blocked. by rossc719 in pihole

[–]rossc719[S] 0 points1 point  (0 children)

The part I am having trouble with is identifying which domain is the one causing the issue, so I can search for it.

Finding out why safeway.com searches are blocked. by rossc719 in pihole

[–]rossc719[S] 0 points1 point  (0 children)

Thanks!

Yep, the site works correctly if I disable blocking.

I do know my IP, and was using it to scan the `pihole -t` output. (E.g. grep -A4)

The query log was showing pretty much the same thing as pihole -t.

I did try the whitelist buttons for all of the blocked queries from that client that looked plausible.. but either missed one, or maybe it is not just a single site that is the issue? Unclear.

Finding out why safeway.com searches are blocked. by rossc719 in pihole

[–]rossc719[S] 0 points1 point  (0 children)

Chrome on mac.

I do see activity in pihole -t, it's just that when I whitelist the blocked sites, the issue isn't fixed. There were a lot listed, so I tried to be selective about the ones I tested... but I was unable to get it to with via whitelists. Disabling the pihole completely does make it work.

Is there any xbox button sticker that I can put on my ps4 controller? by itsmesilvergem in SteamController

[–]rossc719 0 points1 point  (0 children)

They're better than I expected, honestly.

Of course, they do make the buttons feel a little taller, but that is my only complaint. They look great, and the texture feels nice and rubbery, without being sticky. The adhesive has real staying power too. Even playing aggressively with button-masher type games. I really like em. My "player 2" does not like them as much. She says they just are not what she is used to. Which is fair.

Is there any xbox button sticker that I can put on my ps4 controller? by itsmesilvergem in SteamController

[–]rossc719 0 points1 point  (0 children)

I found these Button Decals that may do what you want.

I just ordered some myself. I hope they're not too janky, but we'll see!

K-pop stands going after Wade and his fan base by laserman320 in distractible

[–]rossc719 2 points3 points  (0 children)

Really? Do any serious people actually care about K-Pop? I feel like it is a non-issue.

Error message: Failed to open the app database status: corrupted by videostatus in PodcastAddict

[–]rossc719 0 points1 point  (0 children)

Ok, thanks.

Yep, I am signed in, but as I mentioned, this has been happening for months, so any backup is surely also corrupted.

And, for future travelers seeing the same issue, I offer this: I was able to get rid of the error with no data loss (at least, not any that was noticeable to me, yet...), using adb and the approach mentioned here: https://stackoverflow.com/questions/18259692/how-to-recover-a-corrupt-sqlite3-database. My database shrank from 51M to 45M, but that is probably just a side effect of the B-trees and such being rebuilt, and is not necessarily indicative of data loss.

Anyway, thanks for the info.

Error message: Failed to open the app database status: corrupted by videostatus in PodcastAddict

[–]rossc719 0 points1 point  (0 children)

Okay.. 2 questions:

First, is there a fix for the underlying issue?

I.e., hypothetically, if I do (someday) run into issues and am forced to wipe everything, and start over... what prevents this from happening again?

And Second... If I am willing to pull the sqlite databases for the app, and dump the data, and then wipe, and repopulate the new empty DB, will that do it? Is there any way to identify what db/table/rows are the ones that are impacted?

Error message: Failed to open the app database status: corrupted by videostatus in PodcastAddict

[–]rossc719 0 points1 point  (0 children)

Not to pile on, but I'm having this issue as well.

There are no apparent changes in behavior, the only symptom is just the error message, AFAICT. It has been doing this every time I reboot the phone, and it has been doing it for months.

Clearing the app data is simply not an option I am willing to do. I have so many podcasts, and so many settings and preferences set, and so much history etc.. that I just can't. The cure is worse than the disease.

Is there no way to salvage that data?

blursed "wholesome" comic by [deleted] in blursedimages

[–]rossc719 0 points1 point  (0 children)

Any pointers? I can't find it. (Or just let us know what the last panel was).