1 Topic by usafitz

  • usafitz
  • Member
  • Offline
  • Registered: 2013-02-02
  • Posts: 71

Topic: Upgraded - can't add user

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

Hello.  I upgraded my email server and did a fresh install.  I went through the upgrade notes and did the changes to the databases before moving it over.  On the new server, I get the following error message when trying to add a user.  Please help.  Thank you.

Error: InternalError(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 ZhangHuangbin

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

Re: Upgraded - can't add user

Seems a bug of iRedAdmin-Pro. I will come back with a fix shortly.

3 Reply by usafitz

  • usafitz
  • Member
  • Offline
  • Registered: 2013-02-02
  • Posts: 71

Re: Upgraded - can't add user

Thank you

4 Reply by ZhangHuangbin

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

Re: Upgraded - can't add user

Could you try this patch and let me know how it works?

diff --git a/libs/sqllib/user.py b/libs/sqllib/user.py
index e1be2e1c..4b825d11 100644
--- a/libs/sqllib/user.py
+++ b/libs/sqllib/user.py
@@ -734,6 +734,7 @@ def add_user_from_form(domain, form, conn=None):
               'maildir': maildir,
               'language': preferred_language,
               'passwordlastchange': iredutils.get_gmttime(),
+              'disclaimer': '',
               'created': iredutils.get_gmttime(),
               'active': 1}

5 Reply by usafitz

  • usafitz
  • Member
  • Offline
  • Registered: 2013-02-02
  • Posts: 71

Re: Upgraded - can't add user

what are the instructions on how to use this patch?

6 Reply by ZhangHuangbin

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

Re: Upgraded - can't add user

OK, if you're not familiar with patch, please mail us with your license key or license owner's email address, we will send you a patched version. smile
https://www.iredmail.org/contact.html

7 Reply by usafitz

  • usafitz
  • Member
  • Offline
  • Registered: 2013-02-02
  • Posts: 71

Re: Upgraded - can't add user

I emailed as requested, but got no response.  Please send the patch or let me know how to use that patch that you mentioned on this forum.  Thank you.

8 Reply by ZhangHuangbin

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

Re: Upgraded - can't add user

Sent. smile

9 Reply by usafitz

  • usafitz
  • Member
  • Offline
  • Registered: 2013-02-02
  • Posts: 71

Re: Upgraded - can't add user

Thank you for sending.  I have applied the upgrade, however I am still seeing the same error when trying to add accounts.

10 Reply by usafitz

  • usafitz
  • Member
  • Offline
  • Registered: 2013-02-02
  • Posts: 71

Re: Upgraded - can't add user

Thank you for the help today!  It looks like it's fixed now.  I've enjoyed iRedMail for many years now (6 or 7) and have very much loved your product.

11 Reply by ZhangHuangbin

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

Re: Upgraded - can't add user

Glad you enjoy it. smile