| Description | When the /plugin.php?page=MantisGraph/issues_trend_graph.php page is opened, the following error is displayed:
APPLICATION ERROR 401
Database query failed. Error received from database was #0: 0 for the query: SELECT
FLOOR(date_submitted / 86400) date_index,
COUNT(*) num
FROM mantis_bug_table
WHERE project_id=1 AND mantis_bug_table.id IN (SELECT mantis_bug_table.id FROM mantis_bug_table JOIN mantis_project_table ON mantis_project_table.id = mantis_bug_table.project_id WHERE mantis_project_table.enabled = ? AND (mantis_bug_table.project_id = ?)) GROUP BY date_index.
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.
Detailed error information
Full path: C:\Projects\mantisbt\core\classes\DbQuery.class.php
Line number: 298
Stack trace
# Filename Line Class Type Function Args
0 C:\Projects\mantisbt\core\classes\DbQuery.class.php 298 - - trigger_error <string>'401', <integer>256
1 C:\Projects\mantisbt\core\classes\DbQuery.class.php 257 DbQuery -> db_execute <NULL>NULL, <NULL>NULL
2 C:\Projects\mantisbt\core\classes\DbQuery.class.php 811 DbQuery -> execute -
3 C:\Projects\mantisbt\plugins\MantisGraph\core\graph_api.php 512 DbQuery -> fetch -
4 C:\Projects\mantisbt\plugins\MantisGraph\pages\issues_trend_graph.php 50 - - create_cumulative_bydate <array> { ['_version'] => 'v9', ['_view_type'] => 'simple', ['category_id'] => <array> { [0] => '0' }, ['severity'] => <array> { [0] => 0 }, ['status'] => <array> { [0] => 0 }, ['highlight_changed'] => 6, ['reporter_id'] => <array> { [0] => 0 }, ['handler_id'] => <array> { [0] => 0 }, ['project_id'] => <array> { [0] => -3 }, ['projection'] => <array> { [0] => 0 }, ['resolution'] => <array> { [0] => 0 }, ['build'] => <array> { [0] => '0' }, ['version'] => <array> { [0] => '0' }, ['hide_status'] => <array> { [0] => -2 }, ['monitor_user_id'] => <array> { [0] => 0 }, ['sort'] => 'last_updated', ['dir'] => 'DESC', ['per_page'] => 50, ['match_type'] => 0, ['platform'] => <array> { [0] => '0' }, ['os'] => <array> { [0] => '0' }, ['os_build'] => <array> { [0] => '0' }, ['fixed_in_version'] => <array> { [0] => '0' }, ['target_version'] => <array> { [0] => '0' }, ['profile_id'] => <array> { [0] => 0 }, ['priority'] => <array> { [0] => 0 }, ['note_user_id'] => <array> { [0] => 0 }, ['sticky'] => true, ['filter_by_date'] => false, ['start_month'] => '03', ['end_month'] => '03', ['start_day'] => 1, ['end_day'] => '07', ['start_year'] => '2025', ['end_year'] => '2025', ['filter_by_last_updated_date'] => false, ['last_updated_start_month'] => '03', ['last_updated_end_month'] => '03', ['last_updated_start_day'] => 1, ['last_updated_end_day'] => '07', ['last_updated_start_year'] => '2025', ['last_updated_end_year'] => '2025', ['search'] => '', ['view_state'] => 0, ['tag_string'] => '', ['tag_select'] => 0, ['relationship_type'] => -1, ['relationship_bug'] => 0, ['custom_fields'] => <array> { } }
5 C:\Projects\mantisbt\plugin.php 74 - - include <string>'C:\\Projects\\mantisbt\\plugins\\MantisGraph\\pages\\issues_trend_graph.php'
All other pages of MantisGraph work fine.
This only happens on PHP 7.4, everything displays fine on PHP 8.3. |
|---|
| Additional Information | Debug Log has the one additional event in the PHP 8.4 that is missing in the PHP 7.4 case:
DB graph_api.php:552 create_cumulative_bydate() array (
0 => 'SELECT
FLOOR(COALESCE(max_date_modified, last_updated) / 86400 ) date_index,
COUNT(*) num
FROM mantis_bug_table
LEFT JOIN(
SELECT bug_id, MAX(date_modified) max_date_modified
FROM mantis_bug_history_table
WHERE field_name = \'status\' AND new_value >= \'80\' AND old_value < \'80\'
GROUP BY bug_id
) hist ON hist.bug_id =mantis_bug_table.id
WHERE project_id=1
AND mantis_bug_table.status >= 80 AND mantis_bug_table.id IN (SELECT mantis_bug_table.id FROM mantis_bug_table JOIN mantis_project_table ON mantis_project_table.id = mantis_bug_table.project_id WHERE mantis_project_table.enabled = \'1\' AND (mantis_bug_table.project_id = 1)) GROUP BY date_index',
1 => '0.0002',
)
Empty database, one project (id=1), no issues. Branch: master. |
|---|
