[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