This problem exists at least from version 1.4.2
The invocation sequence is:
Time -> Print Report -> Select something -> Generate Report -> Print View
I get de message:
----
Error
Lo lamentamos, pero OpenGoo no es capaz de ejecutar su petición. Un informe de lo sucedido ha sido enviado al administrador.
----
The log.php says:
Session "default" started at 2009-08-31T12:08:43+0000
#1 DEBUG: SQL ERROR: Query failed with message 'Unknown column '' in 'order clause'' - SELECT `ts`.* FROM `og_timeslots` AS `ts`, `og_project_tasks` AS `pt`, `og_projects` AS `pr`, `og_workspace_objects` AS `wo` WHERE `ts`.`object_manager` = 'ProjectTasks' AND `pt`.`id` = `ts`.`object_id` AND `pt`.`trashed_by_id` = 0 AND `wo`.`object_manager` = 'ProjectTasks' AND `wo`.`object_id` = `ts`.`object_id` AND `wo`.`workspace_id` = `pr`.`id` AND `pr`.`id` IN (SELECT `og_project_users`.`project_id` FROM `og_project_users` WHERE ((`og_project_users`.`user_id` = '2') OR (`og_project_users`.`user_id` IN (SELECT `group_id` FROM `og_group_users` WHERE `og_group_users`.`user_id` = '2')))) AND `ts`.`start_time` >= '2009-08-31 15:08:44' AND (`ts`.`paused_on` <> 0 OR `ts`.`end_time` <> 0 AND `ts`.`end_time` < '2009-08-31 15:08:44') ORDER BY `` ASC, `` ASC, `` ASC, `start_time`
#2 FATAL: exception 'DBQueryError' with message 'Query failed with message 'Unknown column '' in 'order clause''' in /var/www/www.mysite.com.ar/html/goo/environment/library/database/adapters/AbstractDBAdapter.class.php:386
Stack trace:
#0 /var/www/www.mysite.com.ar/html/goo/environment/library/database/adapters/AbstractDBAdapter.class.php(304): AbstractDBAdapter->prepareAndExecute('SELECT `ts`.* F...', NULL)
#1 /var/www/www.mysite.com.ar/html/goo/environment/library/database/DB.class.php(209): AbstractDBAdapter->executeAll('SELECT `ts`.* F...', NULL)
#2 /var/www/www.mysite.com.ar/html/goo/application/models/timeslot/Timeslots.class.php(190): DB::executeAll('SELECT `ts`.* F...')
#3 /var/www/www.mysite.com.ar/html/goo/application/controllers/ReportingController.class.php(328): Timeslots::getTaskTimeslots(NULL, NULL, 'SELECT `og_proj...', Object(DateTimeValue), Object(DateTimeValue), 0, Array, NULL, 0, 0, 0)
#4 /var/www/www.mysite.com.ar/html/goo/application/controllers/ReportingController.class.php(372): ReportingController->total_task_times(Object(stdClass))
#5 /var/www/www.mysite.com.ar/html/goo/environment/classes/controller/Controller.class.php(76): ReportingController->total_task_times_print()
#6 /var/www/www.mysite.com.ar/html/goo/environment/classes/controller/PageController.class.php(62): Controller->execute('total_task_time...')
#7 /var/www/www.mysite.com.ar/html/goo/environment/classes/Env.class.php(173): PageController->execute('total_task_time...')
#8 /var/www/www.mysite.com.ar/html/goo/init.php(149): Env::executeAction('reporting', 'total_task_time...')
#9 /var/www/www.mysite.com.ar/html/goo/index.php(9): require('/var/www/www.in...')
#10 {main}
¿Any solution?
Regards.