> > I just updated to MySQL 5 (accidently, almost :-)). Mythfilldatabase now > > fails, and I tracked it down to this: > > > > CREATE TEMPORARY TABLE IF NOT EXISTS dd_schedule ( programid char(12), > > stationid char(12), scheduletime datetime, duration time, repeat bool, > > stereo bool, subtitled bool, hdtv bool, closecaptioned BOOL, tvrating > > char(5), partnumber int, parttotal int, endtime datetime, INDEX progidx > > (programid) ); > > > > The problem is that "repeat" is a reserved keyword by MySQL. I can get > > around it by quoting it as `repeat`, but not quite sure how to go about > > getting the changes into the executable. I run gentoo, and I guess I could > > compile that program by itself. > > > > Any ideas? My guide is empty and I can't record! :-( > > Hmm, > I am using 5.0.15 and have been for a week or so and here everything works???
Did some investigation on this and found that this field is called "isrepeat" in SVN, which I am using. 0.18.1 still has the "bool repeat" in there. So the answer is: upgrade to SVN. (But grab a version where LiveTV works ;-) ) Dag
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
