Zmmsgtrace - sql execute failed - error in SQL syntax

[Edmund]

Hi all,

I ran a zmmsgtrace -s email@address > file today to get a list of emails sent by a given user. This worked fine and returned a few hundred hits into the given file, but there were a couple of error messages returned to the console as well.

/opt/zimbra/bin/zmmsgtrace sql execute failed: 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 'xxx@xxx.xxx'  and from_IP='127.0.0.1'' at line 1
/opt/zimbra/bin/zmmsgtrace sql execute failed: 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 'xxx@xxx.xxx'  and from_IP='xxx.xxx.xxx.xxx'' at line 1

The same email address (a remote one, not one hosted here) was in each, along with a remote IP address.

This is a 5.02GA install on Centos 5.

I tried a few other zmmsgtrace -s lookups for other users and it all worked fine, no errors. Does anyone know what's going on here? There are no outstanding issues with the ZCS install as far as I know. I found the search mentioned in logger_myslow.log, but no errors were mentioned.

--
Best regards,
Edmund

[uxbod]

anything in /var/log/zimbra.log ?

[Edmund]

Originally Posted by uxbod

anything in /var/log/zimbra.log ?

No, nothing.