English > Support
Personal Video Database 1.0.2.7 MOD
afrocuban:
--- Quote from: VVV_Easy_Programing on September 27, 2018, 06:04:00 pm ---Nice to know about you, afrocuban :D
--- End quote ---
Thank you! I really enjoy it!
--- Quote ---You have got a hard error, it seems that PVD tries to dulicate some record with a SQL instruction.
Some information in in this link: Why am i getting a primary/unique key violation/
--- End quote ---
Thank you, dear VVV. I read and I think it's exactly the problem I experienced. Unfortunately, I do not programming, so it wasn't too much helpful for me, but I understand what it says.
--- Quote ---Some test in order to detects/reproduce the problem:
* Have you more Customs Fields that the MOD estandar? (In the last version I have include 'Updated').
--- End quote ---
Yes, I do. A lot more.
--- Quote ---
* The error cames in the same movies? If yes, can tell us.
--- End quote ---
YES!
--- Quote ---
* The error cames with other scripts/provider? If yes, can tell us.
--- End quote ---
No. Checked with FA and TMDb.
--- Quote ---
* Can you try disabling IMDB pages donwloading with the ***Script M. Configuration***? First try only dowloading the base page, after adding the Certification page, after adding the "Also Know as' page,... I suspect of the retreive of people because it is the part less depurated in PVD and the one that handles more links.
--- End quote ---
I must admit I don't know how to use ***Script M. Configuration***. When I call it, only dialog box with options for all scripts pops up, and when i save configuration, PVD restarts.
I try only to update Title, Top_250 and IMDb_Votes (Yes, you made a problem for me, hahaha. My custom fields were "Top 250:" and "IMDB Votes:", so now because you gave them different names, I have to update 7000 movies, and I ran into this problem when updating, hahah").
But, I did what you suggest - I disabled updating fields in IMDb script and I discovered that if I disable updating some or all fields, everything works, for now!? Not all of these fields cause problems for movies. For some movie only one field causes problem, for other movie other two fields, and for some movies all these fields. Sometimes, If I repeat import, it succeeds??? Strange thing is that I discovered also that for some movies I cannot manually delete Title when edit movie. If I delete it, when I press to exit edit mode, deleted Title comes back? Also the same for Description for some some movies - I delete it and it comes back when I exit edit mode?!
--- Quote ---Really is a strange error, ???
--- End quote ---
Definitely.
Conclusion: It has problems with overwriting existing fields, that cannot be deleted even manually
At the end: a great respect and thank you for "Metascore" field!
Kind regards
VVV_Easy_Programing:
--- Quote ---Have you more Customs Fields that the MOD estandar? ... A lot more.
--- End quote ---
The PVD is very stable but it have some inner problems: Be careful with spaces in the Custom Fields.
--- Quote ---The error cames in the same movies? ... YES!
--- End quote ---
If you tell us the movie title perhaps Ivek32 or myself can reproduce the problem.
--- Quote ---The error cames with other scripts/provider? ... No. Checked with FA and TMDb.
--- End quote ---
So the problem is with the IMDB scritp. This is a very complicated script. In the default version it dowloads 6 web pages, everyone with his own routine. So is very important to know what page 'fails'. BTW, if you are updating only some fields you are downloading a lot of not needed pages.
--- Quote ---I must admit I don't know how to use ***Script M. Configuration***.
--- End quote ---
I must rebuke you ;D.
You are losting a lot of time. I rewrite the ***Script M. Configuration*** help in this post Controling the retreived information in PVD MOD
If you are trying only to update Title, Top_250 and IMDb_Votes You only need the principal page so you must uncheck the other 5 pages! (7000 movies x 5 pages = 35.000 downloads saved) Please, make a little efort ;)
--- Quote ---My custom fields were "Top 250:" and "IMDB Votes:", so now because you gave them different names, I have to update 7000 movies,
--- End quote ---
You don't need create a new fields, you can rename its. See this post
--- Quote ---I disabled updating fields in IMDb script and I discovered that if I disable updating some or all fields, everything works, for now!? Not all of these fields cause problems for movies. For some movie only one field causes problem, for other movie other two fields, and for some movies all these fields.
--- End quote ---
Please, tell us those fields and movies! As I wrote in the forum, there is some uses of the database for the script not very safe (use Description and Comments, fields that are used for movie information and user file information, etc). The PVD database standar is not completely finished.
One more example of this, if you wants to update the Comments or the user Rating (not the IMDBrating) with a script you must clear it before (normaly with the Mass Editor)
--- Quote ---If I delete it, when I press to exit edit mode, deleted Title comes back? Also the same for Description for some some movies - I delete it and it comes back when I exit edit mode?!
--- End quote ---
Perhaps you have people information (awards, featured, etc) with the same movie that you have.
PVD have information of the movie by two way: By Movie list and by People info (for this I not download the People's awards, it brings to PVD a lot of unknowed movies).
afrocuban:
Dear VVV,
Thank you so much for your feedback!
I'll try to be brief as possible in my response.
1. I have never had any problems with spaces, although aware of possible problems. I tested them before start to use them almost 9 years ago.
2. To reproduce the problem, maybe better idea is to make a new database that consists only a few problematic movies and then send it to you (with my pvdconf.ini and my skin)? Anyway, some movies are:
imdb.com/title/tt0034583/
imdb.com/title/tt0082176/
imdb.com/title/tt0070518/
imdb.com/title/tt0074252/
3. Probably the problem is with IMDb script. But, not only movie, but now I suspect that people are problem too, even before I started to use PVD MOD. 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). If I update both, I get full filmography in both, but links to movies are still split. If I delete any name, I loose them in movies linked to that name. That is why I suggested to send you a small database. Is it even possible to overcome this?
4. I know you won't believe me, but renaming custom fields never worked for me. Of course I tried it once again before started to update database this time, but it just didn't showed up after renaming. My PVD is heavily customized, and I use my own skin (please check the screenshot enclosed), so I'm pretty aware of all aspects of renaming/updating fields. I tried also with IMDb User Reviews/Comments (my custom field name is different), but again to no avail. Simply said - total mystery to me.
5. Fields that I wanted to update/overwrite were: Description, IMDb User Reviews/Comments, Title (not origtitle), Top 250, IMDb Votes, Box Office, Actors, Director.
Kind regards and thank you for your time!
Ivek23:
--- Quote --- imdb.com/title/tt0034583/
imdb.com/title/tt0082176/
imdb.com/title/tt0070518/
imdb.com/title/tt0074252/
--- End quote ---
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/
Ivek23:
--- 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).
--- End quote ---
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.
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version