[mythtv-users] Failed to get TV listings

[Jim Bauer]

On Saturday 22 May 2004 01:07, William Powers wrote:
>
> For anyone who prefers Option 3 over Option 2 until 0.15 is released,
> the attached procedure worked for me; I have been using tv_grab_na_dd
> for a couple of weeks now.  The script attached at bottom only supports
> a single zap2it lineup, but if you need multiple lineups, a suitable
> script was posted earlier on this list.  Search for 'mtdean'.

I tried this but it doesn't look like it worked.  I got several errors when I 
ran the script.  Here are just a couple.

DB Error (program insert):
Query was:
INSERT INTO program 
(chanid,starttime,endtime,title,subtitle,description,category,category_type,airdate,stars,previouslyshown) 
VALUES(1075,"20040521230000","20040522010000","Babylon 5: The Legend of the 
Rangers","","In 2264 a military group consisting of humans and aliens tries 
to enforce intergalactic peace.","Science fiction","","2002","0.625","0");
Driver error was [2/-1]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '1075-20040521230000' for key 1

DB Error (programrating insert):
Query was:
INSERT INTO programrating (chanid,starttime,system,rating) VALUES (1075, 
"20040521230000", "MPAA", "NR");
Driver error was [2/-1]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '1075-20040521230000-MPAA-NR' for key 1

and at the end I get...

Adjusting program database end times...
0 replacements made.

When I look at the mythtv status page it says....

"Last mythfilldatabase run started on 2004-05-21 06:26 and ended on 2004-05-21 
06:27. mythfilldatabase ran, but did not insert any new data into the Guide. 
This can indicate a potential xmltv failure.
There's guide data until 2004-06-01 06:00 (10 days). 

I ran the /usr/local/bin/mythfilldatabasecron_dd script at
about 2004-05-22 1145


> 8)  Determine your sourceid.  The easiest way is to use "phpmyadmin" if
>      you already have it installed, but this way is pretty easy too:
>
>      # mysql -u mythtv -pmythtv mythconverg

BTW, this didn't work for me, but "mysql -u root mythconverg" did.

>      mysql> select * from videosource;
>
>      Record your sourceid.
>
>      mysql> quit
>