[mythtv-users] had a crash while editing and can't edit that file now

[Craig Longman]

Vinton Coffman wrote:

> I was editing a show previously recorded and my system locked up 
> hard.  No useful info in the log files.  Anyway, I can't edit this 
> file anymore. When I type "e" or "m" to enter edit mode nothing 
> happens.  It works fine in other files.  I guess the database for that 
> file is corrupt but I don't know how to fix this.  Suggestions please. 

take a look at the recorded table, ensure that the 'editing' field is 
zero.  for some stupid reason though, when you update any field in that 
table, the starttime field  will also be modified, so you will need to 
set that in the same sql statement, something like:

update recorded
set editing = 0, starttime = '20030508133000'
where chanid = 1037 and starttime = '20030508133000';

obviously, change the chanid and starttimes where applicable.

> By the way, is there anything I can do with the files once edited to 
> save space.  Is this used in transcoding?  Is anyone working on fixing 
> transcoding? 

i am updating transcoding to support removing the cut areas and 
re-encoding to a different format/bitrate.  its moving along, but i've 
still got work to do on handling raw copies (ie. not decoded then 
re-encoded).

cheers,

    CraigL->Thx();