[mythtv] Duplicate column name 'stars'
John Patrick Poet
john at BlueSkyTours.com
Sat Jul 10 21:00:38 EDT 2004
I decided to grab the latest CVS image. Unfortunately Myth will not
startup now:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Session management error: Authentication Rejected, reason : None of the
authentication protocols specified are supported and host-based
authentication failed
2004-07-10 18:53:40 Upgrading to schema version 1053
DB Error (Performing database upgrade):
Query was:
ALTER TABLE recorded ADD COLUMN stars FLOAT UNSIGNED NOT NULL DEFAULT 0;
Driver error was [2/1060]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate column name 'stars'
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
So, what is the safest way to fix this, without loosing my current
recorded shows?
I can dive into the "Schema upgrade" code and probably figure out how to
get beyond this, but I was hoping for a quick fix.
Thanks,
John
More information about the mythtv-dev
mailing list