View Issue Details

IDProjectCategoryView StatusLast Update
0021966mantisbtbugtrackerpublic2016-12-30 15:54
ReporterplexionAssigned Tocproensa 
PrioritynormalSeveritymajorReproducibilitysometimes
Status closedResolutionfixed 
Product Version1.3.4 
Target Version1.3.5Fixed in Version1.3.5 
Summary0021966: View Issues Page Throwing MySQL Error Due to Hard Coded SQL Query
Description

When using a non-default table suffix, View Issues page will throw a MySQL query error as one of the query in custom_field_api.php is hardcoded.

custom_field_api.php (Line 217 - 219):
$t_query = 'SELECT B.id AS bug_id, CF.id AS field_id, CFS.value, CFS.text FROM mantis_bug_table B'
. ' LEFT OUTER JOIN mantis_custom_field_table CF ON 1 = 1'
. ' LEFT OUTER JOIN mantis_custom_field_string_table CFS ON ( B.id = CFS.bug_id AND CF.id = CFS.field_id )';

TagsNo tags attached.

Related Changesets

MantisBT: master-1.3.x c533797d

2016-11-27 10:31:29

cproensa

Details Diff
Fix regression for hadcoded tables in queries

When using a non-default table suffix, View Issues page will throw a
MySQL query error as one of the query in custom_field_api.php is
hardcoded.
Introduced by: b613c438f71ae4d5bcdb099bbeaf31a723505b78

Fixes: 0021966
mod - core/custom_field_api.php Diff File

Issue History

Date Modified Username Field Change
2016-11-27 10:25 plexion New Issue
2016-11-27 10:30 cproensa Assigned To => cproensa
2016-11-27 10:30 cproensa Status new => assigned
2016-11-27 10:38 cproensa Note Added: 0054612
2016-11-27 10:45 atrol Severity minor => major
2016-11-27 10:45 atrol Product Version 2.0.0-rc.2 => 1.3.4
2016-11-27 10:45 atrol Target Version => 1.3.5
2016-11-27 13:56 cproensa Changeset attached => MantisBT master-1.3.x c533797d
2016-11-27 13:56 cproensa Status assigned => resolved
2016-11-27 13:56 cproensa Resolution open => fixed
2016-11-27 13:56 cproensa Fixed in Version => 1.3.5
2016-12-30 15:54 vboctor Status resolved => closed