Author Topic: PVD freezes using certain script.  (Read 2499 times)

0 Members and 1 Guest are viewing this topic.

Offline UtNut

  • User
  • ***
  • Posts: 74
    • View Profile
PVD freezes using certain script.
« on: April 29, 2018, 04:37:17 pm »
Hoping there's a good-hearted soul in this forum who can steer me in the right direction.

I have never encountered this problem before but suddenly when I import using Imdb Movie Info Script 0.1.1.2, PVD freezes and is not responding for hours. Only thing I can do is to force PVD to exit and when I start it up again the record is there but there's nothing I can do with, not delete it or edit it, when I click on it PVD starts to be irresponsive again.

What have I done sofar.

Well obviously I looked around but could not find a satisfying answer. I use version 0.9.9.21 and tried latest version 1.0.2.7, opened PVD on another computer, tried firebird tools, exported it to excel and csv to get rid of the culprit, all to no avail. All other scripts work fine.

So any advice is more than welcome, tia.
1984 was NOT supposed to be an instruction manual

Offline Ivek23

  • Global Moderator
  • *****
  • Posts: 2349
    • View Profile
Re: PVD freezes using certain script.
« Reply #1 on: April 30, 2018, 06:18:00 am »
It's a very famous problem.

Try removing Imdb Movie Info Script 0.1.1.2 first so that you can re-add it back. Then restart PVD and try to remove this record. If this does not work, restart PVD and try to restore the database. This means that if you already have it or you have made a backup copy, then you will not lose much or too much data (from my own experience it is good after every successful data entry to make a backup copy of the database, then I can recover if necessary).

Another option that is even more likely is to temporarily remove the current skin and then later return it back. Then restart PVD and try to remove this record. If this does not work, restart PVD and try to restore the database. Current skin then later return it back.

This happens when Imdb Movie Info Script encounters a kind of problem and can not download information. The error is in the Imdb Movie Info Script code. Also, try the Imdb Top 250, IMDb Rating and Studio (2) script, which you will find on the link below.

http://www.videodb.info/forum_en/index.php/topic,4123.msg20360.html#msg20360

I hope Imdb Top 250, IMDb Rating and Studio (2) script will work and there will be no more problems with PVD freeze. But if there are still problems, please write me the title of the movie and the Imdb url link so I can verify the problem.
Ivek23
Win 7 32bit, 64bit   PVD v0.9.9.21, PVD v1.0.2.7 + MOD


Offline pelisdb

  • Member
  • *
  • Posts: 15
    • View Profile
Re: PVD freezes using certain script.
« Reply #2 on: April 30, 2018, 10:46:12 am »
Hi, Ivek: thanks for allyour great work!

I'm having this problem with the movie http://www.imdb.com/title/tt0031022/, with the script Imdb Top 250, IMDb Rating and Studio (2). I have made a few tests and in fact the script is finishing correctly, the trouble is that is getting a lot of text and HTML code on the description. By cleaning the description field with a sql command the program opens again.
« Last Edit: April 30, 2018, 07:01:15 pm by pelisdb »

Offline UtNut

  • User
  • ***
  • Posts: 74
    • View Profile
Re: PVD freezes using certain script.
« Reply #3 on: April 30, 2018, 12:17:06 pm »
It's a very famous problem.

Try removing Imdb Movie Info Script 0.1.1.2 first so that you can re-add it back. Then restart PVD and try to remove this record. If this does not work, restart PVD and try to restore the database. This means that if you already have it or you have made a backup copy, then you will not lose much or too much data (from my own experience it is good after every successful data entry to make a backup copy of the database, then I can recover if necessary).

I removed the script, but it doesn't solve the problem.

Quote
Another option that is even more likely is to temporarily remove the current skin and then later return it back. Then restart PVD and try to remove this record. If this does not work, restart PVD and try to restore the database. Current skin then later return it back.

I've tried that with latest version 1.0.2.7 and the standard skin, I use 0.9.9.21 with a different skin, alas to no avail.

Quote
This happens when Imdb Movie Info Script encounters a kind of problem and can not download information. The error is in the Imdb Movie Info Script code. Also, try the Imdb Top 250, IMDb Rating and Studio (2) script, which you will find on the link below.

http://www.videodb.info/forum_en/index.php/topic,4123.msg20360.html#msg20360

Yes, I tried that and it works fine, but still I can not remove or delete the record.

Quote
I hope Imdb Top 250, IMDb Rating and Studio (2) script will work and there will be no more problems with PVD freeze. But if there are still problems, please write me the title of the movie and the Imdb url link so I can verify the problem.

It's not so much a specific record, when I import any movie with that script, PVD freezes. Even on another PC I've installed PVD and still without the script being loaded, it freezes the moment I click on that record.

BTW, I much appreciate your reply Ivek, and I really hope there is a solution to this problem.
1984 was NOT supposed to be an instruction manual

Offline Ivek23

  • Global Moderator
  • *****
  • Posts: 2349
    • View Profile
Re: PVD freezes using certain script.
« Reply #4 on: April 30, 2018, 06:46:48 pm »
Try running PVD in debug mode and then add a log.txt file to the forum. You can also run PVD in debug mode and try the script, and then add a log.txt file to the forum to see if I can find an error.

Then, maybe I write new instructions for advice on a possible solution to the problem.
Ivek23
Win 7 32bit, 64bit   PVD v0.9.9.21, PVD v1.0.2.7 + MOD


Offline Ivek23

  • Global Moderator
  • *****
  • Posts: 2349
    • View Profile
Re: PVD freezes using certain script.
« Reply #5 on: April 30, 2018, 07:20:36 pm »
The error is in the Imdb script, I will try to find it.
Ivek23
Win 7 32bit, 64bit   PVD v0.9.9.21, PVD v1.0.2.7 + MOD


Offline UtNut

  • User
  • ***
  • Posts: 74
    • View Profile
Re: PVD freezes using certain script.
« Reply #6 on: April 30, 2018, 07:28:26 pm »

If it's still useful to you here's the log txt file

(30/04/2018 20:21:31) PVD Version: 1.0.2.7
(30/04/2018 20:21:31) OS: Windows 7
(30/04/2018 20:21:31) GlassFrame Enabled
(30/04/2018 20:21:31) Plugin loaded: amazon.dll 0.4.4.6
(30/04/2018 20:21:31) Plugin loaded: amazonuk.dll 0.1.1.5
(30/04/2018 20:21:31) Plugin loaded: amc.dll 0.3.1.0
(30/04/2018 20:21:31) Plugin loaded: csvimp.dll 0.1.3.1
(30/04/2018 20:21:31) Plugin loaded: imdb.dll 0.9.8.22
(30/04/2018 20:21:31) Plugin loaded: imdb_people.dll 0.3.0.19
(30/04/2018 20:21:31) Plugin loaded: mpexport.dll 0.1.0.2
(30/04/2018 20:21:31) Plugin loaded: msexcel.dll 0.4.1.0
(30/04/2018 20:21:31) Plugin loaded: plainexp.dll 0.7.1.2
(30/04/2018 20:21:31) Plugin loaded: scriptint.dll 0.3.0.2
(30/04/2018 20:21:32) Plugin loaded: tvdb.dll 0.1.1.0
(30/04/2018 20:21:32) Plugin loaded: valueconvert.dll 0.1.0.2
(30/04/2018 20:21:32) Compiling script: adultdvdempire.psf
(30/04/2018 20:21:32) Script compiled successfully: adultdvdempire.psf
(30/04/2018 20:21:32) Executing script binary
(30/04/2018 20:21:32) Compiling script: AllRovi.psf
(30/04/2018 20:21:32) Script compiled successfully: AllRovi.psf
(30/04/2018 20:21:32) Executing script binary
(30/04/2018 20:21:32) Compiling script: Imdb Movie Info(title).psf
(30/04/2018 20:21:32) Script compiled successfully: Imdb Movie Info(title).psf
[Hint] (264:2): Variable 'DEBUG_POS1' never used
(30/04/2018 20:21:32) Executing script binary
(30/04/2018 20:21:32) Compiling script: Imdb Movie Info.psf
(30/04/2018 20:21:32) Script compiled successfully: Imdb Movie Info.psf
(30/04/2018 20:21:32) Executing script binary
(30/04/2018 20:21:32) Script loaded: adultdvdempire.psf 0.1.2.0
(30/04/2018 20:21:32) Script loaded: AllRovi.psf 0.1.1.6
(30/04/2018 20:21:32) Script loaded: Imdb Movie Info(title).psf 0.1.2.0
(30/04/2018 20:21:32) Script loaded: Imdb Movie Info.psf 0.1.1.2
(30/04/2018 20:21:34) Loading database: D:\Personal Video Data\130209_VEER.PVD
1984 was NOT supposed to be an instruction manual

Offline Ivek23

  • Global Moderator
  • *****
  • Posts: 2349
    • View Profile
Re: PVD freezes using certain script.
« Reply #7 on: April 30, 2018, 07:42:18 pm »
UtNut, please write me the title of the movie and the Imdb url link so I can verify the problem.
Ivek23
Win 7 32bit, 64bit   PVD v0.9.9.21, PVD v1.0.2.7 + MOD


Offline Ivek23

  • Global Moderator
  • *****
  • Posts: 2349
    • View Profile
Re: PVD freezes using certain script.
« Reply #8 on: April 30, 2018, 08:50:08 pm »
Hi, Ivek: thanks for allyour great work!

I'm having this problem with the movie http://www.imdb.com/title/tt0031022/, with the script Imdb Top 250, IMDb Rating and Studio (2). I have made a few tests and in fact the script is finishing correctly, the trouble is that is getting a lot of text and HTML code on the description. By cleaning the description field with a sql command the program opens again.

pelisdb, or you could write a code to clean the description field with the sql command.
Ivek23
Win 7 32bit, 64bit   PVD v0.9.9.21, PVD v1.0.2.7 + MOD


Offline UtNut

  • User
  • ***
  • Posts: 74
    • View Profile
Re: PVD freezes using certain script.
« Reply #9 on: April 30, 2018, 09:42:45 pm »
UtNut, please write me the title of the movie and the Imdb url link so I can verify the problem.

Well, it started with this one:
Dallas (1978-1991)
https://www.imdb.com/title/tt0077000/
1984 was NOT supposed to be an instruction manual

Offline pelisdb

  • Member
  • *
  • Posts: 15
    • View Profile
Re: PVD freezes using certain script.
« Reply #10 on: April 30, 2018, 10:05:17 pm »
Hi Ivek:

The problem is in the spaces and line feeds they put between elements. Also the <p> now comes before the <span itemprop="description" part, not after like before (I found and old page I had saved and saw the differences. I changed the description code to this:

//~Description~
curPos := Pos('<h2>Storyline</h2>', HTML)
If Pos('<h2>Storyline</h2>', HTML) > 0 then begin
EndPos := PosFrom('<span itemprop="description">', HTML,curPos);
//curPos := PosFrom('<p>', HTML, EndPos);
    curPos := curPos + Length('<span itemprop="description">');
   EndPos := PosFrom('<em class="nobr">', HTML, curPos);
   TmpStr00 := RemoveTags(Trim(Copy(HTML, curPos, endPos - curPos)), false);
   if TmpStr00 <> '' then AddFieldValueXML('description', TmpStr00);
end;

The sql command I used was:

UPDATE MOVIES SET "description"='' WHERE "mid"=4946

where 4946 was the id of the movie corrupted.

But I don't know exactly how to do it inside the program,in my case just as I opened PVD it hanged, so I had to use an external database program: I connected to the movies database with odbc, and sent the command. If someone can't open the program that it hangs, and has a database under 2gb, he could send it to me with wetransfer and I could clean that description.

 

anything