[mythtv-users] Fixing minor errors in Myth database

[Paul Gardiner]

On 28/04/2013 19:35, Fred Hamilton wrote:
> Thanks Paul.
>
> Now, as Mike suggested might happen, the partial update failed.  Here's
> the relevant bit from the --verbose output:
> ----------------------------------------------------------------------------
> Found 81 tables in the database.
>
> Backup file is compressed.
>   - Uncompressing backup file with IO::Uncompress::Gunzip.
>
> Attempting to use supplied password for mysql command-line client.
> Any [client] or [mysql] password specified in the MySQL options file will
> take precedence.
>
> Restoring partial backup with filter:
> (40101 SET NAMES |^INSERT INTO
> \`?(oldrecorded|record|recorded|recordedmarkup|recordedprogram|recordedrating|recordedseek)\`?
> )
>
> Executing command:
> 'mysql' --defaults-extra-file='/tmp/GLxgJIcvg0' --host='192.168.1.100'
> --port='3306' --user='mythtv' 'mythconverg'
> ERROR 1054 (42S22) at line 7: Unknown column 'offset' in 'field list'
>
> ERROR: Cannot write to mysql, stopped at
> /usr/share/mythtv/mythconverg_restore.pl <http://mythconverg_restore.pl>
> line 1720, <BACKUP> line 2828.
> ----------------------------------------------------------------------------
>
> Any ideas anyone?

I think that means that one of the tables in your backup has
a column called 'offset', and the column doesn't exist in the
corresponding table within your new mythconverg database. If so, and if
you can discover which table it is, you may be able to temporarily add
the column 'offset' to that table, perform the restore and then remove
the column.

Paul.