SiT! Bugs - SiT!
View Issue Details
0000370SiT!inbound emailpublic2009-01-07 13:112009-08-16 14:38
0000370: Escaped characters in DB affects other sit functions.
When escaped characters exist in the DB, then they can affect other SiT functions when they are imported from the DB later.
No tags attached.
related to 0000406closed ivan Inbound email with ' in the email address - email is deleted and not imported to the holding queue 
jpg error2_escapes.jpg (67,773) 2009-01-13 08:58
Issue History
2009-01-07 13:11nicdevNew Issue
2009-01-07 13:13nicdevNote Added: 0000418
2009-01-13 08:54nicdevNote Added: 0000482
2009-01-13 08:58nicdevFile Added: error2_escapes.jpg
2009-01-13 08:59nicdevNote Added: 0000483
2009-01-14 08:06nicdevNote Added: 0000486
2009-01-14 08:07nicdevSeveritymajor => crash
2009-03-05 13:55ivanRelationship addedrelated to 0000406
2009-04-17 15:59ivanNote Added: 0000929
2009-04-17 16:04ivanNote Added: 0000930
2009-04-17 16:04ivanAssigned To => ivan
2009-04-17 16:04ivanStatusnew => resolved
2009-04-17 16:04ivanResolutionopen => fixed
2009-04-17 16:04ivanFixed in Version => Current SVN
2009-04-17 16:04ivanTarget Version => 3.50
2009-08-16 13:17ivanFixed in VersionCurrent SVN => 3.50
2009-08-16 14:38ivanNote Added: 0001611
2009-08-16 14:38ivanStatusresolved => closed

2009-01-07 13:13   
example error in log:

"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 ''' at line 1 (in line 50 of file C:\wamp\www\sit\htdocs\review_incoming_updates.php)
Warning [2] mysql_fetch_row(): supplied argument is not a valid MySQL result resource (in line 51 of file C:\wamp\www\sit\htdocs\review_incoming_updates.php)
2009-01-13 08:54   
Found another one today:

Application Error [256]
MySQL Query Error 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 'un collaborateur

J\'attends l\'├ętude du contrat du client par Al' at line 1 in C:\wamp\www\sit\htdocs\incident\ @ line 641
C:\wamp\www\sit\htdocs\incident\ @ line 641 trigger_error()
C:\wamp\www\sit\htdocs\update_incident.php @ line 30 include()

As the French use the "'" a lot this pops up now regularly.
2009-01-13 08:59   
Just added another, from yesterday seems to be all popping up when updating incidents
2009-01-14 08:06   
Hi We have found that after the new french translation file the issues are very prominent. for status updates i removed some "'" from the translations, and most have disappeared. We have 90% French users and it is creating havoc!

e.g. changing status from "active" (french = "Actif") to "Awaiting Customer Action" (French = "en attente d'action client"), then the script fails with the above mysql errors.
2009-04-17 15:59   
Have fixed the last of these, changing status with french language causes SQL error. Trunk svn r5330

In future could you log things like this as seperate bugs and relate them? easier to track that way. thanks.
2009-04-17 16:04   
This isn't an issue for the new inbox which will replace the holding queue for incoming emails in v3.50
2009-08-16 14:38   
Released in 3.50rc1