2020-10-19, 22:16
(2020-10-19, 21:41)nicgentile Wrote:Same change done with phpmyadmin + removing texture13.db & "Thumbnails" folder : still few movie posters are left blank, but problem is here by me since a long time.(2020-10-19, 16:42)vtwin0001 Wrote: For those only with how to edit the database with sqlitestudio, I found a way to correct the posters not showing.
I dont know if it fixes the whole thing or just a bit.. but this might be a temporary solution in the time this gets a final solution
Go to sqlitestudio and Open SQL Editor
write in the blank editor window:
UPDATE art
SET url = REPLACE(url,"http://image.tmdb.org",'https://image.tmdb.org');
Press the execute query button and you're done
This made my DB show all the missing thumbnails
Hope this works, however I ask the mods and everyone else if they feel this solution is not good or should not be out in the wild, you are free to delete this message (so people wont get confused etc)
My CLI version derived from this. You can run it in a bash terminal. Test before you run it. And have a backup. Otherwise, things might get weird. Worked for me, might not work for you.
sqlite3 MyVideosXXXX.db "UPDATE art SET url = REPLACE(url,'http://image.tmdb.org','https://image.tmdb.org')";