Reply to thread

Message

<blockquote data-quote="David Scott" data-source="post: 1229084" data-attributes="member: 123155">Hey, spent a few hours scratching head and trawling the forums here, and none of the suggestions so far have helped. I've already checked the database for errors using the sql command listed in another post - no errors, tried clearing out all rows from the program tablere-checked that my mappings are configured correctlybut I get these message in my logs - and TV server config xmltv import just shows&nbsp; 'already importing'Any suggestions, I'm trying to avoid a clean reinstall - about yearly I've had to do that for one reason or another, it's annoying [2017-09-04 15:53:08,935] [Log&nbsp; &nbsp; ] [SetupTv&nbsp; ] [ERROR] - plugin:xmltv import failed[2017-09-04 15:53:08,947] [Log&nbsp; &nbsp; ] [SetupTv&nbsp; ] [ERROR] - Exception&nbsp;&nbsp; <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite5" alt=":confused:" title="Confused&nbsp; &nbsp; :confused:" loading="lazy" data-shortname=":confused:" />ystem.FormatException: Input string was not in a correct format.&nbsp;&nbsp; at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer&amp; number, NumberFormatInfo info, Boolean parseDecimal)&nbsp;&nbsp; at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)&nbsp;&nbsp; at System.Int32.Parse(String s)&nbsp;&nbsp; at TvEngine.XMLTVImport.Import(String fileName, Boolean deleteBeforeImport, Boolean showProgress)&nbsp;&nbsp; at TvEngine.XmlTvImporter.ThreadFunctionImportTVGuide(Object aparam)and my tvguide.xml looks like this (abridged)[CODE=XML]&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;&lt;tv generator-info-name=&quot;DomainObjects/4.3.5838.20264&quot;&gt;&nbsp; &lt;channel id=&quot;1502&quot;&gt;&nbsp; &nbsp; &lt;display-name&gt;Al Jazeera&lt;/display-name&gt;&nbsp; &lt;/channel&gt;&nbsp; &lt;channel id=&quot;1501&quot;&gt;&nbsp; &nbsp; &lt;display-name&gt;Apna Television&lt;/display-name&gt;&nbsp; &lt;/channel&gt;&nbsp; &lt;channel id=&quot;2002&quot;&gt;&nbsp; &nbsp; &lt;display-name&gt;BaseFM&lt;/display-name&gt;&nbsp; &lt;/channel&gt;&nbsp; &lt;channel id=&quot;1307&quot;&gt;&nbsp; &nbsp; &lt;display-name&gt;Bravo&lt;/display-name&gt;&nbsp; &lt;/channel&gt;&nbsp; &lt;channel id=&quot;1308&quot;&gt;&nbsp; &nbsp; &lt;display-name&gt;Bravo PLUS 1&lt;/display-name&gt;&nbsp; &lt;/channel&gt;&nbsp; &lt;channel id=&quot;1412&quot;&gt;&nbsp; &nbsp; &lt;display-name&gt;Channel North&lt;/display-name&gt;&nbsp; &lt;/channel&gt;&nbsp; &lt;channel id=&quot;1403&quot;&gt;&nbsp; &nbsp; &lt;display-name&gt;ChineseTV&lt;/display-name&gt;&nbsp; &lt;/channel&gt;&nbsp; &lt;channel id=&quot;1407&quot;&gt;&nbsp; &nbsp; &lt;display-name&gt;ChoiceTV&lt;/display-name&gt;&nbsp; &lt;/channel&gt;&nbsp; &lt;channel id=&quot;1414&quot;&gt;&nbsp; &nbsp; &lt;display-name&gt;Firstlight&lt;/display-name&gt;&nbsp; &lt;/channel&gt;&nbsp; &lt;channel id=&quot;1508&quot;&gt;&nbsp; &nbsp; &lt;display-name&gt;HGTV&lt;/display-name&gt;&nbsp; &lt;/channel&gt;&nbsp; &lt;channel id=&quot;1506&quot;&gt;&nbsp; &nbsp; &lt;display-name&gt;Hope Channel&lt;/display-name&gt;&nbsp; &lt;/channel&gt;&nbsp; &lt;channel id=&quot;1411&quot;&gt;&nbsp; &nbsp; &lt;display-name&gt;Info-Rotorua&lt;/display-name&gt;&nbsp; &lt;/channel&gt;&nbsp; &lt;channel id=&quot;1600&quot;&gt;&nbsp; &nbsp; &lt;display-name&gt;Maori Television&lt;/display-name&gt;&nbsp; &lt;/channel&gt;&nbsp; &lt;channel id=&quot;1509&quot;&gt;&nbsp; &nbsp; &lt;display-name&gt;NCTV-Chinese&lt;/display-name&gt;&nbsp; &lt;/channel&gt;&nbsp; &lt;channel id=&quot;1421&quot;&gt;&nbsp; &nbsp; &lt;display-name&gt;PandaTV&lt;/display-name&gt;&nbsp; &lt;/channel&gt;&nbsp; &lt;channel id=&quot;1401&quot;&gt;&nbsp; &nbsp; &lt;display-name&gt;Parliament&lt;/display-name&gt;&nbsp; &lt;/channel&gt;&nbsp; &lt;channel id=&quot;1404&quot;&gt;&nbsp; &nbsp; &lt;display-name&gt;PRIME&lt;/display-name&gt;&nbsp; &lt;/channel&gt;&nbsp; &lt;channel id=&quot;2001&quot;&gt;&nbsp; &nbsp; &lt;display-name&gt;Radio NZ Concert&lt;/display-name&gt;&nbsp; &lt;/channel&gt;&nbsp; &lt;channel id=&quot;1507&quot;&gt;&nbsp; &nbsp; &lt;display-name&gt;Radio NZ National&lt;/display-name&gt;&nbsp; &lt;/channel&gt;&nbsp; &lt;channel id=&quot;6002&quot;&gt;&nbsp; &nbsp; &lt;display-name&gt;Shine TV&lt;/display-name&gt;&nbsp; &lt;/channel&gt;&nbsp; &lt;channel id=&quot;1417&quot;&gt;&nbsp; &nbsp; &lt;display-name&gt;SouthernTV&lt;/display-name&gt;&nbsp; &lt;/channel&gt;&nbsp; &lt;channel id=&quot;1601&quot;&gt;&nbsp; &nbsp; &lt;display-name&gt;Te Reo&lt;/display-name&gt;&nbsp; &lt;/channel&gt;&nbsp; &lt;channel id=&quot;6001&quot;&gt;&nbsp; &nbsp; &lt;display-name&gt;Television Hawke's Bay&lt;/display-name&gt;&nbsp; &lt;/channel&gt;&nbsp; &lt;channel id=&quot;1305&quot;&gt;&nbsp; &nbsp; &lt;display-name&gt;The Edge TV&lt;/display-name&gt;&nbsp; &lt;/channel&gt;&nbsp; &lt;channel id=&quot;1300&quot;&gt;&nbsp; &nbsp; &lt;display-name&gt;Three&lt;/display-name&gt;&nbsp; &lt;/channel&gt;&nbsp; &lt;channel id=&quot;1302&quot;&gt;&nbsp; &nbsp; &lt;display-name&gt;ThreePlus1&lt;/display-name&gt;&nbsp; &lt;/channel&gt;&nbsp; &lt;channel id=&quot;1505&quot;&gt;&nbsp; &nbsp; &lt;display-name&gt;TV29&lt;/display-name&gt;&nbsp; &lt;/channel&gt;&nbsp; &lt;channel id=&quot;1405&quot;&gt;&nbsp; &nbsp; &lt;display-name&gt;TV33&lt;/display-name&gt;&nbsp; &lt;/channel&gt;&nbsp; &lt;channel id=&quot;1200&quot;&gt;&nbsp; &nbsp; &lt;display-name&gt;TVNZ 1&lt;/display-name&gt;&nbsp; &lt;/channel&gt;&nbsp; &lt;channel id=&quot;1206&quot;&gt;&nbsp; &nbsp; &lt;display-name&gt;TVNZ 1 +1&lt;/display-name&gt;&nbsp; &lt;/channel&gt;&nbsp; &lt;channel id=&quot;1201&quot;&gt;&nbsp; &nbsp; &lt;display-name&gt;TVNZ 2&lt;/display-name&gt;&nbsp; &lt;/channel&gt;&nbsp; &lt;channel id=&quot;1207&quot;&gt;&nbsp; &nbsp; &lt;display-name&gt;TVNZ 2 +1&lt;/display-name&gt;&nbsp; &lt;/channel&gt;&nbsp; &lt;channel id=&quot;1205&quot;&gt;&nbsp; &nbsp; &lt;display-name&gt;TVNZ DUKE&lt;/display-name&gt;&nbsp; &lt;/channel&gt;&nbsp; &lt;channel id=&quot;1504&quot;&gt;&nbsp; &nbsp; &lt;display-name&gt;TVSN Shopping&lt;/display-name&gt;&nbsp; &lt;/channel&gt;&nbsp; &lt;channel id=&quot;1423&quot;&gt;&nbsp; &nbsp; &lt;display-name&gt;WairarapaTV&lt;/display-name&gt;&nbsp; &lt;/channel&gt;&nbsp; &lt;programme start=&quot;20170904000000 +1200&quot; stop=&quot;20170904010000 +1200&quot; channel=&quot;1502&quot;&gt;&nbsp; &nbsp; &lt;title&gt;Al Jazeera World&lt;/title&gt;&nbsp; &nbsp; &lt;desc&gt;The story of the Rwandan Genocide in 1994 when 800,000 people were killed by Hutu extremists, the major role played by the media and the road to reconciliation.&lt;/desc&gt;&nbsp; &lt;/programme&gt;&nbsp; &lt;programme start=&quot;20170904010000 +1200&quot; stop=&quot;20170904020000 +1200&quot; channel=&quot;1502&quot;&gt;&nbsp; &nbsp; &lt;title&gt;Newshour&lt;/title&gt;&nbsp; &nbsp; &lt;desc&gt;In-depth global news is presented.&lt;/desc&gt;&nbsp; &lt;/programme&gt;&nbsp; &lt;programme start=&quot;20170904020000 +1200&quot; stop=&quot;20170904023000 +1200&quot; channel=&quot;1502&quot;&gt;&nbsp; &nbsp; &lt;title&gt;News Live&lt;/title&gt;&nbsp; &nbsp; &lt;desc&gt;Get the latest news every evening about what is happening around the globe.&lt;/desc&gt;&nbsp; &lt;/programme&gt;&nbsp; &lt;programme start=&quot;20170904023000 +1200&quot; stop=&quot;20170904030000 +1200&quot; channel=&quot;1502&quot;&gt;&nbsp; &nbsp; &lt;title&gt;Listening Post&lt;/title&gt;&nbsp; &nbsp; &lt;desc&gt;This week, we analyse how Indian media cover the so-called 'godmen' in the country. And we look at Mugabe and the Zimbabwean media.&lt;/desc&gt;&nbsp; &lt;/programme&gt;[/CODE]</blockquote>

[QUOTE="David Scott, post: 1229084, member: 123155"] Hey, spent a few hours scratching head and trawling the forums here, and none of the suggestions so far have helped. I've already checked the database for errors using the sql command listed in another post - no errors, tried clearing out all rows from the program table re-checked that my mappings are configured correctly but I get these message in my logs - and TV server config xmltv import just shows 'already importing' Any suggestions, I'm trying to avoid a clean reinstall - about yearly I've had to do that for one reason or another, it's annoying [FONT=Courier New][2017-09-04 15:53:08,935] [Log ] [SetupTv ] [ERROR] - plugin:xmltv import failed [2017-09-04 15:53:08,947] [Log ] [SetupTv ] [ERROR] - Exception :System.FormatException: Input string was not in a correct format. at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) at System.Int32.Parse(String s) at TvEngine.XMLTVImport.Import(String fileName, Boolean deleteBeforeImport, Boolean showProgress) at TvEngine.XmlTvImporter.ThreadFunctionImportTVGuide(Object aparam)[/FONT] and my tvguide.xml looks like this (abridged) [CODE=XML]<?xml version="1.0" encoding="utf-8"?> <tv generator-info-name="DomainObjects/4.3.5838.20264"> <channel id="1502"> <display-name>Al Jazeera</display-name> </channel> <channel id="1501"> <display-name>Apna Television</display-name> </channel> <channel id="2002"> <display-name>BaseFM</display-name> </channel> <channel id="1307"> <display-name>Bravo</display-name> </channel> <channel id="1308"> <display-name>Bravo PLUS 1</display-name> </channel> <channel id="1412"> <display-name>Channel North</display-name> </channel> <channel id="1403"> <display-name>ChineseTV</display-name> </channel> <channel id="1407"> <display-name>ChoiceTV</display-name> </channel> <channel id="1414"> <display-name>Firstlight</display-name> </channel> <channel id="1508"> <display-name>HGTV</display-name> </channel> <channel id="1506"> <display-name>Hope Channel</display-name> </channel> <channel id="1411"> <display-name>Info-Rotorua</display-name> </channel> <channel id="1600"> <display-name>Maori Television</display-name> </channel> <channel id="1509"> <display-name>NCTV-Chinese</display-name> </channel> <channel id="1421"> <display-name>PandaTV</display-name> </channel> <channel id="1401"> <display-name>Parliament</display-name> </channel> <channel id="1404"> <display-name>PRIME</display-name> </channel> <channel id="2001"> <display-name>Radio NZ Concert</display-name> </channel> <channel id="1507"> <display-name>Radio NZ National</display-name> </channel> <channel id="6002"> <display-name>Shine TV</display-name> </channel> <channel id="1417"> <display-name>SouthernTV</display-name> </channel> <channel id="1601"> <display-name>Te Reo</display-name> </channel> <channel id="6001"> <display-name>Television Hawke's Bay</display-name> </channel> <channel id="1305"> <display-name>The Edge TV</display-name> </channel> <channel id="1300"> <display-name>Three</display-name> </channel> <channel id="1302"> <display-name>ThreePlus1</display-name> </channel> <channel id="1505"> <display-name>TV29</display-name> </channel> <channel id="1405"> <display-name>TV33</display-name> </channel> <channel id="1200"> <display-name>TVNZ 1</display-name> </channel> <channel id="1206"> <display-name>TVNZ 1 +1</display-name> </channel> <channel id="1201"> <display-name>TVNZ 2</display-name> </channel> <channel id="1207"> <display-name>TVNZ 2 +1</display-name> </channel> <channel id="1205"> <display-name>TVNZ DUKE</display-name> </channel> <channel id="1504"> <display-name>TVSN Shopping</display-name> </channel> <channel id="1423"> <display-name>WairarapaTV</display-name> </channel> <programme start="20170904000000 +1200" stop="20170904010000 +1200" channel="1502"> <title>Al Jazeera World</title> <desc>The story of the Rwandan Genocide in 1994 when 800,000 people were killed by Hutu extremists, the major role played by the media and the road to reconciliation.</desc> </programme> <programme start="20170904010000 +1200" stop="20170904020000 +1200" channel="1502"> <title>Newshour</title> <desc>In-depth global news is presented.</desc> </programme> <programme start="20170904020000 +1200" stop="20170904023000 +1200" channel="1502"> <title>News Live</title> <desc>Get the latest news every evening about what is happening around the globe.</desc> </programme> <programme start="20170904023000 +1200" stop="20170904030000 +1200" channel="1502"> <title>Listening Post</title> <desc>This week, we analyse how Indian media cover the so-called 'godmen' in the country. And we look at Mugabe and the Zimbabwean media.</desc> </programme>[/CODE] [/QUOTE]

Verification