[mythtv-users] Storage groups: How to set 'SGweightLocalStarting' to 0?

[Brad DerManouelian]

On Oct 8, 2008, at 2:29 PM, Michael T. Dean wrote:

>> Based on Mike's advice, I reduced my three SQL entries to 1:
>>
>> mysql> select * from settings where value = "SGweightLocalStarting";
>> +-----------------------+------+----------+
>> | value                 | data | hostname |
>> +-----------------------+------+----------+
>> | SGweightLocalStarting | 0    |          |
>> +-----------------------+------+----------+
>> 1 row in set (0.00 sec)
>>
>
> And you're sure that hostname is actually NULL and not the empty  
> string?

>
>
> SELECT * FROM settings WHERE value IS NULL;
>
> Some (esp GUI) clients don't handle NULL well.

For future reference, mysql client will display NULL when the value is  
null. The above indicates there is an empty value which is not the  
same as NULL.

For example:
mysql> select * from settings where hostname IS NULL LIMIT 1;
+------------------------------+------------------+----------+
| value                        | data             | hostname |
+------------------------------+------------------+----------+
| mythfilldatabaseLastRunStart | 2008-10-08 12:53 | NULL     |
+------------------------------+------------------+----------+
1 row in set (0.00 sec)