[mythtv-users] database errors during upgrade...

[anders smith]

Sorry about that.
I thought that I did, but couldn't find any references to how I get past my
corrupted table... maybe I phrased it wrong in the seach... ;-)
rgds
anders

----- Original Message ----- 
From: "john salch" <jsalch at yahoo.com>
To: "Discussion about mythtv" <mythtv-users at mythtv.org>
Sent: Monday, October 11, 2004 3:01 PM
Subject: Re: [mythtv-users] database errors during upgrade...


> Please search the archives.  This has been covered.
>
> John
> --- anders smith <anders at smiths.dk> wrote:
>
> > After upgrading vi apt-get and atrpms I'm now stuck
> > because the database update balks..
> >
> > First I got this:
> >
> > ---snip---
> > 2004-10-09 14:41:42 Upgrading  to schema 1051
> > DB error (performing database upgrade):
> > Query was ALTER TABLE recorded ADD COLUMN
> > lastmodified TIMESTAMP NOT
> > NULL:
> > Driver error was [2/-1]:
> > QMYSQL3: Unable to execute querry
> > Database error was:
> > Duplicate column name 'last modified'
> > ---snip---
> >
> > I deleted the 'lastmodified' column in the database
> > as well as the 'filesize' when it gave the same
> > complaint and I deleted my 'recordedmarkup' table as
> > it was corrupted, but now I can't get past it.....
> >
> > I did a mysqldump and I think it's complete, but
> > because of the corruption of the 'recordedmarkup'
> > table I can't be sure, so that is one reason why I
> > haven't just dumped the whole 'mythconverg' database
> > and started from scratch... the other is that I'm
> > not sure of the best way to do it.
> >
> > Do I simply dump the database, import the mc.sql
> > setup file and the reimport my mysqldump?
> >
> > Alternatively can someone tell me how to set up the
> > mythconverg.recordedmarkup' table?
> >
> > thanks
> > Anders
> >
> > > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users at mythtv.org
> >
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> >
>
>


----------------------------------------------------------------------------
----


_______________________________________________
mythtv-users mailing list
mythtv-users at mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users