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

[Nowhere]

> -----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?

I haven't done a thourough feature check yet but
recording/viewing/deleting is working fine as is mythweb...

Thanks!
Eric


My MythBox:
Athlon XP 2000+, MSI K7N2GM-L, 512MB Kbyte, 80GB Seagate Single Platter,
2xPVR250 Coolmax CX300B Silent PSU, Coolermaster ATC-610BX1 Case, Fedora
Core 1, 2.4.22-1.2179 kernel, ivtv-0.1.9, myth 0.15.20040505.1