[mythtv-users] Fixing minor errors in Myth database

[Fred Hamilton]

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 line 1720, <BACKUP> line 2828.
----------------------------------------------------------------------------

Any ideas anyone?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20130428/bb788118/attachment.html>