[Typo3] If you're having problems installing extensions with MySQL 4.1

[Ries van Twisk]

I totally agree about the mysql stupidity....

But also report this in bugs.typo3.org or notify the extention developer.

Ries

>I've installed a number of extensions running MySQL 4.1 and for some reason,
>most of them attempt to assign their ID columns both the attribute
>AUTO_INCREMENT and a default value. Beginning with MySQL 4.1, this isn't
>allowed (it never should have been in the first place). So, if you're trying
>to install an extension and you get a MySQL error along the lines of
>"Invalid default value for 'id'", just open up ext_tables.sql in the
>extension directory and remove the default value (most likely "DEFAULT '0'")
>from any columns that also have the AUTO_INCREMENT attribute. In MySQL 4.0
>and earlier, the default value was simply ignored, so don't worry about this
>causing any side-effects.
>
>/Rickard
>
>
>_______________________________________________
>Typo3-english mailing list
>Typo3-english at lists.netfielders.de
>http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>  
>