1 Topic by beez

  • beez
  • Member
  • Offline
  • Registered: 2011-06-09
  • Posts: 27

Topic: Error: (1064, "You have an error in your SQL syntax

Hello,

I think I encountered a problem with my iRedAdminPro mysql.

I was able to successfully create an email address with a '&' ex: ab&c@domain.com sign on it,
but after that I cannot do anything like reconfiguring and deleting the email address.

----

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

Re: Error: (1064, "You have an error in your SQL syntax

Sorry about this trouble.

I can't reproduce this issue with v1.0, v1.1.0.
May i know which version do you use? You can find version number in Dashboard page, section "System Information".

3 Reply by beez (edited by beez 2011-06-10 14:40:17)

  • beez
  • Member
  • Offline
  • Registered: 2011-06-09
  • Posts: 27

Re: Error: (1064, "You have an error in your SQL syntax

v1.1.0

edit:
I was adding the new mailbox containing '&' using postfixadmin,
then tried to manage it using iredadmin which causing the error (not found) or sql error when deleting the user

4 Reply by ZhangHuangbin

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

Re: Error: (1064, "You have an error in your SQL syntax

You can remove it manually via MySQL command line or phpMyAdmin.
Will try to make it work in iRedAdmin-Pro and let you know. Thanks for your feedback.

5 Reply by ZhangHuangbin

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

Re: Error: (1064, "You have an error in your SQL syntax

Fixed this issue in iRedAdmin-Pro, it now will report "Invalid mail address." message. But you have to delete it manually with mysql command line or phpMyAdmin.