[mythtv] Ticket #6820: Invalid default values specified for some fields in MythArchive dbcheck.cpp

[Michael T. Dean]

On 08/07/2009 05:53 PM, Daniel Kristjansson wrote:
> On Fri, 2009-08-07 at 23:17 +0200, Jonathan Martens wrote:
>   
>> On 7-8-2009 23:07, MythTV wrote:
>>     
>>> #6820: Invalid default values specified for some fields in MythArchive dbcheck.cpp
>> If I may be so bold... what is the reason for assigning them to an 
>> unknown milestone and assigning them non-blockers? This one, as well as 
>> issue 6802 and 6811, stop internal database upgrades and therefore 
>> hamper functionality AFAICT.
>>
>> As there are patches applied to all of them so they could be easily 
>> fixed or am I missing some vital information here, if so please fill me in.
>>     
>
> For correctness, those patches will be applied shortly. But you appear
> to be running mysql in strict mode, which is not supported. It is likely
> to cause the DB to get subtly corrupted leading to other problems which
> will be difficult to debug. When running mysql in traditional mode the
> problems you have helpfully identified will be silently ignored and
> MythTV will run normally.

Or, if TRADITIONAL mode doesn't work, try just removing all modes:

sql-mode=""

and, really, if you find TRADITIONAL doesn't work, we'd appreciate 
hearing so--as it seems no one really knows the minimum required as 
(most?) everyone has been running with the defaults/without a mode set.

Thanks,
Mike