[mythtv-users] (no subject)

[Bruce Markey]

Dan Morphis wrote:
> 
> 
> 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;

It shouldn't have happened because the 'search' column should
be new for that update. I know it hasn't happend to hundreds of
others who have done the upgrade. I guess this would be possible
if the program crashed during the upgrade then it was restart or
something.

--  bjm