Bug #14422
closed
bug with MySQL 4.1.7
0%
Description
all SQL statements like NOT NULL DEFAULT '0' seem to be rejected by mysqld
There has already been some fixes for ext. installation, but if you use the install tool to upgrade from 3.6 to 3.7 for example, you cannot import the static tables, and you cannot apply the comparison's results as well.
Well.. if it has already been fixed up, I'll blush and cry sorry.
(issue imported from #M560)
Updated by old_kttxpo over 19 years ago
looks like # 0000546, because of the new syntax on auto increment.
Updated by old_kttxpo over 19 years ago
someting like this should be able to correct it.
!/bin/bash
version=typo3_src-3.7.0
for i in $(find $version -name *.sql)
do
echo "Patching $i..."
sed -r "s/DEFAULT '0' NOT NULL auto_increment/NOT NULL auto_increment/g" -i $i
grep "DEFAULT '0' NOT NULL auto_increment" $i
done
for i in $(find content/typo3conf -name *.sql)
do
echo "Patching $i..."
sed -r "s/DEFAULT '0' NOT NULL auto_increment/NOT NULL auto_increment/g" -i $i
grep "DEFAULT '0' NOT NULL auto_increment" $i
done