Nope same error... Arrrggghhghhhhh
On Tue, 2003-06-10 at 22:32, Aaron Stone wrote:
> Try changing the line so that the 0 is not '0'. Perhaps the lastest MySQL
> is picky about seeing numbers inside of quotes?
>
> Aaron
>
>
> On 11 Jun 2003, Kerberus wrote:
>
> > Thanks for the heads up, but it still doesnt like this line
> >
> > ns2# cd sql/mysql/
> > ns2# mysqladmin create dbmail
> > ns2# mysql dbmail < create_tables_innoDB.mysql
> > ERROR 1067 at line 6: Invalid default value for 'alias_idnr'
> >
> >
> > On Tue, 2003-06-10 at 21:23, [EMAIL PROTECTED] wrote:
> > > Hi. I higly recomend to use innodb tables instead of the MyISAM ones,
> > > because your email system will have problem when database grew up beyond 2
> > > GB. I'm using Postfix 2.0.10, Mysql 4.0.12 in Solaris x86. No problem with
> > > database creation.
> > >
> > > mysql -p**** dbmail < create_tables_innoDB.mysql
> > >
> > > Your Mysql must support Innodb and your need to enable it. To do so, edit
> > > your my.cnf file. For example, to enable autoexensible innodb tables with
> > > a initial size of 100 MB, you put following line below [mysqld] in my.cnf
> > >
> > > [mysqld]
> > > innodb_data_file_path=ibdata1:100M:autoextend
> > >
> > > Regards, Alejandro Marin
> > >
> > >
> > >
> > > > FreeBSD 5.1 & M<ySQL 4.10
> > > >
> > > > mysql -p****** dbmail < create_tables.mysql
> > > > ERROR 1067 at line 6: Invalid default value for 'alias_idnr'
> > > >
> > > > ns2# mysqladmin -pSecured version
> > > > mysqladmin Ver 8.40 Distrib 4.1.0-alpha, for portbld-freebsd5.1 on i386
> > > > Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
> > > > This software comes with ABSOLUTELY NO WARRANTY. This is free software,
> > > > and you are welcome to modify and redistribute it under the GPL license
> > > >
> > > > Server version 4.1.0-alpha
> > > > Protocol version 10
> > > > Connection Localhost via UNIX socket
> > > > UNIX socket /tmp/mysql.sock
> > > > Uptime: 22 hours 16 min 29 sec
> > > >
> > > >
> > > >
> > > >
> > > > _______________________________________________
> > > > Dbmail mailing list
> > > > [email protected]
> > > > https://mailman.fastxs.nl/mailman/listinfo/dbmail
> > > >
> > >
> > > _______________________________________________
> > > Dbmail mailing list
> > > [email protected]
> > > https://mailman.fastxs.nl/mailman/listinfo/dbmail
> >
> > _______________________________________________
> > Dbmail mailing list
> > [email protected]
> > https://mailman.fastxs.nl/mailman/listinfo/dbmail
> >
>
> _______________________________________________
> Dbmail mailing list
> [email protected]
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
