[mythtv-users] Myth thinks capture cards are gone due toinvalidSQL query

[Michael T. Dean]

On 06/01/2008 04:18 PM, Doug Meredith wrote:
>> That schema certainly appears to have been updated.
>> That could only happen as a result of running a 0.21 (or perhaps an
>> svn) version of either mythbackend or mythtv-setup.
>>     
> Crap.  I installed 0.21 on a test system yesterday.  I just looked
> through the logs and it somehow auto discovered my production system and
> upgraded the database.  It looks like it did a backup first.  I'll see
> what I can salvage.  Thanks for the help.

Yeah, I told you that 0.20.2 had a parentid and a childcardid, but I 
didn't bother to tell you that they were both removed from the DB schema 
for 0.21 because someone told me, "It looks as if the Myth software is 
out of sync with the database schema, but I don't see how this could be 
possible. I haven't upgraded the software (0.20.2) in months and nobody 
else would have done so."  :)

But, yeah, 0.21 does do a database backup before upgrade, so you can go 
back.  In all reality, though, your best bet is to just take the hint 
the universe is trying to give you--upgrade your ancient 0.20.2 system 
to the "supported" 0.21 version.

Mike