Post reply

Warning: this topic has not been posted in for at least 120 days.
Unless you're sure you want to reply, please consider starting a new topic.

Note: this post will not display until it's been approved by a moderator.

Name:
Email:
Subject:
Message icon:
Attach:
(Clear Attachment)
(more attachments)
Allowed file types: gif, jpg, png, txt, tpl, lng, ini, pvd, psf, ini, cfg, csv, zip, xml, pas, 7z
Restrictions: 4 per post, maximum total size 1024KB, maximum individual size 1024KB
Note that any files attached will not be displayed until approved by a moderator.
Verification:
Type the letters shown in the picture
Listen to the letters / Request another image

Type the letters shown in the picture:
How many words are in this question?:

shortcuts: hit alt+s to submit/post or alt+p to preview


Topic Summary

Posted by: Ivek23
« on: October 16, 2023, 09:34:32 am »

Quote from: NetworkShark on October 15, 2023, 09:55:12 pm
Hi guys,

I am not sure if this thread is valid also because IMDB changed the site (I tested the current script with a new DB and the indicated movie but the freeze does not happen) .

If it is valid, however, I am here to help resolve the issue.

PS:
If I am writing without anyone responding, I would advise the moderators to close the thread in a few months.

Of course, this problem no longer exists because Storyline information from the basic IMDb movies page can no longer be downloaded.
Posted by: NetworkShark
« on: October 15, 2023, 09:55:12 pm »

Hi guys,

I am not sure if this thread is valid also because IMDB changed the site (I tested the current script with a new DB and the indicated movie but the freeze does not happen) .

If it is valid, however, I am here to help resolve the issue.

PS:
If I am writing without anyone responding, I would advise the moderators to close the thread in a few months.
Posted by: pelisdb
« 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.
Posted by: UtNut
« on: April 30, 2018, 09:42:45 pm »

Quote from: Ivek23 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.

Well, it started with this one:
Dallas (1978-1991)
https://www.imdb.com/title/tt0077000/
Posted by: Ivek23
« on: April 30, 2018, 08:50:08 pm »

Quote from: pelisdb 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.

pelisdb, or you could write a code to clean the description field with the sql command.
Posted by: Ivek23
« 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.
Posted by: UtNut
« 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
Posted by: Ivek23
« on: April 30, 2018, 07:20:36 pm »

The error is in the Imdb script, I will try to find it.
Posted by: Ivek23
« 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.
Posted by: UtNut
« on: April 30, 2018, 12:17:06 pm »

Quote from: Ivek23 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).

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.
Posted by: pelisdb
« 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.
Posted by: Ivek23
« 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.
Posted by: UtNut
« 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.
anything