[Typo3-dev] Cannot get rid of "update needed, changing field"in EXT

[Ingmar Schlecht]

The database/sqlfile comparision in Typo3 does not work reliable in all 
situations.

Thus you sometimes need to change the declarations in the ext_tables.sql 
file to fit the way Typo3 wants it to be.

In your case, if I'm not mistaken, the sql file contains something like 
that:
    tx_gooffotoboek_path mediumtext DEFAULT ''

Just delete the following "DEFAULT '' " so it looks like this:
    tx_gooffotoboek_path mediumtext

...and hopefully you're having more luck.

BTW, this is related to the following bug:
http://bugs.typo3.org/bug_view_page.php?bug_id=0000055

cheers,
Ingmar

Arco wrote:
> In my extention I added two fields in the ext_tables.sql
> In the EM -> my_extention the database needs an update.
> After the first update (which is expected) I still have an error:
> 
>   Database status:	Table error!
>   Probably one or more required fields/tables are missing in the database!
> 
>   Update needed:
>   Changing fields
> 
> 	ALTER TABLE tt_content CHANGE tx_gooffotoboek_path tx_gooffotoboek_path           
>         mediumtext DEFAULT '' ;
> 	Current value: mediumtext
> 	
>         ALTER TABLE tt_content CHANGE tx_gooffotoboek_webpath 
>         tx_gooffotoboek_webpath mediumtext DEFAULT '';
> 	Current value: mediumtext
> 
> When looking in the database the value is correct.
> What did I oversee?
> 
> Arco