APPLICATION ERROR #401
Sikertelen adatbázis-lekérdezés. Az adatbázis hibaüzenete: #-1: ERROR: could not determine data type of parameter $1 a következő lekérdezéshez: SELECT p.id, p.name, ph.parent_id
FROM mantis_project_table p
LEFT JOIN mantis_project_user_list_table u
ON p.id=u.project_id AND u.user_id=$2
LEFT JOIN mantis_project_hierarchy_table ph
ON ph.child_id = p.id
WHERE p.enabled = $3 AND
( p.view_state=$4
OR (p.view_state=$5
AND
u.user_id=$6 )
) ORDER BY p.name
Kérjük, használja a böngészője "Vissza" gombját az előző oldalhoz való visszatéréshez. Ott kijavíthatja az imént felismert hibákat, vagy más műveletet választhat. A menüből szintén választhat egy pontot, ha közvetlenül az adott funkcióhoz szeretne jutni.
| Full path: /home/aegon/prd/mantis/core/database_api.php |
| Line: 469 |
| Variable | Value | Type |
|---|
| p_query | SELECT p.id, p.name, ph.parent_id
FROM mantis_project_table p
LEFT JOIN mantis_project_user_list_table u
ON p.id=u.project_id AND u.user_id=$2
LEFT JOIN mantis_project_hierarchy_table ph
ON ph.child_id = p.id
WHERE p.enabled = $3 AND
( p.view_state=$4
OR (p.view_state=$5
AND
u.user_id=$6 )
) ORDER BY p.name | string |
| p_limit | -1 | integer |
| p_offset | -1 | integer |
| g_db_log_queries | | boolean |
| t_db_type | pgsql | string |
| s_check_params | 1 | boolean |
| t_start | 1452023715.1661 | double |
| t_params | 5 | integer |
| i | 5 | integer |
| s_prefix | mantis_ | string |
| s_suffix | _table | string |
| p_off | 0 | integer |
| t_query | SELECT p.id, p.name, ph.parent_id
FROM mantis_project_table p
LEFT JOIN mantis_project_user_list_table u
ON p.id=u.project_id AND u.user_id=$1
LEFT JOIN mantis_project_hierarchy_table ph
ON ph.child_id = p.id
WHERE p.enabled = $2 AND
( p.view_state=$3
OR (p.view_state=$4
AND
u.user_id=$5 )
) ORDER BY p.name | string |
| t_result | | boolean |
| t_elapsed | 0.0004 | string |
p_arr_parms | | Variable | Value | Type |
|---|
| 0 | 180 | integer |
| 1 | 1 | boolean |
| 2 | 10 | integer |
| 3 | 50 | integer |
| 4 | 180 | integer |
| g_queries_array | | Variable | Value | Type |
|---|
1 | | Variable | Value | Type |
|---|
| 0 | | string |
| 1 | 0.0012 | string |
| 2 | | Variable | Value | Type |
|---|
| 0 | | string |
| 1 | 0.0005 | string |
| 3 | | Variable | Value | Type |
|---|
| 0 | | string |
| 1 | 0.0004 | string |
| 4 | | Variable | Value | Type |
|---|
| 0 | | string |
| 1 | 0.0006 | string |
| 5 | | Variable | Value | Type |
|---|
| 0 | | string |
| 1 | 0.0004 | string |
| 6 | | Variable | Value | Type |
|---|
| 0 | | string |
| 1 | 0.0004 | string |
| 7 | | Variable | Value | Type |
|---|
| 0 | | string |
| 1 | 0.0006 | string |
| 8 | | Variable | Value | Type |
|---|
| 0 | | string |
| 1 | 0.0017 | string |
| 9 | | Variable | Value | Type |
|---|
| 0 | | string |
| 1 | 0.0004 | string |
|
| t_matches | | t_res | | Variable | Value | Type |
|---|
| 0 | SELECT p.id, p.name, ph.parent_id
FROM mantis_project_table p
LEFT JOIN mantis_project_user_list_table u
ON p.id=u.project_id AND u.user_id=$1 | string |
| 1 |
LEFT JOIN mantis_project_hierarchy_table ph
ON ph.child_id = p.id
WHERE p.enabled = $2 | string |
| 2 | AND
( p.view_state=$3 | string |
| 3 |
OR (p.view_state=$4 | string |
| 4 |
AND
u.user_id=$5 | string |
| |
| Filename | Line | | | Function | Args |
|---|
| /home/aegon/prd/mantis/core/database_api.php | 469 | - | - | trigger_error | ( <string>'401', <integer>256 ) |
| /home/aegon/prd/mantis/core/user_api.php | 991 | - | - | db_query | ( <string>'SELECT p.id, p.name, ph.parent_id
FROM {project} p
LEFT JOIN {project_user_list} u
ON p.id=u.project_id AND u.user_id=$2
LEFT JOIN {project_hierarchy} ph
ON ph.child_id = p.id
WHERE p.enabled = $3 AND
( p.view_state=$4
OR (p.view_state=$5
AND
u.user_id=$6 )
) ORDER BY p.name', <array> { [0] => 180, [1] => true, [2] => 10, [3] => 50, [4] => 180 } ) |
| /home/aegon/prd/mantis/core/filter_api.php | 1196 | - | - | user_get_accessible_projects | ( <integer>180 ) |
| /home/aegon/prd/mantis/view_all_bug_page.php | 71 | - | - | filter_get_bug_rows | ( <integer>1, <NULL>NULL, <NULL>NULL, <NULL>NULL, <NULL>NULL, <NULL>NULL, <NULL>NULL, <boolean>true ) |