Apostrophe in email address causes error with psa-pc-remote

[Christopher McBride]

Whenever an email is sent where the recipient's address includes an apostrophe ('), an error is produced in the maillog:

an 20 09:59:31 server /usr/lib64/plesk-9.0/psa-pc-remote[16519]: Unable to prepare SQL statement for query 'SELECT executable, context, name FROM handlers WHERE queue=3 AND type='0' AND enabled=1 AND address='name.O'[email protected]' ORDER BY priority DESC': near "surname": syntax error

Can this be submitted as a bug to be resolved in a MU please?

 

[IgorG]

Yes, it is known problem and we have already submitted related bugreport. I have updated it with your case and I hope it will be fixed soon.

 

[Christopher McBride]

Thanks. much appreciated

 

[jprince]

Hi.
Is there an upate here?
Client complaints are starting to increase.
Thanks.

 

[Christopher McBride]

Any update on this Igor?

Six months is a long wait to a fix for what, I'm sure, is a simple fix of changing single quotes to doubles for the query.

 

[IgorG]

As far as I know it should be fixed in Plesk 11.

 

[Christopher McBride]

Can this fix be back-ported to 10 in a micro update?

 

[Christopher McBride]

Igor, any response for me on this?

 

[IgorG]

I have updated bugreport with your request. I hope that fix will be included into the one of microupdate.

 

[Christopher McBride]

Thanks Igor

 

[IgorG]

Fixed in 11.0.9 MU#34 - http://kb.parallels.com/115440