[mythtv-users] mythfilldatabase error -- Can't open file: 'credits.MYD'. (errno:145)

Gerald Schepens schepens at shaw.ca
Mon May 31 20:10:53 EDT 2004


That cleared it right up.  Thanks!

Bruce Markey wrote:

> Gerald Schepens wrote:
>
>> Mythfilldatabase produces an error, which it didn't have before.  
>> It's run post-0.15 release already withouth any trouble.  Anyway, the 
>> output below shows the error is something to do with a credits table 
>> insert that didn't work.
>>
>> Main temp tables populated.  Updating myth channels...
>> Channels updated..  Updating programs...
>> DB Error (Inserting into credits table):
>> Query was:
>> INSERT IGNORE INTO credits (chanid, starttime, person, role) SELECT 
>> chanid, starttime, person, role FROM dd_productioncrew, dd_v_program, 
>> people WHERE ((dd_productioncrew.programid = dd_v_program.programid) 
>> AND (dd_productioncrew.fullname = people.name));
>> Driver error was [2/1016]:
>> QMYSQL3: Unable to execute query
>> Database error was:
>> Can't open file: 'credits.MYD'. (errno: 145)
>>
>> If I try to query the credits table using mysql directly, I get the 
>> same error:  "Can't open file 'credits.MYD'. (errno: 145)".  
>> Something on my system's gotten messed up, obviously.  What's the fix?
>
>
>
> mysqlcheck -r -u mythtv -pmythtv mythconverg
>
> --  bjm
>
>------------------------------------------------------------------------
>
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>  
>



More information about the mythtv-users mailing list