[mythtv] *buntu trusty ppa: loss of multirec

[John Pilkington]

On 29/01/16 17:07, David Engel wrote:
> On Thu, Jan 28, 2016 at 01:45:56PM +0000, John Pilkington wrote:
>> On 27/01/16 23:30, John Pilkington wrote:
>>> On 27/01/16 23:10, David Engel wrote:
>>>
>>>> Can you run mythtv-setup with -v database?
>>
>> OK, I have a 123kB file.  I worked through the capturecard and input
>> selector screens, setting max recordings to 5.  Now what?
>>
>> On inspection I notice:
>>
>> Some queries are getting 1-row returns from both hostname IS NULL and
>> hostname = '6710b'
>>
>> I've been accessing the DB directly with
>>
>> mysql -umythtv -pmythtv -h localhost mythconverg
>>
>>
>> ... and within 1 screen of the end there's an
>>
>> UPDATE capturecard ... schedorder = ''4,     livetvorder = ''5,  ... WHERE
>> cardid = '5' <<<< Took 0ms
>>
>> and yet after exit both are zero.  Perhaps the ''n are pointers?
>
> That does look strange.  I think I'm going to rewrite the database
> part of the card cloning.  There's some really ugly code in there.
>
> In the mean time, please try this.  In
> mythtv/libs/libmythtv/cardutil.cpp, around line 837 is the following
> code.
>
>      for (uint i = 0; i < 24; ++i)
>          query2.bindValue(QString(":V%1").arg(i), query.value(i).toString());
>
> Change 24 to 26.  I think that will fix the problem.
>
> David
>
Ok, thanks.  I just set up a patched build and then saw the commit :-)