RES: Strange CLI Date Output

Forgot to add some info.

root@rt:~# lsb_release -ris
Ubuntu
11.10

root@rt:~# dpkg -s request-tracker4 | grep Version
Version: 4.0.1-1

root@rt:~# rt ls 3070 -l | grep Created && rt ls 2070 -l | grep Created
Created: Qua Jun 27 15:01:37 2012
Created: Sex Maio 11 15:54:49 2012

Looks that some tickets have full month name and some not.De: Diaulas Castro
Enviada em: terça-feira, 23 de outubro de 2012 15:24
Para: rt-users@lists.bestpractical.com
Assunto: Strange CLI Date Output

Hello RT friends,
I got this problem and cant resolve, i cant even locate when started.

My CLI started to output errors about ParseDate, but just some tickets, see below:

Tickets 770,1070 and 3070 are OK, displaying relative date (7mth, 3mth)
Ticket 2070 with error, displaying parsedate error.

root@rt:~# rt ls 770
Query:id=770
Ticket Owner Queue Age Told Status Requestor Subject
770 jose. hsr 7 mth 7 mth resolv leandro.v Ativação de Job

root@rt:~# rt ls 2070
Query:id=2070
Ticket Owner Queue Age Told Status Requestor Subject
Unknown date format in parsedate: Sex Maio 11 15:54:49 2012
Unknown date format in parsedate: Ter Maio 15 17:55:18 2012
2070 hugo. h9j ??? ??? resolv luciano.c Exclusão de host SIGMon

root@rt:~# rt ls 1070
Query:id=1070
Ticket Owner Queue Age Told Status Requestor Subject
1070 diaul saude 7 mth 7 mth resolv mirley.ti Verificacao de download e link

root@rt:~# rt ls 3070
Query:id=3070
Ticket Owner Queue Age Told Status Requestor Subject
3070 nelso cardi 3 mth 3 mth resolv sistemas@ Dump

Below -l to list details:
root@rt:~# rt ls -l 770
id: ticket/770
Queue: hsr
Owner: XXX
Creator: XXXXX
Subject: Ativação de Job
Status: resolved
Priority: 0
InitialPriority: 0
FinalPriority: 0
Requestors: XXXX
Cc: XXXX
AdminCc: XXX
Created: Ter Mar 06 14:04:03 2012
Starts: Não definido
Started: Ter Mar 06 14:51:24 2012
Due: Não definido
Resolved: Ter Mar 06 15:13:21 2012
Told: Ter Mar 06 15:13:19 2012
LastUpdated: Ter Mar 06 15:16:06 2012
TimeEstimated: 0
TimeWorked: 0
TimeLeft: 0
CF.{Agendado}:
CF.{Horas_Normais}: 0
CF.{Minutos_Normais}: 30
CF.{Horas_Extras}: 0
CF.{Minutos_Extras}: 0
CF.{Reaberto}:
CF.{Chamado_Interno}:
CF.{Cobranca}:
CF.{Visita}:
CF.{area}:

Folow:

root@rt:~# locale
LANG=pt_BR.ISO-88591
LANGUAGE=
LC_CTYPE=“pt_BR.ISO-88591”
LC_NUMERIC=“pt_BR.ISO-88591”
LC_TIME=“pt_BR.ISO-88591”
LC_COLLATE=“pt_BR.ISO-88591”
LC_MONETARY=“pt_BR.ISO-88591”
LC_MESSAGES=“pt_BR.ISO-88591”
LC_PAPER=“pt_BR.ISO-88591”
LC_NAME=“pt_BR.ISO-88591”
LC_ADDRESS=“pt_BR.ISO-88591”
LC_TELEPHONE=“pt_BR.ISO-88591”
LC_MEASUREMENT=“pt_BR.ISO-88591”
LC_IDENTIFICATION=“pt_BR.ISO-88591”
LC_ALL=pt_BR.ISO-88591

About user date format:

Use system default (Thu Oct 25 13:59:03 2012)

About RT_SiteConfig.pm

No DateTimeFormat.

-----Mensagem original-----De: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] Em nome de Kevin Falcone
Enviada em: quinta-feira, 25 de outubro de 2012 01:15
Para: rt-users@lists.bestpractical.com
Assunto: Re: [rt-users] Strange CLI Date Output

Hello RT friends,
I got this problem and cant resolve, i cant even locate when started.

My CLI started to output errors about ParseDate, but just some tickets, see below:

Tickets 770,1070 and 3070 are OK, displaying relative date (7mth, 3mth)
Ticket 2070 with error, displaying parsedate error.

I’d be curious to know if you have LC_DATE set to something and what you’ve chosen as your DateTimeFormat in RT_SiteConfig.pm or in your user preferences.

-kevin

root@rt:~# rt ls 770
Query:id=770
Ticket Owner Queue Age Told Status Requestor Subject

770 jose. hsr 7 mth 7 mth resolv leandro.v Ativação de Job

root@rt:~# rt ls 2070
Query:id=2070
Ticket Owner Queue Age Told Status Requestor Subject

---------- Unknown date format in parsedate: Sex Maio 11 15:54:49 2012
Unknown date format in parsedate: Ter Maio 15 17:55:18 2012
2070 hugo. h9j ??? ??? resolv luciano.c Exclusão de host SIGMon

root@rt:~# rt ls 1070
Query:id=1070
Ticket Owner Queue Age Told Status Requestor Subject

1070 diaul saude 7 mth 7 mth resolv mirley.ti Verificacao de
download e link

root@rt:~# rt ls 3070
Query:id=3070
Ticket Owner Queue Age Told Status Requestor Subject

3070 nelso cardi 3 mth 3 mth resolv sistemas@ Dump

Another item i checked,
Made sql search on database and the fields are equal, justo on CLI I got parsedate error, on web interface all tickets display ok.

-----Mensagem original-----De: Diaulas Castro
Enviada em: quinta-feira, 25 de outubro de 2012 12:01
Para: rt-users@lists.bestpractical.com
Assunto: RES: [rt-users] Strange CLI Date Output

Folow:

root@rt:~# locale
LANG=pt_BR.ISO-88591
LANGUAGE=
LC_CTYPE=“pt_BR.ISO-88591”
LC_NUMERIC=“pt_BR.ISO-88591”
LC_TIME=“pt_BR.ISO-88591”
LC_COLLATE=“pt_BR.ISO-88591”
LC_MONETARY=“pt_BR.ISO-88591”
LC_MESSAGES=“pt_BR.ISO-88591”
LC_PAPER=“pt_BR.ISO-88591”
LC_NAME=“pt_BR.ISO-88591”
LC_ADDRESS=“pt_BR.ISO-88591”
LC_TELEPHONE=“pt_BR.ISO-88591”
LC_MEASUREMENT=“pt_BR.ISO-88591”
LC_IDENTIFICATION=“pt_BR.ISO-88591”
LC_ALL=pt_BR.ISO-88591

About user date format:

Use system default (Thu Oct 25 13:59:03 2012)

About RT_SiteConfig.pm

No DateTimeFormat.

-----Mensagem original-----
De: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] Em nome de Kevin Falcone Enviada em: quinta-feira, 25 de outubro de 2012 01:15
Para: rt-users@lists.bestpractical.com
Assunto: Re: [rt-users] Strange CLI Date Output

Hello RT friends,
I got this problem and cant resolve, i cant even locate when started.

My CLI started to output errors about ParseDate, but just some tickets, see below:

Tickets 770,1070 and 3070 are OK, displaying relative date (7mth, 3mth)
Ticket 2070 with error, displaying parsedate error.

I’d be curious to know if you have LC_DATE set to something and what you’ve chosen as your DateTimeFormat in RT_SiteConfig.pm or in your user preferences.

-kevin

root@rt:~# rt ls 770
Query:id=770
Ticket Owner Queue Age Told Status Requestor Subject

770 jose. hsr 7 mth 7 mth resolv leandro.v Ativação de Job

root@rt:~# rt ls 2070
Query:id=2070
Ticket Owner Queue Age Told Status Requestor Subject

---------- Unknown date format in parsedate: Sex Maio 11 15:54:49 2012
Unknown date format in parsedate: Ter Maio 15 17:55:18 2012
2070 hugo. h9j ??? ??? resolv luciano.c Exclusão de host SIGMon

root@rt:~# rt ls 1070
Query:id=1070
Ticket Owner Queue Age Told Status Requestor Subject

1070 diaul saude 7 mth 7 mth resolv mirley.ti Verificacao de
download e link

root@rt:~# rt ls 3070
Query:id=3070
Ticket Owner Queue Age Told Status Requestor Subject

3070 nelso cardi 3 mth 3 mth resolv sistemas@ Dump

Another item i checked,
Made sql search on database and the fields are equal, justo on CLI I got parsedate error, on web interface all tickets display ok.

There’s unlikely to be anything wrong in the database.

root@rt:~# locale
LANG=pt_BR.ISO-88591
LANGUAGE=
LC_CTYPE="pt_BR.ISO-88591"
LC_NUMERIC="pt_BR.ISO-88591"
LC_TIME="pt_BR.ISO-88591"
LC_COLLATE="pt_BR.ISO-88591"
LC_MONETARY="pt_BR.ISO-88591"
LC_MESSAGES="pt_BR.ISO-88591"
LC_PAPER="pt_BR.ISO-88591"
LC_NAME="pt_BR.ISO-88591"
LC_ADDRESS="pt_BR.ISO-88591"
LC_TELEPHONE="pt_BR.ISO-88591"
LC_MEASUREMENT="pt_BR.ISO-88591"
LC_IDENTIFICATION="pt_BR.ISO-88591"
LC_ALL=pt_BR.ISO-88591

I asked about your locale settings because they’re likely the source of
the problem. bin/rt would have to know how to parse dates formatted
in pt_BR and it does not. If you unset your LCs or set them all to C
I bet you don’t see the problem. Fixing this looks quite hard without
bloating bin/rt

-kevin