[Typo3] If you're having problems installing extensions with MySQL 4.1
Rickard Andersson
rickard.andersson+typo3 at gmail.com
Thu Feb 3 11:07:11 CET 2005
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
More information about the TYPO3-english
mailing list