[Typo3] Upgrade 3.7 -> 3.8.1 - issue upgrading static templates

[Dmitry Dulepov]

Hi!

Nige wrote:
> I tried importing the the file
> \typo3\sysext\cms\ext_tables_static+adt.sql using phpmyadmin...got the
> error below. As the table structure hasn't changed, why should there be
> any problem...UNLESS it's something to do with my mysql
> installation/version. I am now using 4.1.14...is this known to work or
> not work with typo3, and is there something I should have done in moving
> my database to a 4.1.x system from 3.23.55?
> 
> Nige
> 
> The phpmyadmin error was...
> 
> Database pegasus running on localhost
> Error
> 
> SQL-query :
> 
> CREATE TABLE static_template(
> 
> uid int( 11 ) unsigned DEFAULT '0' NOT NULL auto_increment,
> pid int( 11 ) unsigned DEFAULT '0' NOT NULL ,
> tstamp int( 11 ) unsigned DEFAULT '0' NOT NULL ,
> crdate int( 11 ) unsigned DEFAULT '0' NOT NULL ,
> title tinytext NOT NULL ,
> include_static tinyblob NOT NULL ,
> constants blob NOT NULL ,
> config blob NOT NULL ,
> description text NOT NULL ,
> editorcfg blob NOT NULL ,
> PRIMARY KEY ( uid ) ,
> KEY parent( pid )
> )
> 
> MySQL said:
> 
> 
> Invalid default value for 'uid'

You cannot have th e following starting from MySQL 4.1:
> uid int( 11 ) unsigned DEFAULT '0' NOT NULL auto_increment,

It should be:
> uid int( 11 ) unsigned NOT NULL auto_increment,

This is a big and bad change in MySQL that makes it incompatible with
database dumps from all previous MySQL versions. Someone at MySQL team
really did not think about compatibility.

Use 3.23 until typo3 4.0 comes out or manually remove "DEFAULT '0'" from
all "uid" columns.

Dmitry.