NextPVR Forums
  • ______
  • Home
  • New Posts
  • Wiki
  • Members
  • Help
  • Search
  • Register
  • Login
  • Home
  • Wiki
  • Members
  • Help
  • Search
NextPVR Forums Public Developers v
« Previous 1 … 34 35 36 37 38 … 93 Next »
New XMLTV Enhancer and more...

Thread Closed 
 
  • 0 Vote(s) - 0 Average
New XMLTV Enhancer and more...
tjb
Offline

Senior Member

Posts: 261
Threads: 43
Joined: Feb 2006
#381
2008-03-05, 02:26 PM
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
Offline

Posting Freak

Posts: 5,119
Threads: 249
Joined: Feb 2006
#382
2008-03-05, 04:39 PM (This post was last modified: 2008-03-05, 04:45 PM by zehd.)
Graham Wrote: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...
Frank Z
[COLOR="Gray"]
I used to ask 'why?' Now I just reinstall...
[SIZE="1"]______________________________________________
Author: ZTools: ZProcess, MVPServerChecker; UltraXMLTV Enhancer, Renamer, Manager; [/SIZE]
[/COLOR]
zehd
Offline

Posting Freak

Posts: 5,119
Threads: 249
Joined: Feb 2006
#383
2008-03-05, 05:08 PM
tjb Wrote: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.
Frank Z
[COLOR="Gray"]
I used to ask 'why?' Now I just reinstall...
[SIZE="1"]______________________________________________
Author: ZTools: ZProcess, MVPServerChecker; UltraXMLTV Enhancer, Renamer, Manager; [/SIZE]
[/COLOR]
Graham
Offline

Posting Freak

UK
Posts: 4,058
Threads: 102
Joined: Dec 2005
#384
2008-03-05, 05:47 PM
zehd Wrote: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
Offline

Posting Freak

Posts: 5,119
Threads: 249
Joined: Feb 2006
#385
2008-03-05, 05:57 PM
tjb Wrote: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
Frank Z
[COLOR="Gray"]
I used to ask 'why?' Now I just reinstall...
[SIZE="1"]______________________________________________
Author: ZTools: ZProcess, MVPServerChecker; UltraXMLTV Enhancer, Renamer, Manager; [/SIZE]
[/COLOR]
tjb
Offline

Senior Member

Posts: 261
Threads: 43
Joined: Feb 2006
#386
2008-03-05, 05:58 PM
zehd Wrote:I fixed the duration bug. .95 is on the wiki

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

Posting Freak

Posts: 5,119
Threads: 249
Joined: Feb 2006
#387
2008-03-05, 06:00 PM
Graham Wrote: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....
Frank Z
[COLOR="Gray"]
I used to ask 'why?' Now I just reinstall...
[SIZE="1"]______________________________________________
Author: ZTools: ZProcess, MVPServerChecker; UltraXMLTV Enhancer, Renamer, Manager; [/SIZE]
[/COLOR]
zehd
Offline

Posting Freak

Posts: 5,119
Threads: 249
Joined: Feb 2006
#388
2008-03-05, 06:14 PM
Graham Wrote: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...
Frank Z
[COLOR="Gray"]
I used to ask 'why?' Now I just reinstall...
[SIZE="1"]______________________________________________
Author: ZTools: ZProcess, MVPServerChecker; UltraXMLTV Enhancer, Renamer, Manager; [/SIZE]
[/COLOR]
zehd
Offline

Posting Freak

Posts: 5,119
Threads: 249
Joined: Feb 2006
#389
2008-03-05, 07:45 PM
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!
Frank Z
[COLOR="Gray"]
I used to ask 'why?' Now I just reinstall...
[SIZE="1"]______________________________________________
Author: ZTools: ZProcess, MVPServerChecker; UltraXMLTV Enhancer, Renamer, Manager; [/SIZE]
[/COLOR]
« Next Oldest | Next Newest »

Users browsing this thread: 5 Guest(s)

Pages (39): « Previous 1 … 35 36 37 38 39
Jump to page 


Possibly Related Threads…
Thread Author Replies Views Last Post
  How to extract M3U8 and get matching XMLTV guide data from NPVR almightyj 0 3,462 2018-10-23, 07:24 AM
Last Post: almightyj
  XMLTV Channel Number Option gdogg371 12 6,821 2018-07-18, 04:32 PM
Last Post: sub
  Merge xmltv data with xslt Graham 4 3,489 2014-01-02, 12:45 PM
Last Post: Graham
  XMLTV data mvallevand 6 2,645 2011-04-16, 03:08 AM
Last Post: sub
  Free XMLTV EPG scraper dneprrider 214 100,134 2010-03-29, 04:54 AM
Last Post: dljones8053
  XmlTv Structure psycik 2 2,220 2008-12-29, 10:53 PM
Last Post: psycik
  Content Provider: How to publish XMLTV data? skoka123 6 3,463 2008-09-03, 05:48 AM
Last Post: skoka123
  XMLTV Questions -Oz- 34 10,470 2008-03-24, 01:19 AM
Last Post: zehd
  I-xmltv updated for YahooXMLTv (adds a new show marker and more) Jim_ 78 24,930 2008-01-02, 10:33 AM
Last Post: tvshowman
  xmltv zap2it & msn scraper merge tvshowman 2 1,883 2007-12-12, 03:48 AM
Last Post: tvshowman

  • View a Printable Version
  • Subscribe to this thread
Forum Jump:

© Designed by D&D, modified by NextPVR - Powered by MyBB

Linear Mode
Threaded Mode