Hi, The database is indeed created without any errors when I use mysql 4.0
Now, I have a problem with the next step. (run build.sh) I enter the directory which contains the extracted dbmmail stuff and do the following. (this directory does contain the file "build.sh"). fels# ./build.sh ./build.sh: Command not found. My current versions are: Mysql 4.0.18 Postfix 2.0.14 Freebsd 5.2.1 Dbmail 1.2.6 Any ideas? I am more a windows guy then a unix guy, so maybe this is something obvious that I don't see. My apologies if this is the case. Thanks, Jan-Kees -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ilja Booij Sent: Monday, April 26, 2004 10:42 AM To: DBMail mailinglist Subject: Re: [Dbmail] ERROR 1067 at line 7: Invalid default value for'alias_idnr' 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 _______________________________________________ Dbmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
