[SOLVED] unable to send mails after upgrade to 3.2

Discussion in 'General' started by marabi, Nov 13, 2020.

  1. marabi

    marabi New Member

    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

    user = ispconfig
    password = XXXXXXXX
    dbname = dbispconfig
    hosts =
    query = SELECT destination FROM mail_forwarding WHERE source = '%s' AND active = 'y' AND allow_send_as = 'y' AND server_id = 2
    SELECT email FROM mail_user WHERE email = '%s' AND disablesmtp = 'n' AND server_id = 2;
    Can anybody help me?

  2. Jesse Norell

    Jesse Norell Well-Known Member Staff Member Howtoforge Staff

    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).
  3. marabi

    marabi New Member

    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


  4. marabi

    marabi New Member

    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

Share This Page