Feng Forum

Support => Older versions => : salival July 28, 2009, 10:59:05 AM

: 1.5 - error when trying to group by workspace in time report (solved)
: salival July 28, 2009, 10:59:05 AM

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.

: Re: 1.5 - error when trying to group by workspace in time report
: ignacio July 29, 2009, 12:24:26 PM

Hi,

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

:

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

:

$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`)

: Re: 1.5 - error when trying to group by workspace in time report
: salival July 29, 2009, 12:43:03 PM

Solved it, thank you.

(although it was timeslotS.class.php  ;) )

: Re: 1.5 - error when trying to group by workspace in time report
: ignacio July 29, 2009, 03:37:36 PM

Ooopsie! Corrected it :)