Hi all,
We are having some problems with Opengoo 1.7-rc.
Browser: Mozilla Firefox 3.6.4
I am not sure what the version of the PHP and MySQL is as I am using XAMPP ver 1.7.3
Below is the complete description of the problem and the log of the error.
Reports fail when using ‘workspace’ as a “Condition” or “Order by” criteria
As Condition:
1) When creating a report with Workspace as a condition, we are unable to set a specific workspace (no dropdown is selected)
2) If we set the condition as a parameter, we are able to create the report but get “Error: Syntax Error” popping-up at the top screen when viewing the report. No data is shown in the report.
As Order By:
1) We created a report with the following parameters:
Object Type = Task
Order By = workspace, descending
Columns to Print = Title, Estimate
2) When viewing the report, we get the error: “We are sorry, but Feng Office is not currently able to execute your request. An Error Report has been sent to the administrator.”
3) If you edit the report, you see that the fields have changed, it now has Assigned to User, Workspace added
I copy-pasted the content of the log.php below:
<?php die(); ?>
Session "default" started at 2010-05-19T06:37:25+0000
#1 DEBUG: SQL ERROR: Query failed with message 'Unknown column 't.workspace' in 'order clause'' - SELECT distinct(t.id) as "id", t.title as "titleCol0", t.title, t.text, t.milestone_id, t.time_estimate FROM (og_project_tasks t ) WHERE ( ( `created_by_id` = 13)
OR ( EXISTS ( SELECT * FROM `og_object_user_permissions` `xx_oup`
WHERE `xx_oup`.`rel_object_id` = t.id
AND `xx_oup`.`rel_object_manager` = 'ProjectTasks'
AND `xx_oup`.`user_id` IN (13,10000001,10000006,10000009,10000010)
AND `xx_oup`.can_read = true) )
OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo`
WHERE `xx_pu`.`user_id` IN (13,10000001,10000006,10000009,10000010)
AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id`
AND `xx_wo`.`object_id` = t.id
AND `xx_wo`.`object_manager` = 'ProjectTasks'
AND `xx_pu`.can_read_tasks = true ) ) ) AND t.trashed_by_id = 0 GROUP BY id ORDER BY t.workspace desc LIMIT 0,50
Time since start: 1.4362609386444 seconds
-------------------------------------------------------------------------------
Session "default" started at 2010-05-19T06:42:14+0000
#1 DEBUG: SQL ERROR: Query failed with message 'Unknown column 't.workspace' in 'order clause'' - SELECT distinct(t.id) as "id", t.title as "titleCol0", t.title, t.text, t.milestone_id, t.time_estimate FROM (og_project_tasks t ) WHERE ( ( `created_by_id` = 13)
OR ( EXISTS ( SELECT * FROM `og_object_user_permissions` `xx_oup`
WHERE `xx_oup`.`rel_object_id` = t.id
AND `xx_oup`.`rel_object_manager` = 'ProjectTasks'
AND `xx_oup`.`user_id` IN (13,10000001,10000006,10000009,10000010)
AND `xx_oup`.can_read = true) )
OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo`
WHERE `xx_pu`.`user_id` IN (13,10000001,10000006,10000009,10000010)
AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id`
AND `xx_wo`.`object_id` = t.id
AND `xx_wo`.`object_manager` = 'ProjectTasks'
AND `xx_pu`.can_read_tasks = true ) ) ) AND t.trashed_by_id = 0 GROUP BY id ORDER BY t.workspace desc LIMIT 0,50
Time since start: 1.269161939621 seconds
-------------------------------------------------------------------------------
