Hello, on my small multiserver setup i'm not able to send or receive emails any more. (Ubuntu 18.04) i saw an error in mail.err (e.g. Warning: mysql: Query failed, retrying: Unknown column 'disablequota-status' in 'where clause') telling me that something is wrong in /etc/postfix/mysql-virtual_email2email.cf postmap -q mail@mydomain com mysql:/etc/postfix/mysql-virtual_email2email.cf postmap: warning: mysql:/etc/postfix/mysql-virtual_email2email.cf: query failed: Unknown column 'forward_in_lda' in 'where clause' postmap: fatal: table mysql:/etc/postfix/mysql-virtual_email2email.cf: query error: Operation not supported email2email.cf: user = ispconfig password = XXXXXXXX dbname = dbispconfig hosts = 127.0.0.1 query = SELECT destination FROM mail_forwarding WHERE source = '%s' AND active = 'y' AND allow_send_as = 'y' AND server_id = 2 UNION SELECT email FROM mail_user WHERE email = '%s' AND disablesmtp = 'n' AND server_id = 2; Can anybody help me? best marabi
Your sql updates didn't complete, go through the incremental sql update files upd_0089.sql and upd_0090.sql and manually make the changes (eg paste into phpmyadmin).
Do i have to do this only on the master? when i do from 0089 ALTER TABLE `mail_user` -> ADD `purge_trash_days` INT NOT NULL DEFAULT '0' AFTER `move_junk`, -> ADD `purge_junk_days` INT NOT NULL DEFAULT '0' AFTER `purge_trash_days`; i got ERROR 1292 (22007): Incorrect date value: '0000-00-00' for column 'last_quota_notification' at row 7 Best maraqi
1.) thanks for your fast reply. 2.) i changed all 0000-00-00 column to NULL and did the sql part again. Seams to work now. Best marabi
