[mythtv] Ticket #8679: mythfrontend deletes settings when db connection is "weak" (was Re: Please unlock ticket)

[Thomas Börkel]

HI!

On 26.07.2010 19:28, Michael T. Dean wrote:

>> If the database schema was broken, what it ever run without errors?
> 
> Yes, until it hit the code that issued the SQL that won't work with your
> schema.

OK, so why would it issue this code only once a month during start of
the frontend?

Anyway, since I activated -v database now, maybe this will reveal something.

> On an unrelated note, (but just to make the point that broken schemas
> aren't noticed immediately) this is exactly why we recommend against
> users doing things to the DB.  When someone breaks the DB (either the
> data or the schema), they create a ticking time bomb.  Generally, by the
> time they notice a failure, it's been long enough that they no longer
> suspect that the "fixing" they did is what caused it.

That's right.

Is there any way that one can compare the schema to the "correct" schema?

Thomas