Recent Posts

Pages: 1 2 3 4 5 [6] 7 8 9 10
51
Support / Re: Personal Video Database 1.0.2.7 MOD
« Last post by 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.
52
Support / Re: invalid class typecast
« Last post by Ivek23 on October 05, 2018, 06:47:57 am »
I get the Subject error ( invalid class typecast ) when trying to import 'Beyond the Trek' from TheMovieDB and get 'IOHandler value is not valid' if i try from AMAZON [EN].
I have used either of these sources successfully for years.
Any help would be appreciated.

This is because of a secure https:// connection.

Try Proxomitron - the next https solution for PVD, you may have to fix the problem with the AMAZON [EN] and TheMovieDB plugins.

Another partial solution is Personal Video Database 1.0.2.7 MOD, which will surely fix the TheMovieDB script for downloading information from TheMovieDB website.
53
Support / invalid class typecast
« Last post by DenS on October 04, 2018, 07:58:52 pm »
I get the Subject error ( invalid class typecast ) when trying to import 'Beyond the Trek' from TheMovieDB and get 'IOHandler value is not valid' if i try from AMAZON [EN].
I have used either of these sources successfully for years.
Any help would be appreciated.
54
Support / Re: Personal Video Database 1.0.2.7 MOD
« Last post by afrocuban on October 04, 2018, 04:00:07 pm »
Thanks for your idea, VVV. I remember I used that option at the very beginning, and that then as I can remember it deleted some records I didn't want to. Do you by any chance know what exactly optimizing will do to my database? I hae never ever had some problem with PVD database speed, but whatever - I'll do it if my records will not be deleted or database corrupted.

Kind regards
55
Support / Re: Personal Video Database 1.0.2.7 MOD
« Last post by VVV_Easy_Programing on October 04, 2018, 10:32:43 am »
Have you used the Tools/Optimize database ... ?
Perhaps it solved your "write protected" records but I warm you that it spend a lot, a lot of time.
With a 7.000 movies you must have more of 200.000 persons!
Perhaps you will spent one or two days with PVD working and the PC un-responding.
56
Support / Re: Personal Video Database 1.0.2.7 MOD
« Last post by afrocuban on October 03, 2018, 09:06:50 pm »
Thank you for your feedback, guys. Good to know that I'm not the one who messed up database, since you two have also people duplicates. Thanks for FA rating and all "hidden" custom fields.
I tried your SQL script in debug mode, cause I also notice mistakes in imported urls. Thank you for that. It didn't want to run with "As script" unchecked (some dynamic error...) so I ran it "As script", and although my database is which is over 15GB, with posters it finished in 3-4 minutes claiming "Script successfully executed"
After that I tried to update movies I stated above, but no luck. But, for example, I just repeated update for "All About Eve" which didn't succeed at first, and now it succeeded?! It never happened in original PVD, and the only conclusion I can make is that if some field isn't rewritable (for God knows what reason) the record cannot be updated.

I'd appreciate any further help on this and am more than grateful for your tremendous work and efforts to make PVD alive!

My best regards to you two.

57
Support / Re: Personal Video Database 1.0.2.7 MOD
« Last post by 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/xxxxxxx
FilmAffinity (finish with '.html', maybe spanish (several countries) or english):
BTW, in the last times of imdb.dll pluging it retrived bad movie and people url (for instance for directors with URL+'?ref_=tt_ov_dr' and writers URL+'?ref_=tt_ov_wr'). In that moment I wrote a little SQL script (you can use it in debug PVD mode in one hidden option of Help menu) in order to correct the database:
                 update PEOPLE set "url"=replace("url",'?ref_=tt_ov_dr', '/');
                 update PEOPLE set "url"=replace("url",'?ref_=tt_ov_wr', '/');
perhaps it may help to correct something.

I just wanted to ask if it's possible FA to have it's own rating custom field?
In the next MOD version I will include the solution that Ivek was advancing
 AddCustomFieldValueByName('FilmAffinity_Rating',ItemValue);
because it doesn't nothing bad for the "normal" users but you need add by yourself this Custom field.

BTW, I have included several 'hidden' Custom Fields of Ivek23 in the scripts.
Ivek23, perhaps can be useful for other users open a new Thread with the information "Possibles improving Custom Fields" working in MOD version, how is the information and how add in the PVD database.
58
Support / Re: Personal Video Database 1.0.2.7 MOD
« Last post by Ivek23 on October 02, 2018, 08:16:44 am »
Quote
I mean, and I'm not sure at all, when we started to use IMDb scripts I noticed that I have duplicate entries for people. It's like some people were imported by nostra's imdb.dll and their duplicates with scripts. So now, for example I have two (sometimes, even more) actors with the same name in database and their filmography is split (to movies imported by imdb.dll and other part with script).

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.
59
Support / Re: Personal Video Database 1.0.2.7 MOD
« Last post by Ivek23 on October 02, 2018, 08:15:05 am »
Quote
imdb.com/title/tt0034583/
 imdb.com/title/tt0082176/
 imdb.com/title/tt0070518/
 imdb.com/title/tt0074252/

Casablanca (1942)
https://www.imdb.com/title/tt0034583/

Christiane F. - Wir Kinder vom Bahnhof Zoo (1981)
https://www.imdb.com/title/tt0082176/

Pat Garrett & Billy the Kid (1973)
https://www.imdb.com/title/tt0070518/

Brutti, sporchi e cattivi (1976)
https://www.imdb.com/title/tt0074252/
60
Feature Suggestions / Re: FilmAffinity English
« Last post by Ivek23 on October 02, 2018, 07:21:59 am »
Hello,

I just wanted to ask if it's possible FA to have it's own rating custom field?

Thank you in advance

Why not.

This is supposed to be a custom field.

Quote
AddCustomFieldValueByName('FilmAffinity_Rating',ItemValue);
Pages: 1 2 3 4 5 [6] 7 8 9 10