User:AndreasMueller

From MediaWiki.org
Jump to navigation Jump to search

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