[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