1 Topic by xylander

  • xylander
  • Member
  • Offline
  • Registered: 2024-10-13
  • Posts: 2

Topic: Can't add new domain after upgrading to iRedAdmin-Pro

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.7.1 MARIADB edition.
- Deployed with iRedMail Easy or the downloadable installer? downloadable
- Linux/BSD distribution name and version: Rockly Linux 9.4
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL (MARIADB)
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? Yes
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
I just upgraded to iRedAdmin-Pro from IRedAdmin open source edition.

When I tried to add a new domain using IRedAdmin-Pro, it failed, and I received the following message on screen:
Error: DataError(1366, "Incorrect integer value: '' for column `vmail`.`domain`.`aliases` at row 1")

What do need to do to fix the problem?

Thanks

----

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: Can't add new domain after upgrading to iRedAdmin-Pro

It's clear that you have incorrect value in "vmail" sql database, column "domain.aliases".
Could you please double check all values of this column? It must be an integer number, 0 means unlimited.

3 Reply by xylander

  • xylander
  • Member
  • Offline
  • Registered: 2024-10-13
  • Posts: 2

Re: Can't add new domain after upgrading to iRedAdmin-Pro

ZhangHuangbin wrote:

It's clear that you have incorrect value in "vmail" sql database, column "domain.aliases".
Could you please double check all values of this column? It must be an integer number, 0 means unlimited.

It looks like I can't leave Number of max mail users/etc. fields blank. Once I put in a number, I can add the domain.

Thanks.