[mythtv] Duplicated column in recorded in today's cvs?
chepati at yahoo.com
Fri Jul 23 14:16:47 EDT 2004
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.
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.
More information about the mythtv-dev