I just copied all the files over to the web server. I ran teh configurator and copied the file to the server. Then I got this erro when I tried to go to the main page.
I am on linux and running Mysql 3.22.32.
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=1064 ** You have an error in your SQL syntax near 'when resolution_id = 0 then 1 else 0 end) as "Open", sum(case when resolution_id' at line 1]
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I made config.php writeable to the webserver and now I get:
DB Error: syntax error
SELECT sum(CASE WHEN s.status_id in (1, 2, 3, 4) THEN 1 ELSE 0 END ) , sum(CASE WHEN s.status_id not in (1, 2, 3, 4) THEN 1 ELSE 0 END ) from phpbt_bug b left join phpbt_status s using(status_id) where assigned_to = 1 [nativecode=1064 ** You have an error in your SQL syntax near 'WHEN s.status_id in (1, 2, 3, 4) THEN 1 ELSE 0 END ) , sum(CASE WHEN s.status_id' at line 1]
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
by the way could project admins finally note the minimum version number for MySQL in the README or somewhere because I had the same problem. Listing required software with version numbers is IMHO state-of-the-art in open source.
regards, FL
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I just copied all the files over to the web server. I ran teh configurator and copied the file to the server. Then I got this erro when I tried to go to the main page.
I am on linux and running Mysql 3.22.32.
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=1064 ** You have an error in your SQL syntax near 'when resolution_id = 0 then 1 else 0 end) as "Open", sum(case when resolution_id' at line 1]
I made config.php writeable to the webserver and now I get:
DB Error: syntax error
SELECT sum(CASE WHEN s.status_id in (1, 2, 3, 4) THEN 1 ELSE 0 END ) , sum(CASE WHEN s.status_id not in (1, 2, 3, 4) THEN 1 ELSE 0 END ) from phpbt_bug b left join phpbt_status s using(status_id) where assigned_to = 1 [nativecode=1064 ** You have an error in your SQL syntax near 'WHEN s.status_id in (1, 2, 3, 4) THEN 1 ELSE 0 END ) , sum(CASE WHEN s.status_id' at line 1]
You need to upgrade your mysql to at least the 3.23.x series.
by the way could project admins finally note the minimum version number for MySQL in the README or somewhere because I had the same problem. Listing required software with version numbers is IMHO state-of-the-art in open source.
regards, FL