View Issue Details

IDProjectCategoryView StatusLast Update
0021966mantisbtbugtrackerpublic2018-02-13 03:31
Reporterplexion Assigned 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.

Relationships

has duplicate 0023957 closedcproensa Database query failed. Error received from database was 0001146: Table 'helpdesk.mantis_bug_table' doesn't exist for the query: 

Related Changesets

MantisBT: master-1.3.x c533797d

2016-11-27 05:31

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
Affected Issues
0021966
mod - core/custom_field_api.php Diff File