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

[Michael T. Dean]

  On 07/26/2010 10:16 AM, Thomas Börkel wrote:
> Of course it is really strange, that the mysql client lib reports
> failures for both the SELECTs and DELETEs, but in fact the DELETEs
> succeeded. But that is another story.

FWIW, the message you're getting is exactly the message that the 
Qt-MySQL drivers (incorrectly) report when you submit invalid SQL that 
references non-existent tables or columns or similar.

Therefore, it's quite possible the whole problem is that your database 
schema is broken and some table or column is missing.  You could do a 
partial restore of your database (without plugin data), and it will fix 
any schema problems:

http://www.mythtv.org/wiki/Database_Backup_and_Restore#Partial_restore_of_a_backup

It will require re-configuring all your backends, frontends, and plugins.

Sure, it may make sense to change the way we deal with that error, and, 
perhaps, to make it a fatal error.

Mike