XMLTV import failure (1 Viewer)

[HanuIv]

Every time I try to import XMLTV file to tvengine3-06-22-2007--01-22h--Rev14957 (XMLTV plugin) and later I get following error in the log:

A XML tv import error loading C:\\tvguide.xml err:insert into Program ( idChannel, startTime, endTime, title, description, genre, notify, originalAirDate, seriesNum, episodeNum, starRating, classification ) values ( ?idChannel, ?startTime, ?endTime, ?title, ?description, ?genre, ?notify, ?originalAirDate, ?seriesNum, ?episodeNum, ?starRating, ?classification ); select LAST_INSERT_ID();

tvguide.xml file is generated in UTF8 by TVxb and it seems to me valid (I can provide sample upon request).

Has someone the same experience? Mayby I am blind and I do something bad. Can someone help... or kick me right direction?

Thank you!

 

[Laban]

I have the exact same problem.

2007-07-01 10:24:58 10 XML tv import error loading D:\xmltv\tvguide.xml err:insert into Program ( idChannel, startTime, endTime, title, description, genre, notify, originalAirDate, seriesNum, episodeNum, starRating, classification ) values ( ?idChannel, ?startTime, ?endTime, ?title, ?description, ?genre, ?notify, ?originalAirDate, ?seriesNum, ?episodeNum, ?starRating, ?classification ); select LAST_INSERT_ID();

sample from the tvguide.xml

<programme start="20070701092000 +0200" stop="20070701105000 +0200" channel="action.tv1000.viasat.se">
<title lang="sv">Border Patrol</title>
<desc lang="sv">'Gränspatrullen' har inga juridiskt bestämda geografiska gränser. Dess uppgift är att patrullera gränsen mellan den levande världen och "de dödas värld". Den håller koll på de bråkmakare som dött, men fortfarande försöker förstöra den lekamliga världen.</desc>
<credits>
<director>Mark Haber</director>
<actor>Michael DeLorenzo</actor>
<actor>Clayton Rohner</actor>
<actor>Kenneth Ransom</actor>
<actor>Mary Elkins</actor>
<actor>Lewis Fitz-Gerald</actor>
</credits>
<date>2000</date>
<category lang="en">movie</category>
<category lang="en">Movies</category>
</programme>

I'm using mysql 5.1. I tried to do a manual insert using the above sql statement (with some minor tweaking ) and worked just fine:

mysql> use tvlibrary
Database changed
mysql> insert into Program ( idChannel, startTime, endTime, title, description,
genre, notify, originalAirDate, seriesNum, episodeNum, starRating, classificatio
n )
-> values ( 2,20070701092000, 20070701105000,'Border Patrol','Granspatru
llen...','movie',0,20000101000000, '', '',-1,''); select LAST_INSERT_ID();
Query OK, 1 row affected (0.00 sec)

+------------------+
| LAST_INSERT_ID() |
+------------------+
| 26757 |
+------------------+
1 row in set (0.00 sec)

Might add that i'm using the tv_grab_se_swedb grabber.

 

[HanuIv]

I think we should report this as a bug.

 

[Laban]

I changed the encoding to 'UTF-8' and removed all åäö characters in the tvguide.xml and now it works just fine. So perhaps it's the charset that i set in the mysql installation that's causing the problem.

 

[Laban]

Yep, i had UTF-8 as the default charset in mysql, should of course have been Latin1 since the tvguide.xml is written in ISO-8859-1. Works fine now..