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?