English > Support
Personal Video Database 1.0.2.7 MOD
VVV_Easy_Programing:
This is easy: in both "13" and "After life" imdb url's lacks "www" remeber the standar url is:
http://www.imdb.com/title/ttxxxxxxx/
Perhaps you can use the SQL script:
update MOVIES set "url"=replace("url",'http://imdb', 'http://www.imdb');
.
BTW, one tools that can help you is pass the db to Excel with the export template "CSVDB" and search with the excel filters some bizarre things.
--- Quote ---Do you by any chance know what exactly optimizing will do to my database?
--- End quote ---
It will do as you select: delete duplicates entries, delete orphan persons (persons not related with your movies). You can select if it will do with all movies/people or only qith the visible (so you can protect movies with a filter and hidde it's)
afrocuban:
Thanks VVV. It's clear now.
Is it possible then, considering your statement:
--- Quote from: VVV_Easy_Programing on October 03, 2018, 12:13:40 pm ---I have found different url formats versions in my PVD too?
Can we write a fast url standards?
My proposal is (remember that we cann't use httpS):
IMDB Movie (finish with '/'=Slash):
* Movie=http://www.imdb.com/title/ttxxxxxxx/
* Person=http://www.imdb.com/name/nmxxxxxxx/TMDB (NO finish with '/'=Slash):
* Movie=http://www.themoviedb.org/movie/xxxxxxx
* Person=http://www.themoviedb.org/person/xxxxxxxFilmAffinity (finish with '.html', maybe spanish (several countries) or english):
* Movie Spanish= http://www.filmaffinity.com/es/filmxxxxxxx.html
* Movie English= http://www.filmaffinity.com/en/filmxxxxxxx.html
--- End quote ---
... to standardize urls in form:
[*.]imdb.com/title/ttxxxxxxx/
[*.]imdb.com/name/nmxxxxxxx/
Ivek23:
--- Quote from: afrocuban on October 06, 2018, 12:00:34 pm ---Dear VVV and Ivek,
Meanwhile, I have experienced another strange issue. While updating some movies, it asks me to confirm the movie, although IMDb urls are already in database, and for for twice!. You can check comparing offered url on the first screenshot (question marks), with the url already in database in the second screenshot (red arrow) - they are the same.
Also, for some movies I get infobox "Movie not found :)" although IMDb url exists - please see third screenshot?!
It didn't happen earlier.
It's like script doesn't use existing urls. Why is that?
Any idea? Thank you in advance.
--- End quote ---
I myself have written here why this happens, and who is responsible for problems with IMDB url addresses. This is the IMDB plugin, which caused problems to the afrocuban and also to me, but I edited it manually by adding " www " letters in the IMDB url.
--- Quote from: Ivek23 on October 02, 2018, 08:16:44 am ---There is a possibility that duplicates are people for certain reasons, such as different url addresses (or they are not at all) for people. I have already noticed this in my IMDB records for people. For the IMDB plugin was the download URL of the Imdb reference pages without " www " in the url address. IMDB script has downloaded a full url with Main (overview) Imdb pages.
Finally, I had a similar problem with the TheMovieDB [API] script, where there was a problem with url titles for the Director because the script code was incorrectly written in the script and there were duplicate names for the director because of this, but not for all, only in certain cases.
--- End quote ---
VVV_Easy_Programing:
--- Quote ---Is it possible then, considering your statement:
... to standardize urls in form:
[*.]imdb.com/title/ttxxxxxxx/
[*.]imdb.com/name/nmxxxxxxx/
--- End quote ---
I think to do that this is dificult because the script use the parameter
BASE_URL_PRE = 'http://www.imdb.com/title/''
to make the url and for search if exist the url.
And this is risky because if the original PVD came to live again it use the same behavior with the Function GetBaseURL for locate the url.
But Ivek23 and you don't need add 'www' manual the SQL script (remeber, in debug mode Help/SQL, As script checked)
update MOVIES set "url"=replace("url",'http://imdb', 'http://www.imdb');
works fine: I test it.
afrocuban:
Hello VVV,
Thank you for another SQL tip. I applied it immediately upon you first right about it, and it worked like a charm! I just thought if it's possible to generalize the term as much as possible, because we don't know what will happen with IMDb code in the future and with maintain of PVD and IMDb script, but hey - we will survive. I have my database for 20 years, from the first days of "WhereIsIt?" program, til final solution - PVD.
About optimizing database, thank you for explanation, but I think I mustn't use it because it looks it will do exactly what I don't want at any cost - it'll delete duplicate people, so I would loose them in movies, so I would again have to update 7000 movies to get people back, again most probably to get duplicates. The only solution to duplicates that I see is to delete all people, then to update all movies with people records (director, actor, producer, writer, composer, etc...).
Maybe I'd do that, but only when I'm sure that I will be able to update movies without breaks that I have now.
To add to this, I hve experienced one more IMDb script issue:
- If URL doesn't have slash - "/" at the and, we get "404" error message, like URL doesn't exist on imdb.com, while actually url is valid. Please see first screenshot attached.
- After pressing OK (1-5 times, depending on how many pages are imported), script adds ghost link: - "http:/"? Please check second screenshot.
Anything we can do about this?
Best regards
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version