[TYPO3-english] SQL Problem in Update wizard

[Tomas Norre Mikkelsen]

On 10-02-2011 13:33, Kay Strobach wrote:
> Hi,
>
> copy the queries 1 by 1 into phpmyadmin or a similar dbms.
> That may help.
> Had something similar in 4.4. ;)

I gives the same problem:

#1101 - BLOB/TEXT column 'cost' can't have a default value

/Tomas

>
> Best regards
> Kay
> Am 10.02.2011 13:03, schrieb Tomas Norre Mikkelsen:
>> Hi,
>>
>> I have a problem SQL queries and Update Wizard. I'm upgrading a solution
>> to typo3lts, and got follow 3 queries, that need to be done in "compare"
>> databases.
>>
>> -- SQL
>> ALTER TABLE tx_tcdirectmail_sentlog DROP KEY authcode;
>> ALTER TABLE tx_tcdirectmail_sentlog ADD KEY authcode (authcode(9));
>> ALTER TABLE tx_skcalendar_event CHANGE cost cost tinytext default 0;
>>
>> -- Result:
>> BLOB/TEXT column 'cost' can't have a default value
>>
>> Why is it trying to change to values not allowed?
>>
>> any hints and problem solving?
>>
>> /Tomas
>
>