[mythtv-users] Database Error from mythfilldatabase for DataDirect

[Russ W. Knize]

Thank you.  I did find the script, but it didn't seem to help.  I did
reset the permissions on the grant tables for mythconverg and now it is
happy.  Thanks for the tip though.

MythTV rocks.  I have been using it on and off for a couple of years. 
Awesome work, everyone.  It is one of the few geeky things I've setup in
our house that gets the full thumbs-up from the wife.  ;)

Chris Strom said:
> 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
>>
>>
>>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>


Thanks,
Russ