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
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.