1

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")

2

Re: Upgraded - can't add user

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

----

Buy me a cup of coffee ($5) to support iRedMail:

buy me a cup of coffee

3

Re: Upgraded - can't add user

Thank you

4

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}
 

----

Buy me a cup of coffee ($5) to support iRedMail:

buy me a cup of coffee

5

Re: Upgraded - can't add user

what are the instructions on how to use this patch?

6

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

----

Buy me a cup of coffee ($5) to support iRedMail:

buy me a cup of coffee

7

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

Re: Upgraded - can't add user

Sent. smile

----

Buy me a cup of coffee ($5) to support iRedMail:

buy me a cup of coffee

9

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

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

Re: Upgraded - can't add user

Glad you enjoy it. smile

----

Buy me a cup of coffee ($5) to support iRedMail:

buy me a cup of coffee