View Issue Details

IDProjectCategoryView StatusLast Update
0020043mantisbtcustom fieldspublic2015-08-30 14:41
Reporterahtesham Assigned Toatrol  
PrioritynormalSeverityblockReproducibilityalways
Status closedResolutionduplicate 
PlatformApache-2.2.16, PHP 5.3.8OSFedora release 14 (Laughlin) 
Product Version1.3.0-beta.2 
Summary0020043: APPLICATION ERROR 0000401 Db query failed. Error received from database was 0001063 Not unique table/alias
Description

I have a custom field in form of text separated by "|". Due to varchar(256) constraints I have modified these entries and shortened them.

for example previous - Malaysia new entry - Mal

However when I am sorting the issues with help of this code I am receiving following error:

Database query failed. Error received from database was #1066: Not unique table/alias: 'mantis_custom_field_string_table_16' for the query: SELECT Count( DISTINCT mantis_bug_table.id ) as idcnt FROM mantis_bug_table JOIN mantis_project_table ON mantis_project_table.id = mantis_bug_table.project_id LEFT JOIN mantis_custom_field_string_table mantis_custom_field_string_table_16 ON mantis_bug_table.id = mantis_custom_field_string_table_16.bug_id AND mantis_custom_field_string_table_16.field_id = 16 LEFT JOIN mantis_custom_field_string_table mantis_custom_field_string_table_16 ON
mantis_bug_table.id = mantis_custom_field_string_table_16.bug_id AND mantis_custom_field_string_table_16.field_id = 16 WHERE mantis_project_table.enabled = ? AND ( mantis_bug_table.project_id = 2 ) AND ( ( mantis_bug_table.status in (?, ?, ?, ?, ?, ?) ) AND ((mantis_custom_field_string_table_16.value LIKE ?)) ) .

Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.

Steps To Reproduce

1) Create custom field and type as check box

2) Now modify them.

3) Filter bugs using new entries.

I have don't any development back ground. Let me know If you need any more help to reproduce this issue.

Additional Information

Error message:

Database query failed. Error received from database was #1066: Not unique table/alias: 'mantis_custom_field_string_table_16' for the query: SELECT Count( DISTINCT mantis_bug_table.id ) as idcnt FROM mantis_bug_table JOIN mantis_project_table ON mantis_project_table.id = mantis_bug_table.project_id LEFT JOIN mantis_custom_field_string_table mantis_custom_field_string_table_16 ON mantis_bug_table.id = mantis_custom_field_string_table_16.bug_id AND mantis_custom_field_string_table_16.field_id = 16 LEFT JOIN mantis_custom_field_string_table mantis_custom_field_string_table_16 ON
mantis_bug_table.id = mantis_custom_field_string_table_16.bug_id AND mantis_custom_field_string_table_16.field_id = 16 WHERE mantis_project_table.enabled = ? AND ( mantis_bug_table.project_id = 2 ) AND ( ( mantis_bug_table.status in (?, ?, ?, ?, ?, ?) ) AND ((mantis_custom_field_string_table_16.value LIKE ?)) ) .

Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.

TagsNo tags attached.
Attached Files
mantis-error.png (107,275 bytes)   
mantis-error.png (107,275 bytes)   

Relationships

duplicate of 0019670 closedvboctor View Issues page fails when a custom field is used for filtering and sorting 

Activities