Topic: Incorrect table name 'forwardings'

- iRedMail version (check /etc/iredmail-release):   1.3.1 MARIADB edition
- Deployed with iRedMail Easy or the downloadable installer? downloadable installer
- Linux/BSD distribution name and version: Server version: 10.3.22-MariaDB-1ubuntu1 Ubuntu 20.04
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? no
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.

I'm trying to set up mmlj following https://docs.iredmail.org/integration.m … mj-package

when I try and add columns to the maillists table I get an error, as follows:

MariaDB [vmail]> alter table maillists add column forwardings.is_maillist VARCHAR(15);
ERROR 1103 (42000): Incorrect table name 'forwardings'

what am I doing wrong?

2 (edited by tech-otaku 2020-09-13 12:51:36)

Re: Incorrect table name 'forwardings'

Your SQL statement is trying to add a column named forwardings.is_maillist to the mailists table.  I think you need to add a column named is_maillist to the forwardings table i.e.

USE vmail;
ALTER TABLE forwardings ADD is_maillist TINYINT(1) NOT NULL DEFAULT 0;

Having said that, my forwardings table already has a column named is_maillist and my domain table already has a column named maillists so I'd check yours before trying to add them.