Re: [otrs] Stats-Module and problems with @Params

26 Aug 2009

      Hi Renee,

thank you. Yes it´s running under mod_perl, it seems
to be working:

[Wed Aug 26 09:44:33 2009] AccountingPerAgent.pm: Subroutine Run redefined at /opt/otrs//Kernel/System/Stats/Static/AccountingPerAgent.pm line 109.
[Wed Aug 26 09:45:43 2009] AccountingPerAgent.pm: Subroutine new redefined at /opt/otrs//Kernel/System/Stats/Static/AccountingPerAgent.pm line 17.
[Wed Aug 26 09:45:43 2009] AccountingPerAgent.pm: Subroutine Param redefined at /opt/otrs//Kernel/System/Stats/Static/AccountingPerAgent.pm line 38.
[Wed Aug 26 09:45:43 2009] AccountingPerAgent.pm: Subroutine Run redefined at /opt/otrs//Kernel/System/Stats/Static/AccountingPerAgent.pm line 109.

I´ve restarte Apache, but still the csv-file is empty, but no
logging entry in /var/log/otrs.log anymore...!

Regards
Guenther

-------- Original-Nachricht --------
...
Datum: Wed, 26 Aug 2009 09:47:15 +0200
Von: "Renee Bäcker" 
An: "User questions and discussions about OTRS." 
Betreff: Re: [otrs] Stats-Module and problems with @Params
...
guenther.rasch@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/
-- 
Neu: GMX Doppel-FLAT mit Internet-Flatrate + Telefon-Flatrate
für nur 19,99 Euro/mtl.!* http://portal.gmx.net/de/go/dsl02

Re: [otrs] Stats-Module and problems with @Params

guenther.rasch＠gmx.de