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

[Arco]

Thnx, it works now.

I think I found it:
This one fails:
  CREATE TABLE tt_content (
	tx_gooffotoboek_function varchar(7) DEFAULT '' NOT NULL,
	tx_gooffotoboek_path mediumtext ,
	tx_gooffotoboek_webpath mediumtext
  );
This one works:
  CREATE TABLE tt_content (
	tx_gooffotoboek_function varchar(7) DEFAULT '' NOT NULL,
	tx_gooffotoboek_path mediumtext,
	tx_gooffotoboek_webpath mediumtext
  );

Only difference is the missing space between mediumtext and the comma...

Arco

Ingmar Schlecht <ingmars at web.de> wrote ..
> 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
> _______________________________________________
> Typo3-dev mailing list
> Typo3-dev at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev