[mythtv-users] Re: Clean 0.15 install, what should I save from the old DB?

[Aleaxander]

Bruce Markey wrote:
>> ----
>>
>> Everything looked good until I did the last step, and then received 
>> the following error:
>>
>> ERROR 1054 at line 1: Unknown column 'recorddups' in 'field list'
>>
>> Looking at a backup of the 0.15 mythconverg database I made before I 
>> started trying to restore information from the 0.14 database I see 
>> that there is no recorddups field present.  Anyone have any idea what 
>> I am doing wrong or suggestions on how I can proceed?
> 
> 
> That column was dropped and replaced with two other columns.
> 
>  ALTER TABLE record ADD COLUMN recorddups INT DEFAULT 0 NOT NULL;
> 
> Run the restore command again then:
> 
>  UPDATE record SET dupmethod = 1 WHERE recorddups = 2;
>  UPDATE record SET dupin = 2 WHERE recorddups = 1;
>  ALTER TABLE record DROP COLUMN recorddups;
> 
> --  bjm

Still running into problems.  I restored mythconverg from a backup made 
of 0.15, deleted the restore.sql file I had created earlier and started 
over, just in case I had messed something up in previous attempts, then 
followed the instructions again, as I understand them, doing:

$ grep "INSERT INTO record " mythtv_backup.sql > restore.sql
$ grep "INSERT INTO recorded " mythtv_backup.sql >> restore.sql
$ grep "INSERT INTO oldrecorded " mythtv_backup.sql >> restore.sql
$ grep "INSERT INTO recordedmarkup " mythtv_backup.sql >> restore.sql
$ mysql -u root -p mythconverg
mysql> ALTER TABLE record ADD COLUMN recorddups INT DEFAULT 0 NOT NULL;
mysql> exit
$ mysql -u mythtv -pmythtv mythconverg < restore.sql

Then got this error:
ERROR 1054 at line 1: Unknown column 'preroll' in field list'

Doh!  Okay, so I did the following:
mysql> ALTER TABLE record ADD COLUMN preroll INT DEFAULT 0 NOT NULL;
mysql> exit
$ mysql -u mythtv -pmythtv mythconverg < restore.sql

Then got this error (at this point I know I'm probably going down the 
path of messing up the database, but I'm desperate):
ERROR 1054 at line 1: Unknown column 'postroll' in field list'

Doh!  Doh!  How many fields am I missing?  This can't be good, but I 
keep going doing knowing that I'm probably destroying the database:
mysql> ALTER TABLE record ADD COLUMN postroll INT DEFAULT 0 NOT NULL;
mysql> exit
$ mysql -u mythtv -pmythtv mythconverg < restore.sql

At which point I get this error:
ERROR 1048 at line 1: Column 'subtitle' cannot be null

I'm wondering if because I've started with fresh and unused 0.15 
database, are there fields that have not yet been created by Mythtv? 
I'm stuck at this point and would really appreciate any help or a push 
in the right direction.  I'm desperate!

-Alex