1.5 - error when trying to group by workspace in time report (solved)

[salival]

When I try to group a 'Total task execution time' report by workspace it fails. Grouping by any other option works though.

In debug mode it gives me the following error: Query failed with message 'Table 'opengoo3.pr' doesn't exist'. Opengoo3 is the database name I gave at setup.

[ignacio]

Hi,

Try changing line 106 of 'application/models/timeslot/Timeslots.class.php' from:

Code: [Select]

$postFrom .= ") LEFT OUTER JOIN `pr` AS `ws" . $i . "` ON `pr`.`p" . ($wsDepth + $i + 1) . "` = `ws" . $i . "`.`id`";
to:

Code: [Select]

$postFrom .= ") LEFT OUTER JOIN `".TABLE_PREFIX."projects` AS `ws" . $i . "` ON `pr`.`p" . ($wsDepth + $i + 1) . "` = `ws" . $i . "`.`id`";
(Changed the first `pr` for `".TABLE_PREFIX."projects`)

[salival]

Solved it, thank you.

(although it was timeslotS.class.php  )

[ignacio]

Ooopsie! Corrected it