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
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
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
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
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
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:
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',
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
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
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
10 matches
Mail list logo