1 Topic by ssdd

  • ssdd
  • Member
  • Offline
  • Registered: 2016-05-30
  • Posts: 10

Topic: Error after upgrade

==== Required information ====
- iRedMail version (check /etc/iredmail-release):
- Linux/BSD distribution name and version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
- Web server (Apache or Nginx):
- Manage mail accounts with iRedAdmin-Pro?
- Related log if you're reporting an issue:
====

IredMail 0.9.5.1
CentOS 6.8
MySQL
Apache
iRedAdmin-Pro 2.4.0

Hello
We used IredAdminPro 2.1.3 and IredMail 0.9.2
We upgrade to 0.9.5.1 step to step (as provide at your link)
And when we try to add new Administrator to mailbox
We show some error
1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND address <> goto' at line 1"
I try to find when we made mistake, but i can't
Please 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: 30,788

Re: Error after upgrade

Did you try to add a separated admin account, or a mail user?

3 Reply by ssdd (edited by ssdd 2016-05-30 20:23:51)

  • ssdd
  • Member
  • Offline
  • Registered: 2016-05-30
  • Posts: 10

Re: Error after upgrade

ZhangHuangbin wrote:

Did you try to add a separated admin account, or a mail user?

When I change Domain -> Administrators

I Can see this message
(If Administrator is present, message can't display All OK)

Post's attachments

1.png
1.png 90.88 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.

4 Reply by ZhangHuangbin

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

Re: Error after upgrade

ssdd wrote:

(If Administrator is present, message can't display All OK)

I cannot reproduce this issue. could you please show me more details:

- Did you login as a normal domain admin or global admin?
- According to your explanation, do you mean if there's no domain admin for this domain, this error message will show up?

5 Reply by ssdd

  • ssdd
  • Member
  • Offline
  • Registered: 2016-05-30
  • Posts: 10

Re: Error after upgrade

ZhangHuangbin wrote:
ssdd wrote:

(If Administrator is present, message can't display All OK)

I cannot reproduce this issue. could you please show me more details:

- Did you login as a normal domain admin or global admin?
- According to your explanation, do you mean if there's no domain admin for this domain, this error message will show up?

I try to login as global admin or local admin
Yes. If in domain allready exist domain-admin I can't see this message. But If admin is empty, i can see this

6 Reply by ZhangHuangbin

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

Re: Error after upgrade

I cannot reproduce this issue on my testing machine. is it possible to let me login to your server for further debug? Contact me: zhb _at_ iredmail.org.

7 Reply by ssdd

  • ssdd
  • Member
  • Offline
  • Registered: 2016-05-30
  • Posts: 10

Re: Error after upgrade

It is bad idea. It is secure mail server.
I can provide structure of mysql databases

8 Reply by ZhangHuangbin

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

Re: Error after upgrade

OK, could you please export the SQL structure of "vmail" database? Just sql structure, no data required.

9 Reply by ssdd

  • ssdd
  • Member
  • Offline
  • Registered: 2016-05-30
  • Posts: 10

Re: Error after upgrade

It Is structure of vmail

Maybe i can miss some step...

Post's attachments

vmail.sql 16.38 kb, 1 downloads since 2016-05-31 

You don't have the permssions to download the attachments of this post.

10 Reply by ZhangHuangbin

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

Re: Error after upgrade

Missed sql column "mailbox.enablesogo". but this doesn't cause the issue in this case.

I have no clue without touch source code of iRedAdmin-Pro.

11 Reply by ssdd

  • ssdd
  • Member
  • Offline
  • Registered: 2016-05-30
  • Posts: 10

Re: Error after upgrade

Hello.

I can sent archive to you support e-mail

12 Reply by ssdd

  • ssdd
  • Member
  • Offline
  • Registered: 2016-05-30
  • Posts: 10

Re: Error after upgrade

zhb _at_ iredmail.org.

13 Reply by ssdd

  • ssdd
  • Member
  • Offline
  • Registered: 2016-05-30
  • Posts: 10

Re: Error after upgrade

Hello
I sent email to you with iredadmin

14 Reply by ZhangHuangbin

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

Re: Error after upgrade

ssdd wrote:

I can sent archive to you support e-mail

I need to modify source files to add some 'print' command to print information while you reproducing this issue. Send me archive of the file is useless.

15 Reply by ssdd

  • ssdd
  • Member
  • Offline
  • Registered: 2016-05-30
  • Posts: 10

Re: Error after upgrade

I sent email to you

16 Reply by ZhangHuangbin

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

Re: Error after upgrade

ssdd wrote:

I sent email to you

Dear @ssdd,

I have full source code of iRedAdmin-Pro (of course i have, i'm author of iRedAdmin-Pro), but i need to modify source code ON YOUR SERVER and ask you to reproduce this issue, so that i can understand why it doesn't work ON YOUR SERVER.

17 Reply by ssdd

  • ssdd
  • Member
  • Offline
  • Registered: 2016-05-30
  • Posts: 10

Re: Error after upgrade

if i provide all source code to you?
i can't provide access to you(

18 Reply by ZhangHuangbin

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

Re: Error after upgrade

ssdd wrote:

if i provide all source code to you?

Dear @ssdd,

I have all source code, i'm author of iRedAdmin-Pro. So, no, this doesn't help at all.
What i need is the environment which can trigger/reproduce this issue, so that i can know why it doesn't work.