guenther.ra...@gmx.de schrieb:
> Hi Renee,
>
> short question, is that right (u.login = ?...):
Yes, that's correct.
I have used your module, made the changes I proposed and everything runs
fine. So there seems to be another problem.
Do you have replaced the old module for your installation? Does you OTRS
instance run under mod_perl? If so, can you force Apache to reload the
stats module?
Cheers,
Renée
>
> $Self->{DBObject}->Prepare(SQL => "SELECT ta.create_by,
> ta.time_unit,
> ta.ticket_id,
> t.customer_id,
> u.login,
> t.title
> FROM ticket t, time_accounting ta,
> users u
> WHERE t.id = ta.ticket_id
> AND (ta.change_by = u.id
> AND (
> month(
> ta.change_time ) = $Month
> AND year(
> ta.change_time ) = $Year
> )
> AND (
> t.queue_id IN
> ( 5, 6, 8, 9, 10, 11, 12 )
> )
> AND (
> u.login = ?
> )
> )",
> Bind => [ \$User ],
> );
>
> Regards
> Günther
--
Perl-Magazin: http://perl-magazin.de
Perl-Nachrichten: http://perl-nachrichten.de
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/
