1 Topic by Blocker (edited by Blocker 2018-07-17 09:35:12)

  • Blocker
  • Member
  • Offline
  • Registered: 2013-06-18
  • Posts: 37

Topic: Error: IntegrityError(1364, "Field 'disclaimer' doesn't have a default

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release):
- Linux/BSD distribution name and version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
- Web server (Apache or Nginx):
- Manage mail accounts with iRedAdmin-Pro?
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

iRedMail Version: 0.9.8
Linux version: Ubuntu 18.04 LTS
Store mail: mysql
Web Server: Nginx
Managed with: iredAdminPro

Getting an error trying to add new user eg:
Error: IntegrityError(1364, "Field 'disclaimer' doesn't have a default value")

----

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

2 Reply by Blocker (edited by Blocker 2018-07-17 09:34:35)

  • Blocker
  • Member
  • Offline
  • Registered: 2013-06-18
  • Posts: 37

Re: Error: IntegrityError(1364, "Field 'disclaimer' doesn't have a default

Just a bit more info, doing DESC domain \G produces this:
*************************** 3. row ***************************
  Field: disclaimer
   Type: text
   Null: NO
    Key:
Default: NULL
  Extra:

Field not allowed to be Null but default value = Null?? 

The same values for disclaimer field in mailbox table.