1 Topic by csa

  • csa
  • Member
  • Offline
  • Registered: 2020-09-06
  • Posts: 3

Topic: Incorrect table name 'forwardings'

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- 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?

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

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

  • tech-otaku
  • Member
  • Offline
  • Registered: 2019-10-22
  • Posts: 27

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.