[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