Right after I installed and first logged in I got this (I have postgres 7.1 I am pretty sure)
DB Error: unknown error
select project_name as "Project", sum(case when resolution_id = 0 then 1 else 0 end) as "Open", sum(case when resolution_id = 1 then 1 else 0 end) as "Fixed", sum(case when resolution_id = 2 then 1 else 0 end) as "Not a bug", sum(case when resolution_id = 3 then 1 else 0 end) as "Won't Fix", sum(case when resolution_id = 4 then 1 else 0 end) as "Deferred", sum(case when resolution_id = 5 then 1 else 0 end) as "Works for me", sum(case when resolution_id = 6 then 1 else 0 end) as "Duplicate", count(bug_id) as "Total" from phpbt_bug b left join phpbt_project p using (project_id) where b.project_id not in (0) group by b.project_id, project_name order by project_name [nativecode=ERROR: OUTER JOIN is not yet supported ]
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Ok well either this is a bug or the documentation needs to be changed as it says on the website:
A database server. phpBugTracker has been tested with MySQL, PostgreSQL (>= 7.1 required) and Oracle 8. If you wish to run this package on another type of database, I am more than willing to support more types of databases if you are willing to help with testing.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Right after I installed and first logged in I got this (I have postgres 7.1 I am pretty sure)
DB Error: unknown error
select project_name as "Project", sum(case when resolution_id = 0 then 1 else 0 end) as "Open", sum(case when resolution_id = 1 then 1 else 0 end) as "Fixed", sum(case when resolution_id = 2 then 1 else 0 end) as "Not a bug", sum(case when resolution_id = 3 then 1 else 0 end) as "Won't Fix", sum(case when resolution_id = 4 then 1 else 0 end) as "Deferred", sum(case when resolution_id = 5 then 1 else 0 end) as "Works for me", sum(case when resolution_id = 6 then 1 else 0 end) as "Duplicate", count(bug_id) as "Total" from phpbt_bug b left join phpbt_project p using (project_id) where b.project_id not in (0) group by b.project_id, project_name order by project_name [nativecode=ERROR: OUTER JOIN is not yet supported ]
I believe that left joins are supported only in postgres versions 7.3 and later
Ok well either this is a bug or the documentation needs to be changed as it says on the website:
A database server. phpBugTracker has been tested with MySQL, PostgreSQL (>= 7.1 required) and Oracle 8. If you wish to run this package on another type of database, I am more than willing to support more types of databases if you are willing to help with testing.
Well, why don't you find out (for sure) what version you are running. I do think it works with 7.1, but I'm running 7.2.
I just checked and my development server was 7.0 and production was 7.1, so I appologize for wasting your time. Thanks for your helpfulness!