View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0012418 | mantisbt | filters | public | 2010-10-01 09:25 | 2011-10-24 18:31 |
Reporter | sveyret | Assigned To | daryn | ||
Priority | normal | Severity | block | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Product Version | 1.2.3 | ||||
Fixed in Version | 1.2.5 | ||||
Summary | 0012418: SQL error when a field has a ? | ||||
Description | I have a value for a custom field which contains a “?”. If I select this value in the filter, I have an application error: APPLICATION ERROR 0000401 Échec de la requête de base de données. L'erreur renvoyée par la base de données était 0001064 : 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 ''XTP 3.6' at line 1 pour la requête : SELECT Count( DISTINCT mantis_bug_table.id ) as idcnt FROM mantis_project_table, mantis_bug_table LEFT JOIN mantis_custom_field_string_table mantis_custom_field_string_table_2 ON mantis_custom_field_string_table_2.bug_id = mantis_bug_table.id AND mantis_custom_field_string_table_2.field_id = 2 WHERE mantis_project_table.enabled = ? AND mantis_project_table.id = mantis_bug_table.project_id AND ( mantis_bug_table.project_id = 94 ) AND ( mantis_bug_table.status in (?, ?, ?, ?, ?, ?) ) AND (mantis_custom_field_string_table_2.value = 'XTP 3.6 ?'). Merci d'utiliser le bouton « Précédent » de votre navigateur web pour retourner à la page précédente. Vous pourrez y corriger les problèmes identifiés par cette erreur ou choisir une autre action. Vous pouvez aussi choisir une option de la barre de menu pour aller directement dans une nouvelle section. | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
The query was not properly using db_query_bound in some instances. |
|
This issue is not fixed in version 1.2.4. |
|
Fixed in version is set to 1.2.x which means it will be available in next released version (1.2.5) |
|
The diff applyed on my 1.2.4. works fine, thanks. |
|
MantisBT: master 765735ba 2010-12-22 16:50 Details Diff |
Fix Bug 0012418: SQL error when a field has a ? |
Affected Issues 0012418 |
|
mod - core/filter_api.php | Diff File | ||
MantisBT: master-1.2.x bbf5612a 2010-12-22 16:50 Details Diff |
Fix Bug 0012418: SQL error when a field has a ? |
Affected Issues 0012418 |
|
mod - core/filter_api.php | Diff File |