[mythtv-users] (no subject)
dan at milkcarton.com
Fri May 28 02:18:42 EDT 2004
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?
More information about the mythtv-users