[mythtv-users] (no subject)

[Pierre Diversé]

----- Original Message ----- 
From: "Dan Morphis" <dan at milkcarton.com>
To: "Discussion about mythtv" <mythtv-users at mythtv.org>
Sent: Friday, May 28, 2004 2:18 AM
Subject: Re: [mythtv-users] (no subject)


>
>
> Bruce Markey wrote:
>
> >  Stuart Hodges wrote:
> >
> > > Hi,
> > >
> > > I had the same problem, I followed the instructions and then
> > > restarted mythbackend and got:
> > >
> > > /usr/local/bin/mythbackend -d 2004-05-27 21:20:02 Upgrading to
> > > schema version 1043 2004-05-27 21:20:02 Upgrading to schema version
> > > 1044 2004-05-27 21:20:07 Upgrading to schema version 1045
> > > 2004-05-27 21:20:07 Upgrading to schema version 1046 2004-05-27
> > > 21:20:07 Upgrading to schema version 1047 DB Error (Performing
> > > database upgrade): Query was: ALTER TABLE record ADD COLUMN search
> > > INT UNSIGNED NOT NULL DEFAULT 0; Driver error was [2/-1]: QMYSQL3:
> > > Unable to execute query Database error was: Duplicate column name
> > > 'search'
> > >
> > > So it looks like I have to do some more manual aditions, Any ideas
> > > what ?
> >
> >
> >  Well, now, how did that happen?
> >
> >  UPDATE record SET search = 0 WHERE search IS NULL; DELETE FROM
> >  settings WHERE value='DBSchemaVer'; INSERT INTO settings (value,
> >  data) VALUES ('DBSchemaVer', '1047');
> >
> >  should do the trick.
> >
> >  -- bjm
> Bruce, I had the same problem when I upgraded to the latest CVS
> yesterday. I ended up doing a: alter table record drop column search;
>
> I wonder if anyone else is having this issue when upgrading?
>
> -dan
>


Yes I am having this issue ;-), did the update Bruce posted... no luck
mythfrontend now gives me

2004-05-28 03:31:04 Upgrading to schema version 1048
DB Error (Performing database upgrade):
Query was:
CREATE TABLE networkiconmap (    id INTEGER NOT NULL AUTO_INCREMENT,
network VARCHAR(20) NOT NULL UNIQUE,    url VARCHAR(255) NOT NULL,
PRIMARY KEY(id));
Driver error was [2/1050]:
QMYSQL3: Unable to execute query
Database error was:
Table 'networkiconmap' already exists

any ideas??

thanks

Pierre


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


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