SiT! Bugs - SiT!
View Issue Details
0000406SiT!inbound emailpublic2009-01-15 14:222009-08-16 14:38
nicdev 
ivan 
normalmajorsometimes
closedfixed 
3.41 
3.503.50 
0000406: Inbound email with ' in the email address - email is deleted and not imported to the holding queue
When we receive an email from a customer with a (') in his email address, the mail script deletes it from the server inbox, but does not import it to the holding queue. There is no error reported- except for the SiT error log on the server:

Thu, 15 Jan 2009 14:29:23 +0000 Application Warning [512] 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 'xxxxxxxxxxxxxxxxxxxxx@xxxxxx.com', 'xxxxxxxx, xxxxxxxx', 'RE: Problem with xxxxxxxxxxxxxx' at line 1in [INSERT INTO `sit_tempincoming` (updateid, incidentid, `from`, emailfrom, subject, reason, contactid) VALUES ('5508', '0', 'xxxxxxxxxxxx'xxxxxxxxxxxxx@xxxxxx.com', 'xxxxxxxxxxxx, xxxxxxxxxxx', 'RE: Problem with xxxxxxxxxxxxxxxxx', 'Possible new incident', '' )] (in line 363 of file C:\wamp\www\sit\htdocs\inboundemail.php)

This is related to: "0000370: Escaped characters in DB affects other sit functions."

I am using the inbound script of 3.45.
No tags attached.
related to 0000370closed ivan Escaped characters in DB affects other sit functions. 
Issue History
2009-01-15 14:22nicdevNew Issue
2009-01-15 14:22nicdevStatusnew => assigned
2009-01-15 14:22nicdevAssigned To => kieran
2009-01-15 15:06nicdevAssigned Tokieran => nicdev
2009-01-15 15:10nicdevAssigned Tonicdev =>
2009-01-15 15:10nicdevStatusassigned => new
2009-03-05 13:55ivanRelationship addedrelated to 0000370
2009-04-17 16:10ivanNote Added: 0000931
2009-04-17 16:10ivanAssigned To => ivan
2009-04-17 16:10ivanStatusnew => resolved
2009-04-17 16:10ivanResolutionopen => fixed
2009-04-17 16:10ivanFixed in Version => Current SVN
2009-04-17 16:10ivanTarget Version => 3.50
2009-08-16 13:17ivanFixed in VersionCurrent SVN => 3.50
2009-08-16 14:38ivanNote Added: 0001608
2009-08-16 14:38ivanStatusresolved => closed

Notes
(0000931)
ivan   
2009-04-17 16:10   
No longer a problem for trunk svn r5330
(0001608)
ivan   
2009-08-16 14:38   
Released in 3.50rc1