| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0012267 | mantisbt | db oracle | public | 2010-08-18 17:35 | 2014-12-08 00:34 |
| Reporter | bob | Assigned To | dregad | ||
| Priority | normal | Severity | major | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | ||
| Product Version | 1.2.0rc2 | ||||
| Target Version | 1.3.0-beta.1 | Fixed in Version | 1.3.0-beta.1 | ||
| Summary | 0012267: Custom Field Title and Value render as '@', $t_custom_field, '@'; in Oracle | ||||
| Description | Probably occurs in later version as well. If a enumerated custom field is defined as: Name = Theme oracle will return the column name in lower case which is theme In function custom_field_get_id_from_name, it looks for a field name of theme, but name is defined as Theme, so no field is found, so a false value is returned to custom_function_default_print_column_title and custom_function_default_print_column_value which results in '@', $t_custom_field, '@' being displayed. | ||||
| Additional Information | To fix this change the following queries: $query = "SELECT id FROM $t_custom_field_table WHERE name = '$c_field_name'"; to $query = "SELECT id FROM $t_custom_field_table WHERE lower(name) = lower('$c_field_name')"; and to $query = "SELECT id FROM $t_custom_field_table WHERE lower(name) LIKE lower('$c_field_name%')"; | ||||
| Tags | No tags attached. | ||||
 |
Can you please check if this issue still exists using the Oracle branch at |
