[mythtv-users] Failed to get TV listings

[Harondel J. Sibble]

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)