[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 Nowhere
> Sent: Sunday, July 11, 2004 10:06 AM
> To: 'Discussion about mythtv'
> Subject: RE: [mythtv-users] Mythvideo fails to compile from 7/10 cvs
> 
> > -----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
> 
> 

Holy COW! Check out the spelling errors... I need my morning coffee...
brb...

e.