[mythtv-users] Failed to get TV listings
Harondel J. Sibble
help at pdscc.com
Sun May 23 21:09:12 EDT 2004
On 22 May 2004 at 15:20, William Powers wrote:
> The duplicate entrys sorta sounds like what happens when you run
> tv_grab_na_dd without using the --old-chan-id option. Make sure you
> included all of the line continuation characters (' \ ') and that you
> didn't insert any extraneous lines between the lines that are spliced
> together. If you have any doubts, change the script to be one long,
> continuous command on a single line, like so:
I am having the same problem.....
I modified to script so the command string is on a single line.
I also have a problem where it complains about the timeoffset....
Fetching from DataDirect
Fetched 8850 k/bytes in 26 seconds
loading data: ##################################################
Writing schedule: ##################################################
Message: Your subscription will expire: 2004-08-23T22:44:19Z
Downloaded 19443 programs in 332 seconds
### bypassing grabbers, reading directly from file
Ignoring invalid TimeOffset (null)
> You can also manually run tv_grab_na_dd and mythfilldatabase separately
> from the command line using the same options get better insight into
> what is going on. That way you can also look directly at the xml file.
I'll try this next...
> one recording to the next. If you do think your database is borked,
> drop it and restore from the backup.
after this happened the first time, I dropped the db and restored from the
backup, made the command into a single line and tried again and had same
problem.
> ask them about it. I consider it suitable only for people who already know
> their way around shell scripting and perl and who, for whatever reason, are
> unable or unwilling to upgrade their systems at this time. Everyone else
I am unable to upgrade to 0.15 for a few weeks and my listings expire
tomorrow, so gotta get this working before the GF gets back from here trip
tomorrow :-(
DB Error (program insert):
Query was:
INSERT INTO program
(chanid,starttime,endtime,title,subtitle,description,category,category_type,ai
rdate,stars,previouslyshown)
VALUES(1003,"20040522230000","20040523010000","The Pink Panther","","Clumsy
Inspector Jacques Clouseau (Peter Sellers) chases a jewel thief (David Niven)
and his nephew (Robert Wagner).","Comedy","","1964","0.875","0");
Driver error was [2/-1]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '1003-20040522230000' for key 1
SNIP
DB Error (program insert):
Query was:
INSERT INTO program
(chanid,starttime,endtime,title,subtitle,description,category,category_type,ai
rdate,stars,previouslyshown)
VALUES(1009,"20040522233000","20040523000500","CTV News at
11:30","","","News","","0","0","0");
Driver error was [2/-1]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '1009-20040522233000' for key 1
Adjusting program database end times...
0 replacements made.
[sibbleh at marcus .mythtv]$
--
Harondel J. Sibble
Sibble Computer Consulting
Creating solutions for the small business and home computer user.
help at pdscc.com (use pgp keyid 0x3AD5C11D) http://www.pdscc.com
(604) 739-3709 (voice/fax) (604) 686-2253 (pager)
More information about the mythtv-users
mailing list