Re: [AMaViS-user] Creating maddr problem

You are absolutely correct. Sorrying for missing that.

Thank you for taking the time to reply.


----- Original Message -----
From: "Mark Martinec" <Mark.Martinec+amavis@ijs.si>
To: <amavis-user@lists.sourceforge.net>
Sent: Wednesday, August 03, 2005 5:27 PM
Subject: Re: [AMaViS-user] Creating maddr problem


> Jeff,
>
>> I'm attempting to create the table maddr according to the README however
>> below is the error. I'm using SLES 9.0.
>>
>> mysql> CREATE TABLE maddr (
>> -> id SERIAL PRIMARY KEY,
>> -> email varchar(255) NOT NULL,
>> -> domain varchar(255) NOT NULL
>> ->
>> -> ) ENGINE=InnoDB;
>> ERROR 1064: You have an error in your SQL syntax. Check the manual that
>> corresponds to your MySQL server version for the right syntax to use near
>> 'SERIAL PRIMARY KEY,
>> email varchar(255) NOT NULL,
>> d
>>
>> I've successfull been able to create the other three tables though.
>> 'msgs',
>> 'msgrcpt', and 'quarantine'
>
> Perhaps this is the issue (from README.sql):
>
> -- MySQL notes:
> -- - the attribute SERIAL was introduced with MySQL 4.1.0;
> -- with earlier versions one can use INT UNSIGNED NOT NULL
> AUTO_INCREMENT
>
> Mark
>
>
> -------------------------------------------------------
> SF.Net email is Sponsored by the Better Software Conference & EXPO
> September 19-22, 2005 * San Francisco, CA * Development Lifecycle
> Practices
> Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
> Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
> _______________________________________________
> AMaViS-user mailing list
> AMaViS-user@lists.sourceforge.net
> https://lists.sourceforge.net/lists/...fo/amavis-user
> AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
> AMaViS-HowTos:http://www.amavis.org/howto/
>




-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/...fo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/