[mythtv-users] Myth thinks capture cards are gone due toinvalidSQL query
Michael T. Dean
mtdean at thirdcontact.com
Sun Jun 1 20:25:29 UTC 2008
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.
More information about the mythtv-users