[mythtv-users] mythbackend won't start on PVR-350 after FC1->FC2 and myth-0.15->myth-0.16 upgrade

[Michael Carter]

Kyle,

That fixed it. Thanks for the tip.

mjc

--- Kyle Rose <krose+mythtv at krose.org> wrote:

> Michael Carter <michaeljcarter at yahoo.com> writes:
> 
> > [root at goldings root]# /usr/bin/mythbackend
> > 2004-10-25 08:44:21 Upgrading to schema version 1051
> > DB Error (Performing database upgrade):
> > Query was:
> > ALTER TABLE recorded ADD COLUMN lastmodified TIMESTAMP NOT NULL;
> > Driver error was [2/1060]:
> > QMYSQL3: Unable to execute query
> > Database error was:
> > Duplicate column name 'lastmodified'
> >  
> > Any ideas?
> 
> This happened to me once.  It means that the upgrade was half-finished
> when it aborted, and there's no code in there to recover from
> partially-completed schema upgrades.
> 
> I solved the problem by doing the upgrade manually: I forget where it
> is in the code, but you can find it by grepping for the SQL above.
> 
> Cheers,
> Kyle
> > _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> 


=====
Michael J. Carter              | QOTD: "If you keep an open mind people
michaeljcarter at yahoo.com       | will throw a lot of garbage in it."

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com