View Issue Details

IDProjectCategoryView StatusLast Update
0024688mantisbtapi soappublic2018-09-03 11:47
Reporterfatmanmclone90 Assigned To 
PrioritynormalSeveritymajorReproducibilityalways
Status newResolutionopen 
Product Version2.16.0 
Summary0024688: Undefined index on response to SOAP API mc_filter_get_issues
Description

Using the SOAP API endpoint 'mc_filter_get_issues' on Mantis BT 2.16.0.

Always getting an error response back from API:

Steps To Reproduce

SOAP contents:
<soapenv:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance&quot; xmlns:xsd="http://www.w3.org/2001/XMLSchema&quot; xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/&quot; xmlns:man="http://futureware.biz/mantisconnect&quot;>
<soapenv:Header/>
<soapenv:Body>
<man:mc_filter_get_issues soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/&quot;>
<username xsi:type="xsd:string">issue.tracker.api</username>
<password xsi:type="xsd:string">password</password>
<project_id xsi:type="xsd:integer">10000128</project_id>
<filter_id xsi:type="xsd:integer">835</filter_id>
<page_number xsi:type="xsd:integer">1</page_number>
<per_page xsi:type="xsd:integer">10</per_page>
</man:mc_filter_get_issues>
</soapenv:Body>
</soapenv:Envelope>

Additional Information

SYSTEM NOTICE,\nError Description: Undefined index: name\nStack Trace:\ncolumns_api.php L203 column_get_custom_field_column_name(<integer>1000002)\ncolumns_api.php L222 columns_get_custom_fields()\nfilter_api.php L623 columns_get_all_active_columns()\nfilter_api.php L1030 filter_ensure_valid_filter(<array> { ['_version'] => 'v9', ['_view_type'] => 'simple', ['category_id'] => <array> { [0] => 'Teacher; Vacancy or New Position Required' }, ['severity'] => <array> { [0] => 0 }, ['status'] => <array> { [0] => 0 }, ['per_page'] => 50, ['highlight_changed'] => 6, ['reporter_id'] => <array> { [0] => 0 }, ['handler_id'] => <array> { [0] => 0 }, ['project_id'] => <array> { [0] => -3 }, ['sort'] => 'last_updated', ['dir'] => 'DESC', ['filter_by_date'] => false, ['start_month'] => 8, ['start_day'] => 1, ['start_year'] => 2018, ['end_month'] => 8, ['end_day'] => 21, ['end_year'] => 2018, ['filter_by_last_updated_date'] => false, ['last_updated_start_month'] => 8, ['last_updated_start_day'] => 1, ['last_updated_start_year'] => 2018, ['last_updated_end_month'] => 8, ['last_updated_end_day'] => 21, ['last_updated_end_year'] => 2018, ['search'] => '', ['hide_status'] => <array> { [0] => 90 }, ['resolution'] => <array> { [0] => 0 }, ['build'] => <array> { [0] => '0' }, ['version'] => <array> { [0] => '0' }, ['fixed_in_version'] => <array> { [0] => '0' }, ['target_version'] => <array> { [0] => '0' }, ['priority'] => <array> { [0] => 0 }, ['monitor_user_id'] => <array> { [0] => 0 }, ['view_state'] => 0, ['custom_fields'] => <array> { [10000013] => <array> { [0] => '0' }, [10000012] => <array> { [0] => '0' }, [1] => <array> { [0] => '0' }, [2] => <array> { [0] => '0' }, [10000016] => <array> { [0] => '0' }, [3] => <array> { [0] => '0' }, [4] => <array> { [0] => '0' }, [7] => <array> { [0] => '0' }, [8] => <array> { [0] => '0' }, [9] => <array> { [0] => '0' }, [10] => <array> { [0] => '0' }, [10000015] => <array> { [0] => '0' }, [1000002] => <array> { [0] => '0' }, [1000003] => <array> { [0] => '0' }, [1000004] => <array> { [0] => '0' }, [10000010] => <array> { [0] => '0' } }, ['sticky'] => true, ['relationship_type'] => -1, ['relationship_bug'] => 0, ['profile_id'] => <array> { [0] => 0 }, ['platform'] => <array> { [0] => '0' }, ['os'] => <array> { [0] => '0' }, ['os_build'] => <array> { [0] => '0' }, ['tag_string'] => '', ['tag_select'] => 0, ['note_user_id'] => <array> { [0] => 0 }, ['match_type'] => 0 })\nfilter_api.php L3757 filter_deserialize(<string>'v9#{"_version":"v9","_view_type":"simple","category_id":["Teacher; Vacancy or New Position Required"],"severity":[0],"status":[0],"per_page":50,"highlight_changed":6,"reporter_id":[0],"handler_id":[0],"project_id":[-3],"sort":"last_updated","dir":"DESC","filter_by_date":false,"start_month":8,"start_day":1,"start_year":2018,"end_month":8,"end_day":21,"end_year":2018,"filter_by_last_updated_date":false,"last_updated_start_month":8,"last_updated_start_day":1,"last_updated_start_year":2018,"last_updated_end_month":8,"last_updated_end_day":21,"last_updated_end_year":2018,"search":"","hide_status":[90],"resolution":[0],"build":["0"],"version":["0"],"fixed_in_version":["0"],"target_version":["0"],"priority":[0],"monitor_user_id":[0],"view_state":0,"custom_fields":{"10000013":["0"],"10000012":["0"],"1":["0"],"2":["0"],"10000016":["0"],"3":["0"],"4":["0"],"7":["0"],"8":["0"],"9":["0"],"10":["0"],"10000015":["0"],"1000002":["0"],"1000003":["0"],"1000004":["0"],"10000010":["0"]},"sticky":true,"relationship_type":-1,"relationship_bug":0,"profile_id":[0],"platform":["0"],"os":["0"],"os_build":["0"],"tag_string":"","tag_select":0,"note_user_id":[0],"match_type":0}')\nmc_filter_api.php L176 filter_get(<string>'834')\nUnknownFile L? mc_filter_get_issues(<string>'issue.tracker.api', <string>'**', <string>'10000128', <string>'834', <string>'-1', <string>'-1')\nmantisconnect.php L89 handle()\nSYSTEM NOTICE,\nError Description: Undefined index: name\nStack Trace:\ncolumns_api.php L203 column_get_custom_field_column_name(<integer>1000002)\ncolumns_api.php L222 columns_get_custom_fields()\nfilter_api.php L623 columns_get_all_active_columns()\nfilter_api.php L1030 filter_ensure_valid_filter(<array> { ['_version'] => 'v9', ['_view_type'] => 'simple', ['category_id'] => <array> { [0] => 'Teacher; Vacancy or New Position Required' }, ['severity'] => <array> { [0] => 0 }, ['status'] => <array> { [0] => 0 }, ['per_page'] => 50, ['highlight_changed'] => 6, ['reporter_id'] => <array> { [0] => 0 }, ['handler_id'] => <array> { [0] => 0 }, ['project_id'] => <array> { [0] => -3 }, ['sort'] => 'last_updated', ['dir'] => 'DESC', ['filter_by_date'] => false, ['start_month'] => 8, ['start_day'] => 1, ['start_year'] => 2018, ['end_month'] => 8, ['end_day'] => 21, ['end_year'] => 2018, ['filter_by_last_updated_date'] => false, ['last_updated_start_month'] => 8, ['last_updated_start_day'] => 1, ['last_updated_start_year'] => 2018, ['last_updated_end_month'] => 8, ['last_updated_end_day'] => 21, ['last_updated_end_year'] => 2018, ['search'] => '', ['hide_status'] => <array> { [0] => 90 }, ['resolution'] => <array> { [0] => 0 }, ['build'] => <array> { [0] => '0' }, ['version'] => <array> { [0] => '0' }, ['fixed_in_version'] => <array> { [0] => '0' }, ['target_version'] => <array> { [0] => '0' }, ['priority'] => <array> { [0] => 0 }, ['monitor_user_id'] => <array> { [0] => 0 }, ['view_state'] => 0, ['custom_fields'] => <array> { [10000013] => <array> { [0] => '0' }, [10000012] => <array> { [0] => '0' }, [1] => <array> { [0] => '0' }, [2] => <array> { [0] => '0' }, [10000016] => <array> { [0] => '0' }, [3] => <array> { [0] => '0' }, [4] => <array> { [0] => '0' }, [7] => <array> { [0] => '0' }, [8] => <array> { [0] => '0' }, [9] => <array> { [0] => '0' }, [10] => <array> { [0] => '0' }, [10000015] => <array> { [0] => '0' }, [1000002] => <array> { [0] => '0' }, [1000003] => <array> { [0] => '0' }, [1000004] => <array> { [0] => '0' }, [10000010] => <array> { [0] => '0' } }, ['sticky'] => true, ['relationship_type'] => -1, ['relationship_bug'] => 0, ['profile_id'] => <array> { [0] => 0 }, ['platform'] => <array> { [0] => '0' }, ['os'] => <array> { [0] => '0' }, ['os_build'] => <array> { [0] => '0' }, ['tag_string'] => '', ['tag_select'] => 0, ['note_user_id'] => <array> { [0] => 0 }, ['match_type'] => 0 })\nfilter_api.php L3757 filter_deserialize(<string>'v9#{"_version":"v9","_view_type":"simple","category_id":["Teacher; Vacancy or New Position Required"],"severity":[0],"status":[0],"per_page":50,"highlight_changed":6,"reporter_id":[0],"handler_id":[0],"project_id":[-3],"sort":"last_updated","dir":"DESC","filter_by_date":false,"start_month":8,"start_day":1,"start_year":2018,"end_month":8,"end_day":21,"end_year":2018,"filter_by_last_updated_date":false,"last_updated_start_month":8,"last_updated_start_day":1,"last_updated_start_year":2018,"last_updated_end_month":8,"last_updated_end_day":21,"last_updated_end_year":2018,"search":"","hide_status":[90],"resolution":[0],"build":["0"],"version":["0"],"fixed_in_version":["0"],"target_version":["0"],"priority":[0],"monitor_user_id":[0],"view_state":0,"custom_fields":{"10000013":["0"],"10000012":["0"],"1":["0"],"2":["0"],"10000016":["0"],"3":["0"],"4":["0"],"7":["0"],"8":["0"],"9":["0"],"10":["0"],"10000015":["0"],"1000002":["0"],"1000003":["0"],"1000004":["0"],"10000010":["0"]},"sticky":true,"relationship_type":-1,"relationship_bug":0,"profile_id":[0],"platform":["0"],"os":["0"],"os_build":["0"],"tag_string":"","tag_select":0,"note_user_id":[0],"match_type":0}')\nmc_filter_api.php L176 filter_get(<string>'834')\nUnknownFile L? mc_filter_get_issues(<string>'issue.tracker.api', <string>'**', <string>'10000128', <string>'834', <string>'-1', <string>'-1')\nmantisconnect.php L89 handle()\n

TagsNo tags attached.

Activities

dregad

dregad

2018-08-22 06:55

developer   ~0060474

Your filter (id 834) includes custom fields:
&quot;custom_fields&quot;:{&quot;10000013&quot;:[&quot;0&quot;],&quot;10000012&quot;:[&quot;0&quot;],&quot;1&quot;:[&quot;0&quot;],&quot;2&quot;:[&quot;0&quot;],&quot;10000016&quot;:[&quot;0&quot;],&quot;3&quot;:[&quot;0&quot;],&quot;4&quot;:[&quot;0&quot;],&quot;7&quot;:[&quot;0&quot;],&quot;8&quot;:[&quot;0&quot;],&quot;9&quot;:[&quot;0&quot;],&quot;10&quot;:[&quot;0&quot;],&quot;10000015&quot;:[&quot;0&quot;],&quot;1000002&quot;:[&quot;0&quot;],&quot;1000003&quot;:[&quot;0&quot;],&quot;1000004&quot;:[&quot;0&quot;],&quot;10000010&quot;:[&quot;0&quot;]}

Looks like Mantis is choking because of custom fields with id 1000002 (from the stack trace: columns_api.php L203 column_get_custom_field_column_name(&lt;integer>1000002))

Check this custom field's definition.

fatmanmclone90

fatmanmclone90

2018-08-23 08:58

reporter   ~0060479

So that's what I thought, but I don't have a custom field with that id

MariaDB [customercare_ng_la]> select * from mantis_custom_field_table where id = 1000002;
Empty set (0.00 sec)

I wonder how the filter is referencing a field which doesn't exist?

dregad

dregad

2018-08-23 11:55

developer   ~0060480

I wonder how the filter is referencing a field which doesn't exist?

Beats me.
Is this effectively how the filter is defined in the mantis_filters_table ? Does it work properly in the GUI ?
Maybe the filter is corrupted ?

fatmanmclone90

fatmanmclone90

2018-09-03 11:24

reporter   ~0060592

Yes it works via the GUI, every filter I create has the same issues.

atrol

atrol

2018-09-03 11:47

developer   ~0060593

Hardly related to this bug, but it's a bit strange to see that your project_id is 10000128.
Do you have that many projects?