[mythtv-users] mythfilldatabase error -- Can't open
file: 'credits.MYD'. (errno:145)
Bruce Markey
bjm at lvcm.com
Mon May 31 13:48:59 EDT 2004
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
More information about the mythtv-users
mailing list