User:AndreasMueller

Andreas,

Hoping you can assist on this one. I've setup according you your docs and as far as reaching the DB is concerned it's ok. The problem we are having lies in our MySQL being case sensitive (RHEL5.5 running 5.0.77 mysql) the error is as follows (including dbug output)  At this point I'm just using the setup examples in your description page to "get" the data for the chart.

MySQL Error:1054 - Unknown column 'bugs3.Priority.value' in 'group statement'

extractOptions:report_id=priority extractOptions:run_id=4 extractOptions:chart=pie setDefaults:zebra=true setDefaults:total=true setDefaults:sortable=false setDefaults:debug=true setDefaults:hidetable=false setDefaults:chartheight=120 setDefaults:chartwidth=auto setDefaults:nudechart=false setDefaults:chartpos=right setDefaults:chartlayout=vertical setDefaults:showhide=false setDefaults:hidden=false setDefaults:title=true setDefaults:roundperc=0 extractOptions:report_id=priority extractOptions:run_id=4 extractOptions:chart=pie setDefaults:zebra=true setDefaults:total=true setDefaults:sortable=false setDefaults:debug=true setDefaults:hidetable=false setDefaults:chartheight=120 setDefaults:chartwidth=auto setDefaults:nudechart=false setDefaults:chartpos=right setDefaults:chartlayout=vertical setDefaults:showhide=false setDefaults:hidden=false setDefaults:title=true setDefaults:roundperc=0 SELECT bugs3.priority.value AS 'Priority', bugs3.test_case_run_status.name AS 'Status' , count(distinct bugs3.test_case_runs.case_id) AS 'Count' FROM bugs3.test_cases INNER JOIN bugs3.test_case_runs ON bugs3.test_case_runs.case_id = bugs3.test_cases.case_id INNER JOIN bugs3.priority ON bugs3.priority.id = bugs3.test_cases.priority_id INNER JOIN bugs3.test_case_run_status ON bugs3.test_case_run_status.case_run_status_id = bugs3.test_case_runs.case_run_status_id WHERE bugs3.test_case_runs.run_id=4 GROUP BY bugs3.Priority.value, bugs3.priority.value