[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