[mythtv-users] Which tables to alter to remove deadlock?

[Mathias Wennberg]

Thanks for your reply Chris

However, something have gone wrong with my fiddeling around in this 
commflagged colum. First, I get this (and simular) errror message on some 
rows when I try to change the 0 to 1 (I used mysqlcc):
[mythtv] ERROR 1062: Duplicate entry '5-20040831125601' for key 1
When I try to set this value again, however, it works and I can set it to 1.

The big problem is now that of 140 recordings, I can only see one in the 
mythtvweb list. And I can only view one from Mythtvs "view recording". 
However, all values seams to be present still - mythtvweb reports 140 
recording but only show 1. 

Does anyone have any suggestion of what can cause this? The only values I have 
changed are the commflagged values.

/Best regards
Mathias

On wednesday the 31 augusti 2004 02.35, Chris Pinkham wrote:
> > Thanks for the quick reply
> >
> > > The column is commflagged in recorded; the values can be found by
> > > tgrepping the sources for commflagged.
> > >
> > > Cheers,
> > > -- jra
> >
> > I can't find this values in the source. So I tried to set everyone to 0
> > and severly messed up the database.
> > What values should it have? Can I restore it with some program?
> >
> >From mythtv/libs/libmythtv/programinfo.h
>
> enum CommFlagStatuses {
>     COMM_FLAG_NOT_FLAGGED = 0,
>     COMM_FLAG_DONE = 1,
>     COMM_FLAG_PROCESSING = 2,
>     COMM_FLAG_COMMFREE = 3
> };
>
> Set them all to 1 to make Myth think it's already flagged them all.