Re: [AMaViS-user] Errors in the log

2005-12-13 Thread Mark Martinec
Gary, Keyname Type Cardinality Field PRIMARY PRIMARY 0id id UNIQUE0id users_idx_email INDEX None email PRIMARY and INDEX keys should not both be set for column `id` Using SERIAL PRIMARY KEY appears to have

Re: [AMaViS-user] Errors in the log

2005-12-13 Thread Jim Knuth
Heute (13.12.2005/15:50 Uhr) schrieb Mark Martinec ([EMAIL PROTECTED]), Gary, Keyname Type Cardinality Field PRIMARY PRIMARY 0id id UNIQUE0id users_idx_email INDEX None email PRIMARY and INDEX keys should not

Re: [AMaViS-user] Errors in the log

2005-12-12 Thread Mark Martinec
Jim, I use mysql 4.0.24 and phpMyAdmin told me by creating (for example): CREATE TABLE users ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, priority integer NOT NULL DEFAULT '7', policy_id integer unsigned NOT NULL DEFAULT '1', email varchar(255) NOT

Re: [AMaViS-user] Errors in the log

2005-12-12 Thread Jim Knuth
Heute (13.12.2005/02:09 Uhr) schrieb Mark Martinec ([EMAIL PROTECTED]), Jim, I use mysql 4.0.24 and phpMyAdmin told me by creating (for example): CREATE TABLE users ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, priority integer NOT NULL DEFAULT '7', policy_id

Re: [AMaViS-user] Errors in the log

2005-12-12 Thread Mark Martinec
Jim, That's fine. Use either KEY in the CREATE TABLE, or CREATE ...INDEX, but not both. then it`s wrong in the README!? ;) Or how can I understand this? Fixed on the version on the web: http://www.ijs.si/software/amavisd/README.sql.txt Mark

Re: [AMaViS-user] Errors in the log

2005-12-12 Thread Jim Knuth
Heute (13.12.2005/02:56 Uhr) schrieb Mark Martinec ([EMAIL PROTECTED]), Jim, That's fine. Use either KEY in the CREATE TABLE, or CREATE ...INDEX, but not both. then it`s wrong in the README!? ;) Or how can I understand this? Fixed on the version on the web:

Re: [AMaViS-user] Errors in the log

2005-12-12 Thread Gary V
Jim wrote: Heute (13.12.2005/02:09 Uhr) schrieb Mark Martinec ([EMAIL PROTECTED]), Jim, I use mysql 4.0.24 and phpMyAdmin told me by creating (for example): CREATE TABLE users ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, priority integer NOT NULL DEFAULT '7',

Re: [AMaViS-user] Errors in the log

2005-12-12 Thread Jim Knuth
Heute (13.12.2005/05:49 Uhr) schrieb Gary V ([EMAIL PROTECTED]), Using what you have now on the three I tried: users, mailaddr, policy and maddr, msgrcpt, msgs, wblist Using SERIAL PRIMARY KEY appears to have created a new problem. no no. I`ve no set SERIAL PRIMARY KEY. I`ve set INT UNSIGNED

Re: [AMaViS-user] Errors in the log

2005-12-07 Thread Jim Knuth
Heute (am 08.12.2005) schrieb Mark Martinec, Jim, Dec 6 22:25:21 server2 amavis[2335]: (02335-05) NOTICE: reconnecting in response to: sql execute: sts=2013, DBD::mysql::st execute failed: Lost connection to MySQL server during query at (eval 39) line 127, GEN77 line 5. Dec 6 Most likely

[AMaViS-user] Errors in the log

2005-12-06 Thread Jim Knuth
Hallo und Guten Morgen amavis-user, I use amavis 2.3.3 with mysql. Sometimes I become this in the log: --- Dec 6 22:25:21 server2 amavis[2335]: (02335-05) NOTICE: reconnecting in response to: sql execute: sts=2013, DBD::mysql::st execute failed: Lost connection to MySQL server during