On Fri, 2004-04-23 at 14:51, Jan-Kees Fels wrote: > I have problems setting up the dbmail database. See hereunder for the > error. > > fels# pwd > > /tmp/dbmail-1.2.6/sql/mysql > > fels# mysql -uroot -p < create_tables.mysql > > Enter password: > > ERROR 1067 at line 7: Invalid default value for 'alias_idnr'
> Also, the following versions are used: > > Mysql: 4.1.0-alpha Perhaps MySQL 4.1 cannot use DEFAULT '0' with an AUTO_INCREMENT field.. Which even makes sense to me. Why put a '0' into a field that gets an auto_increment value? On the one hand, this is something that is probably not right in our stuff, but on the other hand, I wouldn't recommend using MySQL 4.1, as it's still in Alpha. Use MySQL 4.0.x instead. Ilja
