Can't open Ticket Time::ParseDate error

Hello everybody

RT: 3.8.9
Server : Ubuntu 10.04

I have a Problem to open a ticket. If i try to open it … there comes no
repsponse from the webif…

In the RT log i found the fowllowing entry:

RT::Date used Time::ParseDate to make ‘now’ 1322826880

so i have updated the perl module but the problem still apperars…

best regards

john s.

View this message in context: http://old.nabble.com/Can't-open-Ticket-Time%3A%3AParseDate-error-tp32901809p32901809.html

???

View this message in context: http://old.nabble.com/Can't-open-Ticket-Time%3A%3AParseDate-error-tp32901809p32933376.html

What do you see in /var/log/messages or /var/log/syslog

Also, what are the entries in /opt/rt4/var/log (error and access)? (is the
“click” registered?)

Do other things via de webinterface work? (is this the only problem your
seeing? e.g. ticket creation, editing some fields, etc.)

– Bart

Op 8 december 2011 10:25 schreef john s. fireskyer@hochsitze.com het
volgende:

Hello everybody

after a few commands with mysqlcheck on the table which belongs to …
everything is fine

best regards

john s.

View this message in context: http://old.nabble.com/Can't-open-Ticket-Time%3A%3AParseDate-error-tp32901809p32933407.html

RT: 3.8.9
Server : Ubuntu 10.04

Hello everybody,

Due to this ticket

I have a similar problem again

So i tried to create a new user but if i do so and press the create Button
he forwarded me to my Dashboard and nothing happens.

What do you see in /var/log/messages or /var/log/syslog Also, what are the
entries in /opt/rt4/var/log (error and access)? (is the “click” registered?)

There no entries anymore which belongs to RT in the other logfiles.

The link behind the create user option is:

https://server.local/Admin/Users/Modify.html?Create=1

the rt.log entry after clicking the create user button :

[Mon Jan 23 12:16:02 2012] [debug]: RT::Date used Time::ParseDate to make
‘now’ 1327320962 (/opt/rt3/bin/…/lib/RT/Date.pm:222)

it makes no sense for me

best regards

john s.

View this message in context: http://old.nabble.com/Can't-open-Ticket-Time%3A%3AParseDate-error-tp32901809p33187686.html

Problem solved:

I switched to the internet explorer … so i guess it’s a kind of Firefox
issue

but if someone know what kind of error it is

it would be helpfull to know some infos according to it …

best regards

john s.
View this message in context: http://old.nabble.com/Can't-open-Ticket-Time%3A%3AParseDate-error-tp32901809p33206995.html

All,

We have an external perl script that trolls through the RT MySQL DB
looking for recent transactions with a specific CF that has been
updated. The script will pull out specific data from the DB and update
an External Site for notifications. The script is used to inform the
campus when we are planning server maintenance or are working on a issue
that impacts the campus.

Would like to convert the external perl script into a RT Custom Scrip
that acts upon ‘Correspond’ || ‘Comment’ && CF modification, when those
conditions are met the Custom Action will call an external perl script
with appropriate data to update the notification www site.

Have the following (based on
http://requesttracker.wikia.com/wiki/OnCustomFieldValueChange) which
throws ‘RT: Couldn’t load object RT::Transaction #0
(/opt/rt4/sbin/…/lib/RT/Interface/Web.pm:2164)’ in the log

unless (
( ($self->TransactionObj->Type eq “Correspond”
|| $self->TransactionObj->Type eq “Comment”)
&& $self->TransactionObj->Field == 18 )
) {
return 0;
}

return 0 unless $self->TicketObj->FirstCustomFieldValue(‘External
Updates’) =~ /Public Status/i;

1;

Regards,

Ron

All,

We have an external perl script that trolls through the RT MySQL DB
looking for recent transactions with a specific CF that has been
updated. The script will pull out specific data from the DB and update
an External Site for notifications. The script is used to inform the
campus when we are planning server maintenance or are working on a
issue that impacts the campus.

Would like to convert the external perl script into a RT Custom Scrip
that acts upon ‘Correspond’ || ‘Comment’ && CF modification, when
those conditions are met the Custom Action will call an external perl
script with appropriate data to update the notification www site.

Have the following (based on
http://requesttracker.wikia.com/wiki/OnCustomFieldValueChange) which
throws ‘RT: Couldn’t load object RT::Transaction #0
(/opt/rt4/sbin/…/lib/RT/Interface/Web.pm:2164)’ in the log

unless (
( ($self->TransactionObj->Type eq “Correspond”
|| $self->TransactionObj->Type eq “Comment”)
&& $self->TransactionObj->Field == 18 )
) {
return 0;
}

return 0 unless $self->TicketObj->FirstCustomFieldValue(‘External
Updates’) =~ /Public Status/i;

1;

Regards,

Ron


RT Training Sessions (http://bestpractical.com/services/training.html)

  • Boston March 5 & 6, 2012

A little more background

The CF was created as such:
Type: Select One value
Request Type: Select Box
Applies To: Ticket Transactions
Values:
Change Log
Public Status
Private Status

Script created as such:
Condition: User Defined
Action: User Defined
Template: Blank
Stage:TransactionCreate

Not sure it is a Scrip issue, I modified the script and put “1;” in each
box and still get the log message. Also tried with each box being empty,
no joy same log message.

All,

We have an external perl script that trolls through the RT MySQL DB
looking for recent transactions with a specific CF that has been
updated. The script will pull out specific data from the DB and
update an External Site for notifications. The script is used to
inform the campus when we are planning server maintenance or are
working on a issue that impacts the campus.

Would like to convert the external perl script into a RT Custom
Scrip that acts upon ‘Correspond’ || ‘Comment’ && CF modification,
when those conditions are met the Custom Action will call an
external perl script with appropriate data to update the
notification www site.

Have the following (based on
http://requesttracker.wikia.com/wiki/OnCustomFieldValueChange) which
throws ‘RT: Couldn’t load object RT::Transaction #0
(/opt/rt4/sbin/…/lib/RT/Interface/Web.pm:2164)’ in the log

This is just a warning, not an error, and unrelated to your scrip not
matching.

unless (
( ($self->TransactionObj->Type eq “Correspond”
|| $self->TransactionObj->Type eq “Comment”)
&& $self->TransactionObj->Field == 18 )
) {
return 0;
}

return 0 unless $self->TicketObj->FirstCustomFieldValue(‘External
Updates’) =~ /Public Status/i;

Your CF is actually a transaction CF, not a ticket cf.
You have to ask for the
TransactionObj->FirstCustomFieldValue(‘External Updated’)
Also, if you have a look in your DB, is Field being set on the
Correspond/Comment transactions for this?

Unfortunately, even with the problem I listed above, you have a worse
problem.

Transaction Custom Fields aren’t set until After the
Correspond/Comment, which means that the value won’t be available to
you in the Scrip Condition.

Your best bet is to make this Scrip a TransactionBatch scrip, which
lets it run last, and then you can check for Correspond or Comment and
TransactionObj->FirstCustomFieldValue

Please don’t change all your Scrips to TransactionBatch, as it causes
the Preview Scrips feature to not work.

-kevin

All,

We have an external perl script that trolls through the RT MySQL DB
looking for recent transactions with a specific CF that has been
updated. The script will pull out specific data from the DB and
update an External Site for notifications. The script is used to
inform the campus when we are planning server maintenance or are
working on a issue that impacts the campus.

Would like to convert the external perl script into a RT Custom
Scrip that acts upon ‘Correspond’ || ‘Comment’&& CF modification,
when those conditions are met the Custom Action will call an
external perl script with appropriate data to update the
notification www site.

Have the following (based on
http://requesttracker.wikia.com/wiki/OnCustomFieldValueChange) which
throws ‘RT: Couldn’t load object RT::Transaction #0
(/opt/rt4/sbin/…/lib/RT/Interface/Web.pm:2164)’ in the log
This is just a warning, not an error, and unrelated to your scrip not
matching.

unless (
( ($self->TransactionObj->Type eq “Correspond”
|| $self->TransactionObj->Type eq “Comment”)
&& $self->TransactionObj->Field == 18 )
) {
return 0;
}

return 0 unless $self->TicketObj->FirstCustomFieldValue(‘External
Updates’) =~ /Public Status/i;
Your CF is actually a transaction CF, not a ticket cf.
You have to ask for the
TransactionObj->FirstCustomFieldValue(‘External Updated’)
Also, if you have a look in your DB, is Field being set on the
Correspond/Comment transactions for this?

Unfortunately, even with the problem I listed above, you have a worse
problem.

Transaction Custom Fields aren’t set until After the
Correspond/Comment, which means that the value won’t be available to
you in the Scrip Condition.

Your best bet is to make this Scrip a TransactionBatch scrip, which
lets it run last, and then you can check for Correspond or Comment and
TransactionObj->FirstCustomFieldValue

Please don’t change all your Scrips to TransactionBatch, as it causes
the Preview Scrips feature to not work.

-kevin


RT Training Sessions (http://bestpractical.com/services/training.html)

  • Boston — March 5& 6, 2012
    Kevin,

THANKS!!
Works like a champ now!!

-Ron