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" <mailinglis...@renee-baecker.de>
> An: "User questions and discussions about OTRS." <otrs@otrs.org>
> Betreff: Re: [otrs] Stats-Module and problems with @Params
> 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/
--
Neu: GMX Doppel-FLAT mit Internet-Flatrate + Telefon-Flatrate
für nur 19,99 Euro/mtl.!* http://portal.gmx.net/de/go/dsl02
---------------------------------------------------------------------
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/
