0000370: Escaped characters in DB affects other sit functions.

(0000418)
nicdev (developer)
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 'aaldeenshabsough@xxxxxx.com%'' 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)

(0000482)
nicdev (developer)
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\update.inc.php @ line 641
Backtrace:
C:\wamp\www\sit\htdocs\incident\update.inc.php @ 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.

(0000483)
nicdev (developer)
2009-01-13 08:59

Just added another, from yesterday seems to be all popping up when updating incidents

(0000486)
nicdev (developer)
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.

(0000929)
ivan (administrator)
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.

(0000930)
ivan (administrator)
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

(0001611)
ivan (administrator)
2009-08-16 14:38

Released in 3.50rc1

Issue History
Date Modified	Username	Field	Change
2009-01-07 13:11	nicdev	New Issue
2009-01-07 13:13	nicdev	Note Added: 0000418
2009-01-13 08:54	nicdev	Note Added: 0000482
2009-01-13 08:58	nicdev	File Added: error2_escapes.jpg
2009-01-13 08:59	nicdev	Note Added: 0000483
2009-01-14 08:06	nicdev	Note Added: 0000486
2009-01-14 08:07	nicdev	Severity	major => crash
2009-03-05 13:55	ivan	Relationship added	related to 0000406
2009-04-17 15:59	ivan	Note Added: 0000929
2009-04-17 16:04	ivan	Note Added: 0000930
2009-04-17 16:04	ivan	Assigned To	=> ivan
2009-04-17 16:04	ivan	Status	new => resolved
2009-04-17 16:04	ivan	Resolution	open => fixed
2009-04-17 16:04	ivan	Fixed in Version	=> Current SVN
2009-04-17 16:04	ivan	Target Version	=> 3.50
2009-08-16 13:17	ivan	Fixed in Version	Current SVN => 3.50
2009-08-16 14:38	ivan	Note Added: 0001611
2009-08-16 14:38	ivan	Status	resolved => closed

Notes
(0000418) nicdev (developer) 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 'aaldeenshabsough@xxxxxx.com%'' 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)

(0000482) nicdev (developer) 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\update.inc.php @ line 641 Backtrace: C:\wamp\www\sit\htdocs\incident\update.inc.php @ 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.

(0000483) nicdev (developer) 2009-01-13 08:59	Just added another, from yesterday seems to be all popping up when updating incidents

(0000486) nicdev (developer) 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.

(0000929) ivan (administrator) 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.

(0000930) ivan (administrator) 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

(0001611) ivan (administrator) 2009-08-16 14:38	Released in 3.50rc1