1 Topic by srgbogachev

  • srgbogachev
  • Member
  • Offline
  • Registered: 2021-11-12
  • Posts: 2

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?

----

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,088

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

3 Reply by srgbogachev

  • srgbogachev
  • Member
  • Offline
  • Registered: 2021-11-12
  • Posts: 2

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.