[mythtv-users] corrrupted channel database with Mythtv .10 and
	xmltv .5.14
    mojo 
    mojospam at thegeekclub.net
       
    Thu Jul  3 20:17:26 EDT 2003
    
    
  
  >
> You were using cvs, so you need to upgrade with cvs.sql whenever that file is 
> changed.  You didn't do that, so things broke.
> 
> Isaac
already did.. and re-running it with -f just gives the expected errors:
minimojo database # mysql -f -u root -pspatula < cvs.sql
ERROR 1060 at line 18: Duplicate column name 'hue'
ERROR 1060 at line 20: Duplicate column name 'freqid'
ERROR 1060 at line 23: Duplicate column name 'rank'
ERROR 1060 at line 24: Duplicate column name 'rank'
ERROR 1060 at line 26: Duplicate column name 'category'
ERROR 1060 at line 27: Duplicate column name 'category'
ERROR 1060 at line 28: Duplicate column name 'category'
ERROR 1060 at line 30: Duplicate column name 'category_type'
i'll just drop the whole darn thing and be done with it (hopefully)... i 
think one of those sql scripts will put the files in var/video back into 
recorded programs (without the names) and thats fine...
Sean
    
    
More information about the mythtv-users
mailing list