[mythtv] *buntu trusty ppa: loss of multirec

David Engel david at istwok.net
Fri Jan 29 17:07:22 UTC 2016


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
-- 
David Engel
david at istwok.net


More information about the mythtv-dev mailing list