[mythtv] Duplicated column in recorded in today's cvs?

[IvanK.]

Replying to myself, this is what I had to do:

ALTER TABLE oldprogram DROP COLUMN oldtitle;
ALTER TABLE recorded DROP COLUMN lastmodified;
ALTER TABLE recorded DROP COLUMN filesize;

After that everything was good again.

IvanK.

On Friday 23 July 2004 01:43 pm, IvanK. wrote:
> Hey guys,
>
> I updated to cvs from about 30 minutes ago (~ 1pm EST) and I get this in
> the mythbackend.log:
>
> -R-E-S-T-A-R-T-E-D- at Fri Jul 23 13:43:12 EDT 2004
> 2004-07-23 13:43:13 Upgrading to schema version 1051
> DB Error (Performing database upgrade):
> Query was:
> ALTER TABLE recorded ADD COLUMN lastmodified TIMESTAMP NOT NULL;
> Driver error was [2/1060]:
> QMYSQL3: Unable to execute query
> Database error was:
> Duplicate column name 'lastmodified'
>
> A column lastmodified already exists in recorded.
>
> Am I doing something wrong?  I haven't followed the list lately, so
> apologies if I'm asking an already answered question.
>
> IvanK.