SiT! Bugs - SiT!
View Issue Details
0001100SiT!inbound emailpublic2010-02-23 20:512010-05-29 14:21
paulh 
ivan 
normalminoralways
closedfixed 
3.51 
3.61 LTS3.61 LTS 
0001100: SQL Error importing email with odd named attachment
Sending an email with multiple (3) attached messages

2010-02-23T20:49:24+00:00 auto.php ERROR: Application Warning You have an error in your SQL syntax; check the manual that corresponds to your MySQL server v
ersion for the right syntax to use near 's_Mitchel_Baker_in_NRCHandelsblad.eml[[/att]], [[att=8]]Re:_[Shib-Dev]_IdP_2_2_0' at line 1 in /home/paulh/sit/inbo
undemail.php at line 395
2010-02-23T20:49:24+00:00 auto.php Creating a link between 0 and file 7
2010-02-23T20:49:24+00:00 auto.php ERROR: Application Warning Duplicate entry '5-0-0' for key 'PRIMARY' in /home/paulh/sit/inboundemail.php at line 520
No tags attached.
related to 0001275resolved paulh non-ascii characters in inbound email attachment filenames are corrupted 
log webtrack.log (281,153) 2010-02-23 20:52
http://bugs.sitracker.org/file_download.php?file_id=88&type=bug
Issue History
2010-02-23 20:51paulhNew Issue
2010-02-23 20:52paulhFile Added: webtrack.log
2010-02-23 20:52paulhNote Added: 0002461
2010-02-23 20:53ivanNote Added: 0002463
2010-02-23 20:53paulhNote Added: 0002464
2010-02-23 20:53paulhProduct Version => 3.51
2010-04-14 21:57ivanStatusnew => assigned
2010-04-14 21:57ivanAssigned To => ivan
2010-04-14 21:58ivanNote Added: 0003068
2010-04-14 21:58ivanTarget Version => 3.61 LTS
2010-04-14 22:00ivanSummarySQL Error importing email => SQL Error importing email with odd named attachment
2010-04-14 22:11ivanNote Added: 0003069
2010-04-14 22:11ivanStatusassigned => resolved
2010-04-14 22:11ivanFixed in Version => Current SVN
2010-04-14 22:11ivanResolutionopen => fixed
2010-04-14 22:25ivanRelationship addedrelated to 0001275
2010-05-29 13:39ivanFixed in VersionCurrent SVN => 3.61 LTS
2010-05-29 14:21ivanNote Added: 0003217
2010-05-29 14:21ivanStatusresolved => closed

Notes
(0002461)
paulh   
2010-02-23 20:52   
debug log attached
(0002463)
ivan   
2010-02-23 20:53   
which version?
(0002464)
paulh   
2010-02-23 20:53   
Opps version is 3.51 (well 3.x SVN)
(0003068)
ivan   
2010-04-14 21:58   
Can confirm this, it happens with attachments that have a ' in the name, which isn't good at all.
(0003069)
ivan   
2010-04-14 22:11   
Fixed in svn r6435 and git ba5a3c7
(0003217)
ivan   
2010-05-29 14:21   
Released in v3.61