Reply to thread

Message

<blockquote data-quote="Laban" data-source="post: 160415" data-attributes="member: 53075">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&nbsp; &lt;programme start=&quot;20070701092000 +0200&quot; stop=&quot;20070701105000 +0200&quot; channel=&quot;action.tv1000.viasat.se&quot;&gt;&nbsp; &nbsp; &lt;title lang=&quot;sv&quot;&gt;Border Patrol&lt;/title&gt;&nbsp; &nbsp; &lt;desc lang=&quot;sv&quot;&gt;'Gränspatrullen' har inga juridiskt bestämda geografiska gränser. Dess uppgift är att patrullera gränsen mellan den levande världen och &quot;de dödas värld&quot;. Den håller koll på de bråkmakare som dött, men fortfarande försöker förstöra den lekamliga världen.&lt;/desc&gt;&nbsp; &nbsp; &lt;credits&gt;&nbsp; &nbsp; &nbsp; &lt;director&gt;Mark Haber&lt;/director&gt;&nbsp; &nbsp; &nbsp; &lt;actor&gt;Michael DeLorenzo&lt;/actor&gt;&nbsp; &nbsp; &nbsp; &lt;actor&gt;Clayton Rohner&lt;/actor&gt;&nbsp; &nbsp; &nbsp; &lt;actor&gt;Kenneth Ransom&lt;/actor&gt;&nbsp; &nbsp; &nbsp; &lt;actor&gt;Mary Elkins&lt;/actor&gt;&nbsp; &nbsp; &nbsp; &lt;actor&gt;Lewis Fitz-Gerald&lt;/actor&gt;&nbsp; &nbsp; &lt;/credits&gt;&nbsp; &nbsp; &lt;date&gt;2000&lt;/date&gt;&nbsp; &nbsp; &lt;category lang=&quot;en&quot;&gt;movie&lt;/category&gt;&nbsp; &nbsp; &lt;category lang=&quot;en&quot;&gt;Movies&lt;/category&gt;&nbsp; &lt;/programme&gt;I'm using mysql 5.1. I tried to do a manual insert using the above sql statement (with some minor tweaking <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" />) and worked just fine:mysql&gt; use tvlibraryDatabase changedmysql&gt; insert into Program ( idChannel, startTime, endTime, title, description,genre, notify, originalAirDate, seriesNum, episodeNum, starRating, classification )&nbsp; &nbsp; -&gt;&nbsp; &nbsp;&nbsp; values ( 2,20070701092000, 20070701105000,'Border Patrol','Granspatrullen...','movie',0,20000101000000, '', '',-1,''); select LAST_INSERT_ID();Query OK, 1 row affected (0.00 sec)+------------------+| LAST_INSERT_ID() |+------------------+|&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 26757 |+------------------+1 row in set (0.00 sec)Might add that i'm using the tv_grab_se_swedb grabber.</blockquote>

[QUOTE="Laban, post: 160415, member: 53075"] 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. [/QUOTE]

Verification