New XMLTV Enhancer and more...

[tjb]

Hi Frank,

First of all, thanks for the help you gave me last week getting everything working. I'm hoping you might have some time to look at a small problem I'm having - UltraXMLTVEnhancer has been hanging on me based on the number of days that I enter in the xmltv listings. I eventually narrowed it down to a single program episode that was in the xmltv file (I have attached an xmltv file that contains only this listing, so hopefully you will be able to reproduce the error). Funny thing, is if I change the end time for the show by a minute, then the entry is processed okay.

Thanks again,
Terry

[zehd]

Not 'ere it don't ...

After processing, the TVdbXML folder contains a file called:
"law & order.Episodes.xml"
that contains:
"Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND tvepisodes.lastupdated>0 ORDER BY season, EpisodeNumber' at line 1".

I guess that this message is being generated by the database software at TVdb because the SQL contains an "&" that ain't in quotes or doubled-up or whatever.

For the avoidance of doubt:

My original xml file has been stripped to a minimum and contains this:

<?xml version="1.0" encoding="ISO-8859-1"?>
<tv date="20080304" generator-name="XMLTV GUI V. 3.09.03W" generator-url="http://www.birtles.org.uk/xmltv">

<channel id="channel5.co.uk">
<display-name lang="en">Five</display-name>
</channel>

<programme start="20080304124500 +0000" stop="20080304134500 +0000" channel="channel5.co.uk">
<title lang="en">Law and Order</title>
<sub-title lang="en">Born Again</sub-title>
<desc lang="en">Blah.</desc>
<credits>
<actor>Sam Waterston</actor>
</credits>
<category lang="en">Drama</category>
</programme>

</tv>

My epfetchinclude contains this:

law and order

My replace.ini contains this:

[Replace]
law and order=law & order

Yet More Thanks

Graham

Excellent. You are falling for my "Keep people away from the TV" plot to rule the world...

In your TVdbxml folder kill anything Law blah blah

Copy over the xml files that are in the attached zip.

Open Enhancer, click Config Episode. DO NOT click Fetch Series. This will initiate another force download, and I think something is suspect.

Now assuming that your prog is setup the way you finished describing, in the top dropdown, type "Law and Order", then in the second, "Prescription for Death"

Click the Q button. You should get a msgbox saying 01 01

Let me know if that happens...

[zehd]

Hi Frank,

First of all, thanks for the help you gave me last week getting everything working. I'm hoping you might have some time to look at a small problem I'm having - UltraXMLTVEnhancer has been hanging on me based on the number of days that I enter in the xmltv listings. I eventually narrowed it down to a single program episode that was in the xmltv file (I have attached an xmltv file that contains only this listing, so hopefully you will be able to reproduce the error). Funny thing, is if I change the end time for the show by a minute, then the entry is processed okay.

Thanks again,
Terry

Hi Terry...

Thank you for showing me this and even telling me that changing the time slightly will work. I have another person's file I'm having the same problem, but couldn't find it... Your may have identified the problem and that's half the battle...

It's quite possible it's happening in the date/time handling although when I looked it seemed like Enhancer was looping and it shouldn't be.

Give me some time.

[Graham]

Let me know if that happens...

I get the expected result when I use the xml files from your attachment, that is, a pop-up box that says "01 01". The entry in the Series box automatically changes from "Law and Order", which is what I typed, to "Law & Order" which I presume is because the replace.ini kicks in before it does the look-up in the TVdbXML folder.

I then hit "Purge TVdb Cache", then type "Law and Order" in the Series box and press "Fetch Series". "Law and Order" changes to "Law & Order", there is a brief pause (while it fetches from TVdb, "Prescription for Death" appears in the Episodes box, pressing "Q" gives me "01 01" popup. Selecting the last episode from the dropdown list, "Tango", and pressing "Q" gives me "18 10" popup.

I then hit "Go" to process the xmltv.xml file from my earlier post. Again, I get the expected result, the sub-title in the output file contains the series and episode numbers.

I then hit "Purge TVdb Cache", then "go" and it fails to download the xml files from TVdb. The TVdbXML folder contains the attached.

Hope this helps.

Graham

[zehd]

Hi Frank,

First of all, thanks for the help you gave me last week getting everything working. I'm hoping you might have some time to look at a small problem I'm having - UltraXMLTVEnhancer has been hanging on me based on the number of days that I enter in the xmltv listings. I eventually narrowed it down to a single program episode that was in the xmltv file (I have attached an xmltv file that contains only this listing, so hopefully you will be able to reproduce the error). Funny thing, is if I change the end time for the show by a minute, then the entry is processed okay.

Thanks again,
Terry

I fixed the duration bug. .95 is on the wiki

[tjb]

I fixed the duration bug. .95 is on the wiki

Thanks for the help, Frank - and thanks for a great application.

[zehd]

I then hit "Purge TVdb Cache", then "go" and it fails to download the xml files from TVdb. The TVdbXML folder contains the attached.

It does help. I now know exactly WHEN the error starts happening for you. Almost there. So far you have everything setup for the replacement and fetch.

Obviously, when there are no preexisting files, the query fails....

[zehd]

I then hit "Purge TVdb Cache", then "go" and it fails to download the xml files from TVdb. The TVdbXML folder contains the attached.

I hesitate to say it's fixed, but I think it is. .96 is on the wiki.

The query routine purposely did not try to download a fresh copy of the episode information, because that would be a lot of downloading for shows like Law and Order, Simpsons, and Two and Half Men. (Man the Writers strike really screwed things up)

Anyway, I have it download a new only if it doesn't previously exist.

I should point out that if the show was previously marked "dont.fetch' or 'wrong.data' then the query will not try again.

If you have made an error and the show does exist, then Type it in manually (in config Episodes) and click 'Fetch Series'. This will reset the dont.fetch and wrong.data markers and you should be able to get ep info using the query (manually) or by clicking 'Go' and processing all records...

[zehd]

I want to thank everyone for helping me troubleshoot the development of UltraXMLTV.

I'm closing this thread and opening a new support thread at

http://forums.nextpvr.com/showthread.php?t=33672

See you there!