[mythtv-users] Database Error from mythfilldatabase for DataDirect

[Russ W. Knize]

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
>