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 ) |