non existent mail_relay table in master ispconfig

Discussion in 'ISPConfig 3 Priority Support' started by Frost, Jan 8, 2020.

  1. Frost

    Frost Member

    ISPConfig 3.1.15p2
    Ubuntu 18.04.3 LTS
    MySQL 5.7
    I am in a multiserver environment with a mirror server of web, ns, mail server) including master to master DB replication. ISPConfig is located in DB Servers.
    Error Received:
    [INTERFACE]: Falsche Anfrage / Wrong QuerySQL-Query = SELECT * FROM `mail_relay` WHERE server_id = 9 -> 1146 (Table 'dbispconfig.mail_relay' doesn't exist)
     
    Frost, Jan 8, 2020
    #1
  2. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Have you looked in the database, does that table exist or is it really missing? Have you run the repair tables and check tables operatations?
     
    Taleman, Jan 8, 2020
    #2
  3. Frost

    Frost Member

    It doesn't exist. any of my servers doesn't have mail_relay table in dbispconfig DB
     
    Frost, Jan 8, 2020
    #3
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    I guess you used the resync function in ISPConfig? Seems as if the table is referenced there by error.
     
    till, Jan 8, 2020
    #4
  5. Frost

    Frost Member

    Correct but I didn't change anything from the ispconfig source code.
     
    Frost, Jan 8, 2020
    #5
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    I did not say that you changed something. I said that the table is referenced by the resync function in ISPConfig by error.
     
    till, Jan 8, 2020
    #6

Share This Page