[mythtv-users] Mythvideo fails to compile from 7/10 cvs

[J. Donavan Stanley]

Nowhere wrote:

>>-----Original Message-----
>>From: mythtv-users-bounces at mythtv.org [mailto:mythtv-users-
>>bounces at mythtv.org] On Behalf Of J. Donavan Stanley
>>Sent: Sunday, July 11, 2004 4:41 AM
>>To: Discussion about mythtv
>>Subject: Re: [mythtv-users] Mythvideo fails to compile from 7/10 cvs
>>
>>Nowhere wrote:
>>
>>    
>>
>>>Did you happen to try to run the frontend yet? My compile from
>>>      
>>>
>today's
>  
>
>>>CVS won't start. DB error trying to create the stars column in one of
>>>the tables...
>>>
>>>
>>>      
>>>
>>Something interrupted the database update...
>>
>>Execute the following in mysql:
>>
>>ALTER TABLE recorded ADD COLUMN previouslyshown TINYINT(1) DEFAULT 0;
>>ALTER TABLE recorded ADD COLUMN originalairdate DATE;
>>INSERT INTO settings VALUES ('HaveRepeats', '0', NULL);
>>UPDATE settings SET data = '1053' WHERE value = 'DBSchemaVer';
>>
>>This will make all the changes the dbcheck code would have and mark
>>    
>>
>your
>  
>
>>DB as being the right version.
>>
>>Make sure none of Myth is running when you do.
>>    
>>
>
>
>Thanks Donavan,
>
>However, I needed it up last night so I dropped both the stars column
>and the previoulyshow columns from the recorded table and rebooted.
>Everything seems to be working now. 
>
>Is what I have done sufficient or should I still do what you suggest?
>  
>

If you deleted those columns, then the dbcheck code should have 
recreated them when you started the FE.