1

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.

2

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 (edited by beez 2011-06-10 14:40:17)

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

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

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.