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

[Michael T. Dean]

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 
trouble."

*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.

Mike