View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006143 | mantisbt | sql | public | 2005-08-15 17:08 | 2005-09-11 08:12 |
| Reporter | Fredy | Assigned To | thraxisp | ||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | duplicate | ||
| Product Version | 1.0.0rc1 | ||||
| Summary | 0006143: PostgreSQL: relation "pft" does not exist | ||||
| Description | When i want display Project Documentation a get some database error. I have turned on debugging and problematic SQL query put into phpPgAdmin and i get error in subject. Output of debug is attached. | ||||
| Tags | No tags attached. | ||||
| Attached Files | debug.log (3,356 bytes)
Full path: /var/www/devel/mantis/core/database_api.php Line: 128 Variable Value Type p_query SELECT pft.id, pft.project_id, pft.filename, pft.filesize, pft.title, pft.description, pft.date_added FROM mantis_project_file_table pft, mantis_user_table ut LEFT JOIN mantis_project_table pt on pft.project_id = pt.id LEFT JOIN mantis_project_user_list_table as pult on pft.project_id = pult.project_id and pult.user_id = 2 WHERE ut.id = 2 AND pft.project_id in (2,0) AND ( pt.view_state = 10 OR pt.view_state is null OR ( pt.view_state = 50 and pult.user_id = 2 ) OR ( pult.user_id is null and ut.access_level >= 0 ) ) ORDER BY pt.name ASC, pft.title ASC string p_limit -1 string p_offset -1 string t_start 1124139527.58 string t_result string t_elapsed 0.0016 string g_queries_array Variable Value Type 1 Variable Value Type 0 SELECT id FROM mantis_user_table WHERE cookie_string='e7bb51641dc9a1ee67dd97d4119c5b57b4f0a456eaf1199e0284f78fe8adfe26' string 1 0.0014 string 2 Variable Value Type 0 SELECT * FROM mantis_user_pref_table WHERE user_id='2' AND project_id='0' string 1 0.0029 string 3 Variable Value Type 0 SELECT * FROM mantis_project_table WHERE id='2' string 1 0.0022 string 4 Variable Value Type 0 SELECT * FROM mantis_user_table WHERE id='2' string 1 0.0017 string 5 Variable Value Type 0 SELECT config_id, user_id, project_id, type, value, access_reqd FROM mantis_config_table string 1 0.0020 string 6 Variable Value Type 0 SELECT pft.id, pft.project_id, pft.filename, pft.filesize, pft.title, pft.description, pft.date_added FROM mantis_project_file_table pft, mantis_user_table ut LEFT JOIN mantis_project_table pt on pft.project_id = pt.id LEFT JOIN mantis_project_user_list_table as pult on pft.project_id = pult.project_id and pult.user_id = 2 WHERE ut.id = 2 AND pft.project_id in (2,0) AND ( pt.view_state = 10 OR pt.view_state is null OR ( pt.view_state = 50 and pult.user_id = 2 ) OR ( pult.user_id is null and ut.access_level >= 0 ) ) ORDER BY pt.name ASC, pft.title ASC string 1 0.0016 string 7 Variable Value Type 0 SELECT * FROM mantis_project_table string 1 0.0013 string 8 Variable Value Type 0 SELECT DISTINCT p.id, ph.parent_id, p.name FROM mantis_project_table p LEFT JOIN mantis_project_hierarchy_table ph ON ph.child_id = p.id WHERE p.enabled = 1 ORDER BY p.name string 1 0.0030 string 9 Variable Value Type 0 SELECT DISTINCT p.id, p.name, ph.parent_id FROM mantis_project_table p LEFT JOIN mantis_project_hierarchy_table ph ON ph.child_id = p.id WHERE p.enabled = 1 AND ph.parent_id IS NOT NULL ORDER BY p.name string 1 0.0018 string Filename Line Function Args /var/www/devel/mantis/core/database_api.php 128 trigger_error ( '401', 256 ) /var/www/devel/mantis/proj_doc_page.php 64 db_query ( 'SELECT pft.id, pft.project_id, pft.filename, pft.filesize, pft.title, pft.description, pft.date_added FROM mantis_project_file_table pft, mantis_user_table ut LEFT JOIN mantis_project_table pt on pft.project_id = pt.id LEFT JOIN mantis_project_user_list_table as pult on pft.project_id = pult.project_id and pult.user_id = 2 WHERE ut.id = 2 AND pft.project_id in (2,0) AND ( pt.view_state = 10 OR pt.view_state is null OR ( pt.view_state = 50 and pult.user_id = 2 ) OR ( pult.user_id is null and ut.access_level >= 0 ) ) ORDER BY pt.name ASC, pft.title ASC' ) | ||||
