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

26 Aug 2009

      Hi Renee,

sorry, did:

sub Param {
...
    my %UserList = $Self->{UserObject}->UserList(
        Type => 'Short',
        Valid => 0,
    );

    push (@Params, {
            Frontend => 'User',
            Name => 'UserList',
            Multiple => 0,
            Size => 0,
            #SelectedID => $U,
            Data => {
                %UserList,
            },
        },
    );
}

sub Run {
...
    my $User = $Param{UserList};
...
}

but it still doesn´t work... /var/log/otrs.log:

[Wed Aug 26 09:26:28 2009][Error][Kernel::System::Stats::Static::AccountingPerAgent::Run][145] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
                                )' at line 19, 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 ) = 7
                                                AND year( ta.change_time ) = 2009
                                        )
                                        AND (
                                                t.queue_id IN ( 5, 6, 8, 9, 10, 11, 12 )
                                        )
                                        AND (
                                                u.login =
                                        )
                                )'

-------- Original-Nachricht --------
...
Datum: Wed, 26 Aug 2009 09:18:31 +0200
Von: "Renee Bäcker" 
An: "User questions and discussions about OTRS." 
Betreff: Re: [otrs] Stats-Module and problems with @Params
...
Hi Guenther,
you already posted the code where you defined the Variable %UserList,
but that is irrelevant. The important part for the HTML form creation is
what's in @Params.
There you have
...
push (@Params, {
            Frontend => 'User',
            Name => 'User',
            Multiple => 0,
            Size => 0,
            Data => {
                %UserList,
            },
        },
    );
This adds a field to the form where the field has a label 'User'
(Frontend => 'User'). The name of the field is also 'User' (Name =>
'User'). The is the name of the parameter that the request sends to the
script.
You have two ways to make your script work:
Either
push @Params, {
    Frontend => 'User',
    Name => 'UserList',
    ...
}
*OR*
my $User = $Params{User};
Cheers,
Renée
Please use the Bind mechanism I described in my last mail...
--
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/
-- 
GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT!
Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01

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

guenther.rasch＠gmx.de