1 Topic by selea (edited by selea 2017-08-14 18:49:13)

  • selea
  • selea
  • Member
  • Offline
  • Registered: 2017-06-02
  • Posts: 111

Topic: "Error: Mail address already exists, please choose another one."

==== Required information ====
- iRedMail version : 0.9.5-1
- Linux/BSD distribution name and version: Ubuntu 14.04.5 LTS
- Store mail accounts in which backend: MYSQL
- Web server (Apache or Nginx): Apache
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue. - Where is the logs?
====

I have gotten some issues when I want to create email accounts via the iRedmail GUI. I just get the message saying "Error: Mail address already exists, please choose another one." even if the specified account that I want to create does not exist.
This started to happend after I upgraded to the latest iRedAdmin release

Why?

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by selea

  • selea
  • selea
  • Member
  • Offline
  • Registered: 2017-06-02
  • Posts: 111

Re: "Error: Mail address already exists, please choose another one."

Also, when deleting account in the GUI. I also do get this message;
Error: (1146, "Table 'vmail.forwardings' doesn't exist")

3 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: "Error: Mail address already exists, please choose another one."

Please upgrade iRedMail to the latest iRedMail-0.9.7:
http://www.iredmail.org/docs/iredmail.releases.html

We have some SQL structure change in recent iRedMail releases.

4 Reply by selea

  • selea
  • selea
  • Member
  • Offline
  • Registered: 2017-06-02
  • Posts: 111

Re: "Error: Mail address already exists, please choose another one."

ZhangHuangbin wrote:

Please upgrade iRedMail to the latest iRedMail-0.9.7:
http://www.iredmail.org/docs/iredmail.releases.html

We have some SQL structure change in recent iRedMail releases.

Upgrading to iRedAPD (2.1) and iRedAdmin (0.8) did not solve the issue. I did not "skip" any releases, I downloaded the updates - applied them - and moved up to next version via the update script you provided.

5 Reply by RikuS (edited by RikuS 2017-08-15 16:43:19)

  • RikuS
  • Member
  • Offline
  • Registered: 2016-06-10
  • Posts: 116

Re: "Error: Mail address already exists, please choose another one."

If you have error

Error: (1146, "Table 'vmail.forwardings' doesn't exist")

that means you have skipped at least creation of new MySQL tables.

Read more:
http://www.iredmail.org/docs/upgrade.ir … nd-special

From 0.9.5-1 you need to do all these steps from both of the pages:
http://www.iredmail.org/docs/upgrade.ir … 0.9.6.html
http://www.iredmail.org/docs/upgrade.ir … 0.9.7.html

6 Reply by selea

  • selea
  • selea
  • Member
  • Offline
  • Registered: 2017-06-02
  • Posts: 111

Re: "Error: Mail address already exists, please choose another one."

RikuS wrote:

If you have error

Error: (1146, "Table 'vmail.forwardings' doesn't exist")

that means you have skipped at least creation of new MySQL tables.

Read more:
http://www.iredmail.org/docs/upgrade.ir … nd-special

From 0.9.5-1 you need to do all these steps from both of the pages:
http://www.iredmail.org/docs/upgrade.ir … 0.9.6.html
http://www.iredmail.org/docs/upgrade.ir … 0.9.7.html

I have not skipped any version, I upgraded everything without skipping a version today.
I have not tested to remove an account, to I don't know if that specific error message has been solved.
The "Error: Mail address already exists, please choose another one" does still persist thou.

7 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: "Error: Mail address already exists, please choose another one."

selea wrote:

The "Error: Mail address already exists, please choose another one" does still persist thou.

Did you apply SQL changes in iRedMail-0.9.7?
Has iRedAdmin-Pro been upgraded to the latest iRedAdmin-Pro-SQL-2.7.0?

8 Reply by selea (edited by selea 2017-08-16 13:41:07)

  • selea
  • selea
  • Member
  • Offline
  • Registered: 2017-06-02
  • Posts: 111

Re: "Error: Mail address already exists, please choose another one."

ZhangHuangbin wrote:
selea wrote:

The "Error: Mail address already exists, please choose another one" does still persist thou.

Did you apply SQL changes in iRedMail-0.9.7?
Has iRedAdmin-Pro been upgraded to the latest iRedAdmin-Pro-SQL-2.7.0?

Hi,
I do not use iRedAdmin-Pro yet, and thanks for pointing out the steps I have missed futher down on the site that had all the instructions.

Have a cup of coffee!

9 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: "Error: Mail address already exists, please choose another one."

selea wrote:

Have a cup of coffee!

Thank you very much. smile