1

Topic: Can't create a new user

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

OperationalError(1364, "Field 'local_part' doesn't have a default value")

Can't create a new user due to this error.
Can anyone help?

2

Re: Can't create a new user

SQL column "mailbox.local_part" was dropped since iRedMail-0.9.8, did you restore the SQL database from an old iRedMail release? Please drop it and try again.
FYI: https://docs.iredmail.org/upgrade.iredm … b-backends

----

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

buy me a cup of coffee

3

Re: Can't create a new user

ZhangHuangbin wrote:

did you restore the SQL database from an old iRedMail release?

Yes, I forgot to mention it, I was sure that I made all the necessary changes, but apparently I missed some.
Anyway, thanks for the help, deleting the column solved the problem.