Author Topic: OG 1.5 - 'Total Task Execution Time' Report Not working (SOLVED)  (Read 2388 times)

Villie

  • Newbie
  • *
  • Posts: 7
    • View Profile
I'm on FF3.5 with very recent PHP, mysql. Whenever i try to execute a 'Total Task Execution Time' Report I get a db qry error.

Session "default" started at 2009-07-31T07:46:27+0000
#1 DEBUG: SQL ERROR: Query failed with message 'Table 'cubiedesign.pr' doesn't exist' - SELECT `ts`.*, `ws0`.`name` AS `wsName0`, `ws0`.`id` AS `wsId0` FROM (`og_timeslots` AS `ts`, `og_project_tasks` AS `pt`, `og_projects` AS `pr`, `og_workspace_objects` AS `wo`) LEFT OUTER JOIN `pr` AS `ws0` ON `pr`.`p2` = `ws0`.`id` 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 `id` FROM `og_projects` WHERE (`p1` = 12 OR `p2` = 12 OR `p3` = 12 OR `p4` = 12 OR `p5` = 12 OR `p6` = 12 OR `p7` = 12 OR `p8` = 12 OR `p9` = 12 OR `p10` = 12) AND `id` IN (SELECT `og_project_users`.`project_id` FROM `og_project_users` WHERE ((`og_project_users`.`user_id` = '1') OR (`og_project_users`.`user_id` IN (SELECT `group_id` FROM `og_group_users` WHERE `og_group_users`.`user_id` = '1'))))) AND `ts`.`start_time` >= '2009-07-24 14:00:00'  AND (`ts`.`paused_on` <> 0 OR `ts`.`end_time` <> 0 AND `ts`.`end_time` < '2009-07-31 14:00:00')  ORDER BY `wsName0` ASC,  `start_time`
Time since start: 0.167913913727 seconds
-------------------------------------------------------------------------------

Looks like a table hasn't been renamed or renamed incorrectly during the manual upgrade from 1.4.1 since the table should probably be ...og_projects rather than ...pr

Any ideas?
« Last Edit: August 02, 2009, 06:41:27 am by Villie »

salival

  • Newbie
  • *
  • Posts: 18
    • View Profile
Re: OG 1.5 - 'Total Task Execution Time' Report Not working
« Reply #1 on: July 31, 2009, 05:52:41 am »
I had the same, or a similar, problem. I was given the following solution which worked for me:
http://forums.opengoo.org/index.php?topic=2278.0

Villie

  • Newbie
  • *
  • Posts: 7
    • View Profile
Re: OG 1.5 - 'Total Task Execution Time' Report Not working
« Reply #2 on: August 02, 2009, 06:40:53 am »
Thanks. That fixed it up.