[mythtv] [PATCH] DBOX2 Feed Implementation 2005-05-10

[Levent Guendogdu]

Andrew wrote:

>On Wednesday 11 May 2005 04:06, Levent Guendogdu wrote:
>  
>
>>Hi people,
>>
>>attached you will find the implementation for using the DBOX2 as a
>>MythTV DVB source.
>>
>>Features:
>>   - using the Nokia/Sagem/Philips DBOX2 as a video source for MythTV
>>   - multiple DBOX2s can be used
>>   - grabs a complete TS stream from the DBOX2 using SPTS mode (all
>>audio streams available in myth)
>>   - automatic EPG scan of all DBOX2 channels when recorder/livetv is
>>inactive
>>
>>Please submit this to the current CVS.
>>
>>Have fun,
>> Levon
>>    
>>
>
>Just tried this and are having problems adding capture cards, you add capture 
>card, can be dvb or whatever but they dont show up on the list, also any 
>previous cards I had configured have gone from the list aswell.
>
>The sql error is:
>
>DB Error (simpledbstorage update):
>Query was:
>
>Thats it. I would have thought the database would have had a schema upgrade? 
>  
>
Yes, a schema upgrade is needed for this to work properly. The upgrade 
does not work if your database has already reached a certain version. 
For a quickfix do this in your mysql console:

INSERT INTO profilegroups SET name = 'DBOX2 Input', cardtype = 'DBOX2', 
is_default = 1;"
ALTER TABLE capturecard ADD COLUMN dbox2_port INT UNSIGNED NOT NULL 
DEFAULT 31338;
ALTER TABLE capturecard ADD COLUMN dbox2_httpport INT UNSIGNED NOT NULL 
DEFAULT 80;
ALTER TABLE capturecard ADD COLUMN dbox2_host varchar(32) NULL;

The next patch (released in a couple of minutes) will upgrade the db 
schema to 1083 automatically. If you apply it, please reverse the first one.

Keep me posted.

Bye,
 Levon.