[TYPO3-english] SQL Problem in Update wizard

Tomas Norre Mikkelsen tomasnorre at gmail.com
Thu Feb 10 14:14:19 CET 2011


On 10-02-2011 14:11, Xavier Perseguers 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
>
> First edit the column in phpMyAdmin to remove the default value then
> update the type, or do it at once "manually" while editing the field.

I've tried that too =(

The type is correct before running the SQL, but its the default value 
part that fails.


More information about the TYPO3-english mailing list