[mythtv-users] Fixing minor errors in Myth database

[Paul Gardiner]

On 28/04/2013 21:21, John Pilkington wrote:
> On 28/04/13 20:25, Paul Gardiner wrote:
>
>>> 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.
>
> recordedmarkup used to use 'offset' but no longer does.  See eg Ticket
> 10871

Right, so what might work is

   ALTER TABLE recordedmarkup ADD offset INT;

then perform partial restore, then

   ALTER TABLE recordedmarkup DROP offset;