[mythtv-users] Database Error from mythfilldatabase for DataDirect

[Chris Strom]

It's in the mysql source.  Looks like it's in the scripts directory:

http://dev.mysql.com/doc/mysql/en/Upgrading-grant-tables.html


On Tue, Jun 01, 2004 at 03:42:07PM -0500, Russ W. Knize wrote:
> 
> Thanks for the tip.  I'm not seeing this script or anything like it in the
> sources for 0.14 or 0.15.  I looked at the scripts in contrib, but didn't
> see anything promising....
> 
> Thanks,
> Russ
> 
> Chris Strom said:
> > You need to run the mysql_fix_privilege_tables script (available in the
> MySQL contrib directory, IIRC).  That allows you to create temporary
> tables as a non-admin user.
> >
> > Chris
> >
> >
> > On Tue, Jun 01, 2004 at 10:48:09AM -0500, Russ W. Knize wrote:
> >> I am trying to migrate to DataDirect from 0.14.  I followed all the
> procedures in the HOW-TO, (added channel_copy table, setup the sources,
> etc).  When I run mythfilldatabase, it downloads the data just fine but
> when it tries to populate the DB, I get hundreds of errors like this:
> >>
> >> DB Error (Inserting into dd_schedule):
> >> Query was:
> >> INSERT INTO dd_schedule
> >> (programid,stationid,scheduletime,duration,repeat,stereo,subtitled,hdtv,closecaptioned,tvrating,partnumber,parttotal,endtime)
> VALUES(:PROGRAMID,:STATIONID,:TIME,:DURATION,:REPEAT,:STEREO,:SUBTITLED,:HDTV,:CLOSECAPTIONED,:TVRATING,:PARTNUMBER,:PARTTOTAL,:ENDTIME);
> Driver error was [2/1146]:
> >> QMYSQL3: Unable to execute query
> >> Database error was:
> >> Table 'mythconverg.dd_schedule' doesn't exist
> >>
> >> Obviously, something is missing in the DB.  What step did I miss?
> >>
> >> Thanks,
> >> Russ W. Knize
> >>
> >> _______________________________________________
> >> mythtv-users mailing list
> >> mythtv-users at mythtv.org
> >> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> >>
> >>
> >>
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users at mythtv.org
> > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> >
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> 
> 
>