1 (edited by guybowdler 2018-02-21 08:06:22)

Topic: deleting user: error 1054 delete_date missing from Field List

==== Required information ====
- iRedMail version (check /etc/iredmail-release):  0.9.7
- Linux/BSD distribution name and version: Ubuntu 14.0.5
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? no
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
Error 1054 deleting a user column delete_date missing from field list.

hi, seems a column was missing from MySSQL, have upgraded a few versions to get to 0.9.7.   Worked around by adding a column as below to vmail.deleted_mailboxes, but please could you tell me where / when this field was added so that I can check what else I missed!  Have retraced the steps back from 0.8.6 and can't see any mention of it!

**UPDATE** adding this field also seems to have fixed a problem I had adding a user to a new domain just created as well.

thanks smile

mysql> ALTER TABLE deleted_mailboxes \
    -> ADD COLUMN delete_date DATETIME NOT NULL DEFAULT '1970-01-01 01:01:01';
Query OK, 16 rows affected (0.02 sec)
Records: 16  Duplicates: 0  Warnings: 0

----

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

2

Re: deleting user: error 1054 delete_date missing from Field List

SQL table "deleted_mailboxes" is mentioned in 2 upgrade tutorials:

- https://docs.iredmail.org/upgrade.iredm … 0.8.5.html
- https://docs.iredmail.org/upgrade.iredm … 0.9.3.html