Couple 'Cleanup' Questions

Support
,
1

I’ve been using stash for a bit, and there are some things that are stuck in there that I can’t figure out how to fix.

The first one is from the porndb/metadata debacle. I have a bunch of files with the useless stashID metadataapi.net on them. Is there a way to strip that out of all my performers/videos? I’ve figured out how to do it manually but bleh.

The second one is a self inflicted wound. I while back, I was trying to fix a file mount and auto mount remounted the directory and I didn’t catch it and I did an rm -rf * (was having instances where NAS didn’t come up and my linux server was generating files on the local mount point because I didn’t read only it) I figured out what I did, stopped it, but a fair amount of scene covers were deleted.

However, stash doesn’t really care, it just doesn’t show it (shows the play button thing instead). The log will have something like:

25-05-25 18:13:38
Warning 
read transaction error on fetch screenshot: blob for checksum 6787c80c5f7ea01348d6c344c9ee41ea does not exist

but, it thinks it’s still there, so I can’t search by ‘isMissing’ covers. I’ve asked about this a few times on discord but haven’t really gotten a good answer, and it maybe because A). I’m not much of a programmer, need a cloud architecture? that’s me, need code? no don’t do that/udnerstand it.

If I do a scrape, it’ll put this in the log when I save it:

25-05-25 18:16:48
Warning 
File "/blobs/b3/c2/b3c2b99e4e1d2dbc860bded8646ccfb0" does not exist and therefore cannot be deleted. Ignoring.

and it fixes it, but, again, this is a manual process. If I run ‘identify’ since it thinks the file exists it skips it, so I’m trying to find a way to either make it understand the file is gone and mark it as gone, or something.

Would appreciate any suggestions, these aren’t ‘bugs’ far as I’m concerned more ‘stupid user tricks’ because mostly only I care about that hanging out there metadata thing and the covers not being ‘perfect’

2

You can run SQL to modify the database directly through the GraphQL playground at http://localhost:9999/playground to replace old domain with the new one.

  1. Will replace domain in the StashIDs.
    mutation {
  execSQL(sql: "update performer_stash_ids set endpoint = replace(endpoint, 'metadataapi.net','theporndb.net') where endpoint like '%metadataapi.net%';\nupdate scene_stash_ids set endpoint = replace(endpoint, 'metadataapi.net', 'theporndb.net') where endpoint like '%metadataapi.net%';\nupdate studio_stash_ids set endpoint = replace(endpoint, 'metadataapi.net', 'theporndb.net') where endpoint like '%metadataapi.net%';\nupdate scene_urls set url = replace(url, 'metadataapi.net', 'theporndb.net') where url like '%metadataapi.net%';\nupdate gallery_urls set url = replace(url, 'metadataapi.net', 'theporndb.net') where url like '%metadataapi.net%';\nupdate image_urls set url = replace(url, 'metadataapi.net', 'theporndb.net') where url like '%metadataapi.net%';\nupdate movies set url = replace(url, 'metadataapi.net', 'theporndb.net') where url like '%metadataapi.net%';\nupdate saved_filters set object_filter = replace(object_filter, 'metadataapi.net', 'theporndb.net') where object_filter like '%metadataapi.net%';\n") {
    rows_affected
  }
}
  2. Will replace the domain in the performer links.
    mutation {
  execSQL(sql: 
        "update performers set url = replace(url, 'api.metadataapi.net', 'metadataapi.net') where url like '%api.metadataapi.net%';update performers set url = replace(url, 'metadataapi.net', 'theporndb.net') where url like '%metadataapi.net%';") {
    rows_affected
  }
}

Credit to @Maista for the code snippets.

1 Like