[mythtv-users] mythtv schema upgrade, from v1227 -> v1264, FAILs @ v1262: "Data truncated for column 'data' at row 1"

Michael T. Dean mtdean at thirdcontact.com
Fri Jan 20 00:39:02 UTC 2012


On 01/09/2012 04:48 PM, dch8758 wrote:
> On Mon, Jan 9, 2012, at 12:59 PM, jk90090 wrote:
>>> how can I workaround the broken schema upgrade step?
>>>
>> Your error is caused by NULL values in the data column.
>>
>> mysql -u<username>  -p<password>  -Dmythconverg
>> # select * from settings where Data is Null;
>>
>> On my system the result is 0 records.
> so you've identified what the problem is, thanks!
>
> is this something that I can fix, rather than just workaround, on my
> end?  or is it a bug that needs fixing?

dch, out of curiosity, what versions of Qt and MySQL are you running?  
Also, what do you get from:

mysql -umythtv -p mythconverg -e 'SELECT @@GLOBAL.sql_mode; SELECT 
@@SESSION.sql_mode;'

Thanks,
Mike


More information about the mythtv-users mailing list