[mythtv-users] (no subject)

[Dan Morphis]

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