RT 3.6.3 Reverse History Order patch

running RT 3.6.3 on linux.
I read ReverseHistoryOrder - Request Tracker Wiki
Which desribes some patches that will change the Transaction history order
of tickets viewed on webpage.

I tried the first simple option described:
added line to RT_SiteConfig
Set($OldestTransactionsFirst, 1);
then cleared mason cache
restarted apache but the history still shows Oldest First.
Setting Set($OldestTransactionsFirst, 1); causes apache to fail to restart
with erros about file permissions …strange.

So does anybody have a work around for RT 3.6.3 to do this.
thanks
Oliver

correction
Setting Set($OldestTransactionsFirst, 0); causes apache to fail to
restart with erros about file permissions …strange.
That is zero causes failureOn Thu, 25 Oct 2007, o.nash@cs.ucc.ie wrote:

running RT 3.6.3 on linux.
I read ReverseHistoryOrder - Request Tracker Wiki
Which desribes some patches that will change the Transaction history order
of tickets viewed on webpage.

I tried the first simple option described:
added line to RT_SiteConfig
Set($OldestTransactionsFirst, 1);
then cleared mason cache
restarted apache but the history still shows Oldest First.
Setting Set($OldestTransactionsFirst, 1); causes apache to fail to restart
with erros about file permissions …strange.

So does anybody have a work around for RT 3.6.3 to do this.

thanks
Oliver


The rt-users Archives

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we’ll take
up to 20 percent off the price. This sale won’t last long, so get in touch
today. Email us at sales@bestpractical.com or call us at +1 617 812 0745.

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media. Buy a
copy at http://rtbook.bestpractical.com

Oliver Nash
Computer Systems Support Group
Department of Computer Science
University College Cork
Ireland
EMAIL:o.nash@cs.ucc.ie
PHONE:+35321 4902972

o.nash

We have 3.6.4 and don't have the problem you described. Perhaps an 

upgrade to that version will resolve the problem.

Kenn
LBNLOn 10/25/2007 3:00 PM, o.nash@cs.ucc.ie wrote:

running RT 3.6.3 on linux.
I read ReverseHistoryOrder - Request Tracker Wiki
Which desribes some patches that will change the Transaction history order
of tickets viewed on webpage.

I tried the first simple option described:
added line to RT_SiteConfig
Set($OldestTransactionsFirst, 1);
then cleared mason cache
restarted apache but the history still shows Oldest First.
Setting Set($OldestTransactionsFirst, 1); causes apache to fail to restart
with erros about file permissions …strange.

So does anybody have a work around for RT 3.6.3 to do this.

thanks
Oliver


The rt-users Archives

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we’ll take
up to 20 percent off the price. This sale won’t last long, so get in
touch today. Email us at sales@bestpractical.com or call us at +1 617
812 0745.

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media. Buy
a copy at http://rtbook.bestpractical.com

Most probably you made a syntax mistake.On 10/26/07, o.nash@cs.ucc.ie o.nash@cs.ucc.ie wrote:

running RT 3.6.3 on linux.
I read http://wiki.bestpractical.com/view/ReverseHistoryOrder
Which desribes some patches that will change the Transaction history order
of tickets viewed on webpage.

I tried the first simple option described:
added line to RT_SiteConfig
Set($OldestTransactionsFirst, 1);
then cleared mason cache
restarted apache but the history still shows Oldest First.
Setting Set($OldestTransactionsFirst, 1); causes apache to fail to restart
with erros about file permissions …strange.

So does anybody have a work around for RT 3.6.3 to do this.

thanks
Oliver


The rt-users Archives

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we’ll take
up to 20 percent off the price. This sale won’t last long, so get in touch today.
Email us at sales@bestpractical.com or call us at +1 617 812 0745.

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.

Ruslan
this is a copy of the line I put in RT_SiteConfig
Set($OldestTransactionsFirst, 1);

Do you see a syntax error in it?

regards
OliverOn Fri, 26 Oct 2007, Ruslan Zakirov wrote:

Most probably you made a syntax mistake.

On 10/26/07, o.nash@cs.ucc.ie o.nash@cs.ucc.ie wrote:

running RT 3.6.3 on linux.
I read ReverseHistoryOrder - Request Tracker Wiki
Which desribes some patches that will change the Transaction history order
of tickets viewed on webpage.

I tried the first simple option described:
added line to RT_SiteConfig
Set($OldestTransactionsFirst, 1);
then cleared mason cache
restarted apache but the history still shows Oldest First.
Setting Set($OldestTransactionsFirst, 1); causes apache to fail to restart
with erros about file permissions …strange.

So does anybody have a work around for RT 3.6.3 to do this.

thanks
Oliver


The rt-users Archives

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we’ll take
up to 20 percent off the price. This sale won’t last long, so get in touch today.
Email us at sales@bestpractical.com or call us at +1 617 812 0745.

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


Best regards, Ruslan.

Oliver Nash
Computer Systems Support Group
Department of Computer Science
University College Cork
Ireland
EMAIL:o.nash@cs.ucc.ie
PHONE:+35321 4902972

Or you can do eventually
login as root
Select preferences (top right)
Select RT at a glance
Select unowned tickets
at right side where there is "order by"
first option by default is
Created Asc

Change to Desc

But I don’t know it this affects also non root users when they log-on or how to modify their preferences if not…

Gianluca

Gianluca
Thanks for that wich I already have, i.e. tickets sorted by created DESC
order.
My question is different:
i.e.
ticket transactions: how to sort the transactions in reverse order.
instead of the default OldestTransactionsFirst

regards
OllyOn Fri, 26 Oct 2007, Gianluca Cecchi wrote:

Or you can do eventually
login as root
Select preferences (top right)
Select RT at a glance
Select unowned tickets
at right side where there is “order by”
first option by default is
Created Asc

Change to Desc

But I don’t know it this affects also non root users when they log-on or how to modify their preferences if not…

Gianluca

-----Messaggio originale-----
Da: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] Per conto
di Kenneth Crocker
Inviato: venerdì 26 ottobre 2007 0.25
A: o.nash@cs.ucc.ie
Cc: rt-users@lists.bestpractical.com
Oggetto: Re: [rt-users] RT 3.6.3 Reverse History Order patch

o.nash

We have 3.6.4 and don’t have the problem you described.
Perhaps an upgrade to that version will resolve the problem.

Kenn
LBNL

On 10/25/2007 3:00 PM, o.nash@cs.ucc.ie wrote:

running RT 3.6.3 on linux.
I read ReverseHistoryOrder - Request Tracker Wiki
Which desribes some patches that will change the
Transaction history order
of tickets viewed on webpage.

I tried the first simple option described:
added line to RT_SiteConfig
Set($OldestTransactionsFirst, 1);
then cleared mason cache
restarted apache but the history still shows Oldest First.
Setting Set($OldestTransactionsFirst, 1); causes apache to
fail to restart
with erros about file permissions …strange.

So does anybody have a work around for RT 3.6.3 to do this.

thanks
Oliver


The rt-users Archives

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before
December 31, we’ll take
up to 20 percent off the price. This sale won’t last long,
so get in
touch today. Email us at sales@bestpractical.com or call
us at +1 617
812 0745.

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from
O’Reilly Media. Buy
a copy at http://rtbook.bestpractical.com


The rt-users Archives

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December
31, we’ll take
up to 20 percent off the price. This sale won’t last long, so
get in touch today.
Email us at sales@bestpractical.com or call us at +1 617 812 0745.

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


The rt-users Archives

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we’ll take
up to 20 percent off the price. This sale won’t last long, so get in touch today.
Email us at sales@bestpractical.com or call us at +1 617 812 0745.

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Oliver Nash
Computer Systems Support Group
Department of Computer Science
University College Cork
Ireland
EMAIL:o.nash@cs.ucc.ie
PHONE:+35321 4902972

Olly;
I am running 3.6.3 and newest transactions at the top, I have
Set($OldestTransactionsFirst, ‘0’);
working fine for me … Remember to restart apache

There is a work around if you wish you can modify
/opt/rt3/local/html/Ticket/Elements/ShowHistory and change
$Transactions->OrderByCols( { FIELD => ‘Created’,
ORDER => $OldestFirst },
{ FIELD => ‘id’,
ORDER => $OldestFirst },
);
to
$Transactions->OrderByCols( { FIELD => ‘Created’,
ORDER => ‘DESC’ },
{ FIELD => ‘id’,
ORDER => ‘DESC’ },
);

Roy
o.nash@cs.ucc.ie wrote:

Set($OldestTransactionsFirst, ‘0’);
is working fine for me too in 3.6.5… without modifing /opt/rt3/local/html/Ticket/Elements/ShowHistory
I didn’t know at all about this option for transaction history screen rendering …

Thanks,Gianluca and others,
I decided to retry one more time
After I edit RT_SiteConfig with:-
Set($OldestTransactionsFirst, ‘0’);

When I restart apache it fails with this error in error_log:

[Mon Oct 29 20:32:51 2007] [error] Couldn’t load RT config file
/opt/rt3/etc/RT_SiteConfig.pm as user root / group root.\nThe file is
owned by user root and group rt.\nThis usually means that the user/group
your webserver is running as cannot read the file.\nBe careful not to make
the permissions on this file too liberal, because it contains
database\npasswords. You may need to put the webserver user in the
appropriate group (rt) or change\npermissions be able to run
succesfully\n/opt/rt3/etc/RT_SiteConfig.pm did not return a true value at
/opt/rt3/lib/RT.pm line 141.\nBEGIN failed–compilation aborted at
/opt/rt3/bin/webmux.pl line 76.\nCompilation failed in require at (eval 2)
line 1.\n
[Mon Oct 29 20:32:51 2007] [error] Can’t load Perl file:
/opt/rt3/bin/webmux.pl for server cshelp.ucc.ie:80, exiting…

With
Set($OldestTransactionsFirst, ‘1’);
It starts without ant error:

Mon Oct 29 20:34:46 2007] [notice] Apache/2.0.59 (Unix) mod_perl/2.0.3
Perl/v5.8.8 configured – resuming normal operations

Thats the problem.
thanks
OllyOn Mon, 29 Oct 2007, Gianluca Cecchi wrote:

Set($OldestTransactionsFirst, ‘0’);
is working fine for me too in 3.6.5… without modifing /opt/rt3/local/html/Ticket/Elements/ShowHistory
I didn’t know at all about this option for transaction history screen rendering …

-----Messaggio originale-----
Da: Roy El-Hames [mailto:rfh@pipex.net]
Inviato: lunedì 29 ottobre 2007 17.04
A: o.nash@cs.ucc.ie
Cc: Gianluca Cecchi; rt-users@lists.bestpractical.com
Oggetto: Re: R: [rt-users] RT 3.6.3 Reverse History Order patch

Olly;
I am running 3.6.3 and newest transactions at the top, I have
Set($OldestTransactionsFirst, ‘0’); working fine for me …


The rt-users Archives

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we’ll take
up to 20 percent off the price. This sale won’t last long, so get in touch today.
Email us at sales@bestpractical.com or call us at +1 617 812 0745.

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Oliver Nash
Computer Systems Support Group
Department of Computer Science
University College Cork
Ireland
EMAIL:o.nash@cs.ucc.ie
PHONE:+35321 4902972

add “1;” as the bottom most line in the config.On 10/30/07, o.nash@cs.ucc.ie o.nash@cs.ucc.ie wrote:

Thanks,Gianluca and others,
I decided to retry one more time
After I edit RT_SiteConfig with:-
Set($OldestTransactionsFirst, ‘0’);

When I restart apache it fails with this error in error_log:

[Mon Oct 29 20:32:51 2007] [error] Couldn’t load RT config file
/opt/rt3/etc/RT_SiteConfig.pm as user root / group root.\nThe file is
owned by user root and group rt.\nThis usually means that the user/group
your webserver is running as cannot read the file.\nBe careful not to make
the permissions on this file too liberal, because it contains
database\npasswords. You may need to put the webserver user in the
appropriate group (rt) or change\npermissions be able to run
succesfully\n/opt/rt3/etc/RT_SiteConfig.pm did not return a true value at
/opt/rt3/lib/RT.pm line 141.\nBEGIN failed–compilation aborted at
/opt/rt3/bin/webmux.pl line 76.\nCompilation failed in require at (eval 2)
line 1.\n
[Mon Oct 29 20:32:51 2007] [error] Can’t load Perl file:
/opt/rt3/bin/webmux.pl for server cshelp.ucc.ie:80, exiting…

With
Set($OldestTransactionsFirst, ‘1’);
It starts without ant error:

Mon Oct 29 20:34:46 2007] [notice] Apache/2.0.59 (Unix) mod_perl/2.0.3
Perl/v5.8.8 configured – resuming normal operations

Thats the problem.
thanks
Olly

On Mon, 29 Oct 2007, Gianluca Cecchi wrote:

Set($OldestTransactionsFirst, ‘0’);
is working fine for me too in 3.6.5… without modifing /opt/rt3/local/html/Ticket/Elements/ShowHistory
I didn’t know at all about this option for transaction history screen rendering …

-----Messaggio originale-----
Da: Roy El-Hames [mailto:rfh@pipex.net]
Inviato: lunedì 29 ottobre 2007 17.04
A: o.nash@cs.ucc.ie
Cc: Gianluca Cecchi; rt-users@lists.bestpractical.com
Oggetto: Re: R: [rt-users] RT 3.6.3 Reverse History Order patch

Olly;
I am running 3.6.3 and newest transactions at the top, I have
Set($OldestTransactionsFirst, ‘0’); working fine for me …


The rt-users Archives

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we’ll take
up to 20 percent off the price. This sale won’t last long, so get in touch today.
Email us at sales@bestpractical.com or call us at +1 617 812 0745.

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


Oliver Nash
Computer Systems Support Group
Department of Computer Science
University College Cork
Ireland
EMAIL:o.nash@cs.ucc.ie
PHONE:+35321 4902972


The rt-users Archives

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we’ll take
up to 20 percent off the price. This sale won’t last long, so get in touch today.
Email us at sales@bestpractical.com or call us at +1 617 812 0745.

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.

Ruslan
Thankyou very much
that worked !
I must confess my ignorance of Perl and also RT,
how about an explanation of what that 1; did ?

thanks again.
OllyOn Tue, 30 Oct 2007, Ruslan Zakirov wrote:

add “1;” as the bottom most line in the config.

On 10/30/07, o.nash@cs.ucc.ie o.nash@cs.ucc.ie wrote:

Thanks,Gianluca and others,
I decided to retry one more time
After I edit RT_SiteConfig with:-
Set($OldestTransactionsFirst, ‘0’);

When I restart apache it fails with this error in error_log:

[Mon Oct 29 20:32:51 2007] [error] Couldn’t load RT config file
/opt/rt3/etc/RT_SiteConfig.pm as user root / group root.\nThe file is
owned by user root and group rt.\nThis usually means that the user/group
your webserver is running as cannot read the file.\nBe careful not to make
the permissions on this file too liberal, because it contains
database\npasswords. You may need to put the webserver user in the
appropriate group (rt) or change\npermissions be able to run
succesfully\n/opt/rt3/etc/RT_SiteConfig.pm did not return a true value at
/opt/rt3/lib/RT.pm line 141.\nBEGIN failed–compilation aborted at
/opt/rt3/bin/webmux.pl line 76.\nCompilation failed in require at (eval 2)
line 1.\n
[Mon Oct 29 20:32:51 2007] [error] Can’t load Perl file:
/opt/rt3/bin/webmux.pl for server cshelp.ucc.ie:80, exiting…

With
Set($OldestTransactionsFirst, ‘1’);
It starts without ant error:

Mon Oct 29 20:34:46 2007] [notice] Apache/2.0.59 (Unix) mod_perl/2.0.3
Perl/v5.8.8 configured – resuming normal operations

Thats the problem.
thanks
Olly

On Mon, 29 Oct 2007, Gianluca Cecchi wrote:

Set($OldestTransactionsFirst, ‘0’);
is working fine for me too in 3.6.5… without modifing /opt/rt3/local/html/Ticket/Elements/ShowHistory
I didn’t know at all about this option for transaction history screen rendering …

-----Messaggio originale-----
Da: Roy El-Hames [mailto:rfh@pipex.net]
Inviato: lunedì 29 ottobre 2007 17.04
A: o.nash@cs.ucc.ie
Cc: Gianluca Cecchi; rt-users@lists.bestpractical.com
Oggetto: Re: R: [rt-users] RT 3.6.3 Reverse History Order patch

Olly;
I am running 3.6.3 and newest transactions at the top, I have
Set($OldestTransactionsFirst, ‘0’); working fine for me …


The rt-users Archives

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we’ll take
up to 20 percent off the price. This sale won’t last long, so get in touch today.
Email us at sales@bestpractical.com or call us at +1 617 812 0745.

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


Oliver Nash
Computer Systems Support Group
Department of Computer Science
University College Cork
Ireland
EMAIL:o.nash@cs.ucc.ie
PHONE:+35321 4902972


The rt-users Archives

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we’ll take
up to 20 percent off the price. This sale won’t last long, so get in touch today.
Email us at sales@bestpractical.com or call us at +1 617 812 0745.

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.

Oliver Nash
Computer Systems Support Group
Department of Computer Science
University College Cork
Ireland
EMAIL:o.nash@cs.ucc.ie
PHONE:+35321 4902972