Hi,
the following SQL query returns (ceate_time) e.g. "2012-05-22 11:26:39"
- in the SQL query box for instance.
[Kernel/System/Ticket.pm in OTRS 3.1.5]
2535 return if !$Self->{DBObject}->Prepare(
2536 SQL => 'SELECT article_sender_type_id, article_type_id,
create_time FROM '
2537 . 'article WHERE ticket_id = ? ORDER BY create_time
ASC',
2538 Bind => [ \$Param{TicketID} ],
2539 );
BUT in the RowArray $Row[2] is "22.05.2012" - it's lacking the time and
has german time format.
2433 while ( my @Row = $Self->{DBObject}->FetchrowArray() ) {
push @SenderHistory, {
SenderTypeID => $Row[0],
ArticleTypeID => $Row[1],
Created => $Row[2],
Result is, other internal time functions get an invalid format as an
input and return zero.
Therefore, in case of tickets, which haven't been manually touched by
agents (tickets via mailin) escalation time is wrongly calculated. This
applies for OTRS 3.1.5 still. I wanted to fix it, but could do this only
with a rather dirty hack because of my FetchRowarray() problems.
TIA
Michael
_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
