[mythtv-users] Myth thinks capture cards are gone due toinvalidSQL query
Michael T. Dean
mtdean at thirdcontact.com
Sun Jun 1 20:36:54 UTC 2008
On 06/01/2008 04:18 PM, Doug Meredith wrote:
> 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.
Oh, and just for the record/archive...
MythTV 0.21 and above will /not/ automatically upgrade /any/ MythTV
database schema if you actually configure MythTV on the system. You
configure MythTV by running mythtv-setup first thing (i.e. before /ever/
running mythbackend). When you do, mythtv-setup will realize that the
system hasn't been configured (i.e. you don't have a valid config.xml),
so it will autodiscover /all/ backends on the network (i.e. at this
point your production backend). You could then select that (and let it
upgrade the production database), but--since you're doing a test
install--you realize that you want to specify a different database and
choose the appropriate options in the GUI.
The /only/ way to get Myth to automatically upgrade your schema*, is to
run mythbackend in a non-interactive shell (i.e. an init script or an
ssh session or specifying the -d argument or something) before ever
running mythtv-setup. This process is also referred to as, "Asking for
*This completely ignores a useless, undocumented setting that says,
"Always upgrade my schema," for which there is no GUI control, so no one
has it set.
More information about the mythtv-users