[mythtv-users] Failed to get TV listings

[Erik Karlin]

I get exactly the same errors with the programrating table, duplicate
key errors. I'm not going to bother looking at it on the assumption that
it's this or nothing for a few more days or so. It definately looks like
I do have 10 days of program data.

Of course this is just a temporary fix, but since I'm still running
debian unstable myth .debs, I expect not to have too many problems
upgrading to .15 when it's out.

At some point I'll have to work out how to switch from .debs to CVS
witout losing anything.

On Sat, May 22, 2004 at 11:12:48AM -0500, Jim Bauer wrote:
> 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
> >
> 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users