Anonymous | Login | Signup for a new account | 2021-03-04 21:14 GMT | ![]() |
Main | My View | View Issues | Change Log | Roadmap |
View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||
ID | Project | Category | View Status | Date Submitted | Last Update | ||||
0000370 | SiT! | inbound email | public | 2009-01-07 13:11 | 2009-08-16 14:38 | ||||
Reporter | nicdev | ||||||||
Assigned To | ivan | ||||||||
Priority | normal | Severity | crash | Reproducibility | always | ||||
Status | closed | Resolution | fixed | ||||||
Platform | OS | OS Version | |||||||
Product Version | 3.41 | ||||||||
Target Version | 3.50 | Fixed in Version | 3.50 | ||||||
Summary | 0000370: Escaped characters in DB affects other sit functions. | ||||||||
Description | When escaped characters exist in the DB, then they can affect other SiT functions when they are imported from the DB later. | ||||||||
Tags | No tags attached. | ||||||||
Attached Files | ![]() | ||||||||
![]() |
||||||
|
![]() |
|
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) |
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. |
nicdev (developer) 2009-01-13 08:59 |
Just added another, from yesterday seems to be all popping up when updating incidents |
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. |
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. |
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 |
ivan (administrator) 2009-08-16 14:38 |
Released in 3.50rc1 |
![]() |
|||
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 |
Copyright © 2000 - 2021 MantisBT Team |