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

[Nige]

Michael/Ingmar...maybe you can help?...

First...is there any difference in the static tables between 3.7.0 and 
3.8.1...if not, I won't waste my time trying to sort out this error!

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'