Just updating my own post of yesterday. It appears that RT is updating the
listings data, but there is a problem with the grabber. Something is
happening to the values that are to be inserted into the DB. Here is some
error text from tv_grab_uk_rt:
DB Error (program insert):
Query was:
INSERT INTO program
(chanid,starttime,endtime,title,title_pronounce,subtitle,description,categor
y,category_type,airdate,stars,previouslyshown)
VALUES(:CHANID,:STARTTIME,:ENDTIME,:TITLE,:TITLE_PRONOUNCE,:SUBTITLE,:DESCRI
PTION,:CATEGORY,:CATEGORY_TYPE,:AIRDATE,:STARS,:PREVIOUSLYSHOWN);
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '2-2004-10-07 20:00:00' for key 1
DB Error (program insert):
Query was:
INSERT INTO program
(chanid,starttime,endtime,title,title_pronounce,subtitle,description,categor
y,category_type,airdate,stars,previouslyshown)
VALUES(:CHANID,:STARTTIME,:ENDTIME,:TITLE,:TITLE_PRONOUNCE,:SUBTITLE,:DESCRI
PTION,:CATEGORY,:CATEGORY_TYPE,:AIRDATE,:STARS,:PREVIOUSLYSHOWN);
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '2-2004-10-07 21:00:00' for key 1
DB Error (program insert):
Query was:
INSERT INTO program
(chanid,starttime,endtime,title,title_pronounce,subtitle,description,categor
y,category_type,airdate,stars,previouslyshown)
VALUES(:CHANID,:STARTTIME,:ENDTIME,:TITLE,:TITLE_PRONOUNCE,:SUBTITLE,:DESCRI
PTION,:CATEGORY,:CATEGORY_TYPE,:AIRDATE,:STARS,:PREVIOUSLYSHOWN);
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '2-2004-10-07 21:50:00' for key 1
DB Error (program insert):
Query was:
INSERT INTO program
(chanid,starttime,endtime,title,title_pronounce,subtitle,description,categor
y,category_type,airdate,stars,previouslyshown)
VALUES(:CHANID,:STARTTIME,:ENDTIME,:TITLE,:TITLE_PRONOUNCE,:SUBTITLE,:DESCRI
PTION,:CATEGORY,:CATEGORY_TYPE,:AIRDATE,:STARS,:PREVIOUSLYSHOWN);
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '2-2004-10-07 22:30:00' for key 1
DB Error (program insert):
Query was:
INSERT INTO program
(chanid,starttime,endtime,title,title_pronounce,subtitle,description,categor
y,category_type,airdate,stars,previouslyshown)
VALUES(:CHANID,:STARTTIME,:ENDTIME,:TITLE,:TITLE_PRONOUNCE,:SUBTITLE,:DESCRI
PTION,:CATEGORY,:CATEGORY_TYPE,:AIRDATE,:STARS,:PREVIOUSLYSHOWN);
Driver error was [2/1048]:
QMYSQL3: Unable to execute query
Database error was:
Column 'endtime' cannot be null
Adjusting program database end times...
0 replacements made.
2004-09-27 18:42:19 mythfilldatabase: Listings Download Finished
Seems that the values aren't being substituted into the INSERT statement
anymore. This was working 3 or 4 days ago, nothing has changed at my end.
Any ideas?
Thanks,
Andrew
-------------------------------------------------------
This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
Project Admins to receive an Apple iPod Mini FREE for your judgement on
who ports your project to Linux PPC the best. Sponsored by IBM.
Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
|
