Was looking at video artwork, and for all of my video's i have file paths to image locations that are non exsistent:
For example:
https://www.mediafire.com/view/c4qmdj1r ... 6.png/file
How can i search my entire database and clean up all those items?
I even see file paths that i have not used for couple of years.
Thumbnails with missing/wrong location.
Moderators: jiri, drakinite, Addon Administrators
-
CrashMonkey
- Posts: 223
- Joined: Sat Oct 21, 2023 10:34 am
Thumbnails with missing/wrong location.
I am using MediaMonkey on my Retro Systems, using the latest Beta build on Windows 11. Managing ~54k files
Re: Thumbnails with missing/wrong location.
There is no method for this. An Addon could be created to help with this kind of task. I don't think anyone has yet.
Download MediaMonkey ♪ License ♪ Knowledge Base ♪ MediaMonkey for Windows 2024 Help ♪ MediaMonkey for Android Help
Lowlander (MediaMonkey user since 2003)
Lowlander (MediaMonkey user since 2003)
-
CrashMonkey
- Posts: 223
- Joined: Sat Oct 21, 2023 10:34 am
Re: Thumbnails with missing/wrong location.
Do you know the Table name where the info is stored in the database, and the possible related tables/entrys? I guess if i remove the records there, and then do tag updates it would be gone?
Edit: Found them in the Table Covers.
will make backup before doing changes, but hope a dev could shed some light on this if it's the right process.
and if these kind of paths can go? this is the path that i use: C:\Data\PortableApps\MediaMonkey\Portable\
..\..\..\..\Data\PortableApps\MediaMonkey\Portable\VideoThumbnails\8B\IB55XZXES11JFRCN.jpg <-- items with ..\..\ files does nog exsist.
..\..\..\AppData\Local\Temp\ImageCache\18EE.tmp <-- path does not exist.
C:\Users\user\AppData\Local\Temp\ImageCache\2653.tmp <folder does not exsist, 100 if not more then a 1000 entries
C:\Data\PortableApps\MediaMonkey\Portable\Temp\ImageCache\B757.tmp < Temp dir, folder exsist, but only has 3files, 2 0kb files, and one 2mb file. And filenames are not matching. However i see 100+ entries in DB.
C:\Users\user2\AppData\Roaming\MediaMonkey5\Thumbs\9F\JU8AHGTHN5RACDYG.jpg -> this user2 + thumbs files does not exsit anymore, as i regenerated my database, and that user does not exist anymore.
So i think i need to delete the whole record entry, and not just the file location inside the record?
From what i saw, scrolling trough 80k+ records, that there at least 5000+ records with incorrect information.
Edit: Found them in the Table Covers.
will make backup before doing changes, but hope a dev could shed some light on this if it's the right process.
and if these kind of paths can go? this is the path that i use: C:\Data\PortableApps\MediaMonkey\Portable\
..\..\..\..\Data\PortableApps\MediaMonkey\Portable\VideoThumbnails\8B\IB55XZXES11JFRCN.jpg <-- items with ..\..\ files does nog exsist.
..\..\..\AppData\Local\Temp\ImageCache\18EE.tmp <-- path does not exist.
C:\Users\user\AppData\Local\Temp\ImageCache\2653.tmp <folder does not exsist, 100 if not more then a 1000 entries
C:\Data\PortableApps\MediaMonkey\Portable\Temp\ImageCache\B757.tmp < Temp dir, folder exsist, but only has 3files, 2 0kb files, and one 2mb file. And filenames are not matching. However i see 100+ entries in DB.
C:\Users\user2\AppData\Roaming\MediaMonkey5\Thumbs\9F\JU8AHGTHN5RACDYG.jpg -> this user2 + thumbs files does not exsit anymore, as i regenerated my database, and that user does not exist anymore.
So i think i need to delete the whole record entry, and not just the file location inside the record?
From what i saw, scrolling trough 80k+ records, that there at least 5000+ records with incorrect information.
I am using MediaMonkey on my Retro Systems, using the latest Beta build on Windows 11. Managing ~54k files
Re: Thumbnails with missing/wrong location.
"This thread is gold! I've been wrestling with that same issue of stale artwork paths for ages. Huge thanks for digging into the database and figuring out that the Covers table is where all the bad data lives. Going to make a backup and try clearing out those records myself. Fingers crossed for a dev confirmation on the process!"