1 Topic by asklepiy

  • asklepiy
  • Member
  • Offline
  • Registered: 2019-10-11
  • Posts: 2

Topic: dict(2221): Error: sql dict: commit failed: Unknown column 'imap' in '

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version 1.4:
- Deployed with iRedMail Easy or the downloadable installer? - downloadable installe
- Linux/BSD distribution name and version: ubuntu server 18.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] dict(2698): Error: sql dict: commit failed: Unknown column 'imap' in 'field list'
====
dict(2698): Error: sql dict: commit failed: Unknown column 'imap' in 'field list'

auth-worker(3568): Error: sql(support@asklepiy.com): User query failed: Unknown column 'mailbox.enablequota-status' in 'w
Aug 24 14:45:35 mail.asklepiy.com dovecot[1041]: quota-status(support@asklepiy.com): Error: user support@asklepiy.com: Auth USER lookup failed

----

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

2 Reply by Cthulhu

  • Cthulhu
  • Member
  • Offline
  • Registered: 2019-06-04
  • Posts: 907

Re: dict(2221): Error: sql dict: commit failed: Unknown column 'imap' in '

fresh 1.4 setup or did you do a upgrade?

3 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: dict(2221): Error: sql dict: commit failed: Unknown column 'imap' in '

Seems you upgraded from an old iRedMail release but missed few steps related to SQL structure changes.
Please double check against our upgrade tutorials: https://docs.iredmail.org/iredmail.releases.html