Repair Orphan Location
Hey all, love the new repair section. Has help me declutter missing items a lot. There is one I can't seem to find though. The screenshot says this exists in the DB. But when I try and query that asset.id I get 0 results back. Anyone have an idea where this item is stored? It's the last one I need to fix
12 Replies
This would be in the users table.
It would be the profile picture for a user.
Ahhh, wrong table then. I'll dig into that, thank you!
How many orphan/untracked files did you have originally if I might ask?
I want to say was maybe 20. (Library size is about 13k)
What did you have to do to resolve them? Did it auto fix/repair or did you manually delete/correct?
About half were fixed by the auto repair, the other half I exported the json file and deleted them manually from the database
Ah, nice. Thanks for the info.
I wrote the code for that page and so far I've mostly heard reports of it not working lol.
I feel that. It does chug a little, but helped me a lot with finding erros more easily so I appreciate haha
Yeah, it basically does an entire library vs database comparison and needs to be optimized, especially for those with like 100k+ assets lol.
Always improvements to be had but would always rather have a good step in the right direction
Also updated profile picture and now my last error is gone, thank you!
Possible to use a temp table and let the database do the comparison? Maybe it’s faster
Something like that could work, yes.