Project

General

Profile

Bug #30

Error while importing data for tv guide

Added by Anonymous almost 9 years ago. Updated almost 9 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
-
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
fixed

Description

I get this error ...
2010/02/21 23:04:08 [TVGuide] Identifier: Freebox TV
2010/02/21 23:04:08 [TVGuide] Parsing XML file ...
2010/02/21 23:04:08 [TVGuide] Processing XML file ... Channels so far: 10
2010/02/21 23:04:08 [TVGuide] Processing XML file ... Channels so far: 20
2010/02/21 23:04:08 [TVGuide] Processing XML file ... Channels so far: 30
2010/02/21 23:04:08 [TVGuide] Processing XML file ... Channels so far: 40
2010/02/21 23:04:08 [TVGuide] Error parsing XML file: 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 'Equipe TV' AND ChannelID = 'I60.751893.microsoft.com_ at line 1 at TVGuide.SaveChannelToDB.175
2010/02/21 23:04:08 [TVGuide] Summary:
2010/02/21 23:06:57 [TVGuide] Started grabbing XML with '/home/applications/domotiga/tvguide/mc2xml -f -c fr -g 25200 -D /home/applications/domotiga/tvguide/mc2xml.dat -o /home/applications/domotiga/tvguide/tvguide.xml'.
2010/02/21 23:07:07 [TVGuide] EPG - Valid from: 2010-02-21T00:00:00 UTC
2010/02/21 23:07:07 [TVGuide] EPG - Valid until: 2010-03-07T23:55:00 UTC
2010/02/21 23:07:07 [TVGuide] Identifier: neuf TV
2010/02/21 23:07:07 [TVGuide] Parsing XML file ...
2010/02/21 23:07:07 [TVGuide] Processing XML file ... Channels so far: 10
2010/02/21 23:07:07 [TVGuide] Processing XML file ... Channels so far: 20
2010/02/21 23:07:07 [TVGuide] Processing XML file ... Channels so far: 30
2010/02/21 23:07:07 [TVGuide] Error parsing XML file: 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 'Equipe TV' AND ChannelID = 'I50.751893.microsoft.com_ at line 1 at TVGuide.SaveChannelToDB.175
2010/02/21 23:07:07 [TVGuide] Summary:

(not with all identifier but at least with the one i would like to use with mc2xml)

History

#1 Updated by rdnzl almost 9 years ago

  • Status changed from New to Closed
  • Resolution set to fixed

I have fixed it, it was a problem with quoting the SQL query, it uses the safer method now.
Can you try revision 350? Thanks.

2010/02/22 08:45:34 [TVGuide] Started grabbing XML with '/home/ron/domotiga/tvguide/mc2xml -f -c fr -g 25200 -D /home/ron/domotiga/tvguide/mc2xml.dat -o /home/ron/domotiga/tvguide/tvguide.xml'.
2010/02/22 08:45:50 [TVGuide] EPG - Valid from: 2010-02-22T00:00:00 UTC
2010/02/22 08:45:50 [TVGuide] EPG - Valid until: 2010-03-08T23:55:00 UTC
2010/02/22 08:45:50 [TVGuide] Identifier: Freebox TV
2010/02/22 08:45:50 [TVGuide] Parsing XML file ...
2010/02/22 08:45:50 [TVGuide] Processing XML file ... Channels so far: 10
2010/02/22 08:45:50 [TVGuide] Processing XML file ... Channels so far: 20
2010/02/22 08:45:50 [TVGuide] Processing XML file ... Channels so far: 30
2010/02/22 08:45:50 [TVGuide] Processing XML file ... Channels so far: 40
2010/02/22 08:45:50 [TVGuide] Processing XML file ... Channels so far: 50
2010/02/22 08:45:50 [TVGuide] Processing XML file ... Channels so far: 60
2010/02/22 08:45:51 [TVGuide] Processing XML file ... Channels so far: 70
2010/02/22 08:45:51 [TVGuide] Processing XML file ... Channels so far: 80
2010/02/22 08:45:51 [TVGuide] Processing XML file ... Channels so far: 90
2010/02/22 08:45:51 [TVGuide] Processing XML file ... Channels so far: 100
2010/02/22 08:45:51 [TVGuide] Processing XML file ... Channels so far: 110
2010/02/22 08:45:51 [TVGuide] Processing XML file ... Channels so far: 120
2010/02/22 08:45:51 [TVGuide] Processing XML file ... Channels so far: 130
2010/02/22 08:45:51 [TVGuide] Processing XML file ... Channels so far: 140
2010/02/22 08:45:51 [TVGuide] Processing XML file ... Channels so far: 150
2010/02/22 08:45:51 [TVGuide] Processing XML file ... Channels so far: 160
2010/02/22 08:45:51 [TVGuide] Processing XML file ... Channels so far: 170
2010/02/22 08:45:51 [TVGuide] Processing XML file ... Channels so far: 180
2010/02/22 08:45:52 [TVGuide] Processing XML file ... Channels so far: 190
2010/02/22 08:45:52 [TVGuide] Processing XML file ... Programs so far: 1
2010/02/22 08:45:55 [TVGuide] Processing XML file ... Programs so far: 1000
2010/02/22 08:45:58 [TVGuide] Processing XML file ... Programs so far: 2000
2010/02/22 08:46:02 [TVGuide] Processing XML file ... Programs so far: 3000
2010/02/22 08:46:06 [TVGuide] Processing XML file ... Programs so far: 4000
2010/02/22 08:46:10 [TVGuide] Processing XML file ... Programs so far: 5000
2010/02/22 08:46:13 [TVGuide] Processing XML file ... Programs so far: 6000
2010/02/22 08:46:15 [TVGuide] Processing XML file ... Programs so far: 7000
2010/02/22 08:46:18 [TVGuide] Processing XML file ... Programs so far: 8000
2010/02/22 08:46:22 [TVGuide] Processing XML file ... Programs so far: 9000
2010/02/22 08:46:26 [TVGuide] Processing XML file ... Programs so far: 10000
2010/02/22 08:46:29 [TVGuide] Processing XML file ... Programs so far: 11000
2010/02/22 08:46:32 [TVGuide] Processing XML file ... Programs so far: 12000
2010/02/22 08:46:36 [TVGuide] Processing XML file ... Programs so far: 13000
2010/02/22 08:46:40 [TVGuide] Processing XML file ... Programs so far: 14000
2010/02/22 08:46:43 [TVGuide] Processing XML file ... Programs so far: 15000
2010/02/22 08:46:46 [TVGuide] Processing XML file ... Programs so far: 16000
2010/02/22 08:46:49 [TVGuide] Processing XML file ... Programs so far: 17000
2010/02/22 08:46:52 [TVGuide] Processing XML file ... Programs so far: 18000
2010/02/22 08:46:56 [TVGuide] Processing XML file ... Programs so far: 19000
2010/02/22 08:47:00 [TVGuide] Processing XML file ... Programs so far: 20000
2010/02/22 08:47:03 [TVGuide] Processing XML file ... Programs so far: 21000
2010/02/22 08:47:06 [TVGuide] Processing XML file ... Programs so far: 22000
2010/02/22 08:47:09 [TVGuide] Processing XML file ... Programs so far: 23000
2010/02/22 08:47:13 [TVGuide] Processing XML file ... Programs so far: 24000
2010/02/22 08:47:17 [TVGuide] Processing XML file ... Programs so far: 25000
2010/02/22 08:47:20 [TVGuide] Processing XML file ... Programs so far: 26000
2010/02/22 08:47:24 [TVGuide] Processing XML file ... Programs so far: 27000
2010/02/22 08:47:28 [TVGuide] Processing XML file ... Programs so far: 28000
2010/02/22 08:47:31 [TVGuide] Processing XML file ... Programs so far: 29000
2010/02/22 08:47:33 [TVGuide] Processing XML file ... Programs so far: 30000
2010/02/22 08:47:36 [TVGuide] Processing XML file ... Programs so far: 31000
2010/02/22 08:47:39 [TVGuide] Processing XML file ... Programs so far: 32000
2010/02/22 08:47:42 [TVGuide] Processing XML file ... Programs so far: 33000
2010/02/22 08:47:45 [TVGuide] Processing XML file ... Programs so far: 34000
2010/02/22 08:47:48 [TVGuide] Processing XML file ... Programs so far: 35000
2010/02/22 08:47:52 [TVGuide] Processing XML file ... Programs so far: 36000
2010/02/22 08:47:55 [TVGuide] Processing XML file ... Programs so far: 37000
2010/02/22 08:47:58 [TVGuide] Processing XML file ... Programs so far: 38000
2010/02/22 08:48:01 [TVGuide] Processing XML file ... Programs so far: 39000
2010/02/22 08:48:04 [TVGuide] Processing XML file ... Programs so far: 40000
2010/02/22 08:48:08 [TVGuide] Processing XML file ... Programs so far: 41000
2010/02/22 08:48:12 [TVGuide] Processing XML file ... Programs so far: 42000
2010/02/22 08:48:13 [TVGuide] Processing Categories ...
2010/02/22 08:48:13 [TVGuide] Summary: Finished. 198 Channels, 41 Main Categories and 42310 Programs processed !

#2 Updated by Anonymous almost 9 years ago

Works fine for me now (for "freebox TV" and "neuf TV" guides for example).

Also available in: Atom PDF