[rt-users] CSS in source code

2009-03-16 Thread Alberto Villanueva
Hi all!

 

And. good morning! :-)

 

I have a new page for my client in RT. I'm trying to modify this page adding css
code in several tags, but the format is not seen as it should.

 

I put a simple example that I'm using in that page:

 

** The page's name is lalala.html

** I have a table, that it has several rows XD

*** I'm using the next:

tr style=border: thin solid blue;

** Result: the row hasn't got the blue border :-( :-(

 

Any idea? Any file that I have to search in?

 

 

Best regards,


ALBERTO VILLANUEVA VAL 

Consultor



Altran

 

ParqueEmpresarial Las Mercedes, Edificio 1 
C/ Campezo, 1. 28022 Madrid
Tel : + 34 91 744 46 00
Fax: + 34 91 415 24 57

 http://www.altran.es www.altran.es

 

 

 

image001.jpg___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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


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

Re: [rt-users] CSS in source code

2009-03-16 Thread Alberto Villanueva
I have found this link [1] on RT Wiki. Should I do it this way??

 

[1]:  http://wiki.bestpractical.com/view/CustomizingWithCallbacks
http://wiki.bestpractical.com/view/CustomizingWithCallbacks

 

Regards,


ALBERTO VILLANUEVA VAL 

Consultor



Altran

 

ParqueEmpresarial Las Mercedes, Edificio 1 
C/ Campezo, 1. 28022 Madrid
Tel : + 34 91 744 46 00
Fax: + 34 91 415 24 57

 http://www.altran.es www.altran.es

 

 

  _  

size=2 width=100% align=center 

De: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] En nombre de Alberto
Villanueva
Enviado el: lunes, 16 de marzo de 2009 11:13
Para: rt-users@lists.bestpractical.com
Asunto: [rt-users] CSS in source code

 

Hi all!

 

And. good morning! :-)

 

I have a new page for my client in RT. I'm trying to modify this page adding css
code in several tags, but the format is not seen as it should.

 

I put a simple example that I'm using in that page:

 

** The page's name is lalala.html

** I have a table, that it has several rows XD

*** I'm using the next:

tr style=border: thin solid blue;

** Result: the row hasn't got the blue border :-( :-(

 

Any idea? Any file that I have to search in?

 

 

Best regards,


ALBERTO VILLANUEVA VAL 

Consultor



Altran

 

ParqueEmpresarial Las Mercedes, Edificio 1 
C/ Campezo, 1. 28022 Madrid
Tel : + 34 91 744 46 00
Fax: + 34 91 415 24 57

 http://www.altran.es www.altran.es

 

 

 

image001.jpg___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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


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

[rt-users] Upgrading - 3.6.5 - 3.8.2

2009-03-16 Thread Aaron Guise
Hi,
In following the upgrade docs we apply updates to schema with
 /opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password
--action upgrade

But this gives me error below.  Any ideas how I could progress past this
issue?

Output from console;

Processing 3.7.1
Now inserting data
Processing 3.7.3
Now populating database schema.
Processing 3.7.10
Now inserting data
Processing 3.7.15
Now inserting data
Processing 3.7.19
Now inserting data
Processing 3.7.81
Now populating database schema.
[Mon Mar 16 11:26:16 2009] [crit]: DBD::mysql::st execute failed: Duplicate
key name 'CachedGroupMembers3' at /opt/rt3/sbin/../lib/RT/Handle.pm line
506. (/opt/rt3/sbin/../lib/RT.pm:377)
DBD::mysql::st execute failed: Duplicate key name 'CachedGroupMembers3' at
/opt/rt3/sbin/../lib/RT/Handle.pm line 506.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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


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

Re: [rt-users] Problem Tools, Reports Postgres 3.8.2

2009-03-16 Thread Kristian Davies
 Thank you for the information. I was hoping that it was something
 like that. Stick with your areas of expertise to reduce support
 costs. We are more the other way here with more PostgreSQL than
 MySQL. What is your plan to provide redundancy/business continuity
 for your RT instance and what does MySQL for handling full-text
 searching? We are trying to evaluate possible options for some
 new MySQL instances and any feedback would be appreciated.

Redundancy at the moment is just dump/restore of the database and
having mirrored disks.  When we go MySQL we may add master/slave
replication, which we use for most of our smaller databases.

-Kristian
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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


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


Re: [rt-users] Upgrading - 3.6.5 - 3.8.2

2009-03-16 Thread Jesse Vincent



On Mon, Mar 16, 2009 at 11:30:22PM +1200, Aaron Guise wrote:
 Hi,
 In following the upgrade docs we apply updates to schema with
  /opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password
 --action upgrade
 
 But this gives me error below.  Any ideas how I could progress past this
 issue?
 

That suggests you've tried to run the update before or manually added an
index. You might try a DROP INDEX CachedGroupMembers3; and starting
over from where the upgrade bailed out.

 Output from console;
 
 Processing 3.7.1
 Now inserting data
 Processing 3.7.3
 Now populating database schema.
 Processing 3.7.10
 Now inserting data
 Processing 3.7.15
 Now inserting data
 Processing 3.7.19
 Now inserting data
 Processing 3.7.81
 Now populating database schema.
 [Mon Mar 16 11:26:16 2009] [crit]: DBD::mysql::st execute failed: Duplicate
 key name 'CachedGroupMembers3' at /opt/rt3/sbin/../lib/RT/Handle.pm line
 506. (/opt/rt3/sbin/../lib/RT.pm:377)
 DBD::mysql::st execute failed: Duplicate key name 'CachedGroupMembers3' at
 /opt/rt3/sbin/../lib/RT/Handle.pm line 506.

 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
 
 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com
 
 
 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
 Buy a copy at http://rtbook.bestpractical.com

-- 
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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


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


[rt-users] custom template probs using RT::Group

2009-03-16 Thread Andy Smith
Hi,

   On RT 3.8.2 I am trying to use the example here:

http://wiki.bestpractical.com/view/SendEmailAction

When I try and use the section in the template as described in the wiki:

To: { my $GroupObj = RT::Group-new($user);
$GroupObj-LoadUserDefinedGroup('Group Name');
$GroupObj-MemberEmailAddressesAsString()}


it doesn't work for me, I see this error in the system messages file:

Mar 16 00:01:52 alpha RT: RT::Users=HASH(0x16b0a97c) was created  
without a CurrentUser. Any RT object which is subclass of RT::Base  
must be created with a RT::CurrentUser or a RT::User object as the  
first argument. (/usr/local/lib/perl5/site_perl/5.8.9/RT/Base.pm:108)
Mar 16 00:01:53 alpha RT: Template parsing error:  
RT::Users=HASH(0x16b0a97c) was created without a CurrentUser at  
/usr/local/lib/perl5/site_perl/5.8.9/RT/SearchBuilder.pm line 81   
RT::SearchBuilder::_Init('RT::Users=HASH(0x16b0a97c)', undef) called  
at /usr/local/lib/perl5/site_perl/5.8.9/RT/Users_Overlay.pm line 80 
 RT::Users::_Init('RT::Users=HASH(0x16b0a97c)', undef) called at  
/usr/local/lib/perl5/site_perl/5.8.9/DBIx/SearchBuilder.pm line 93  
  DBIx::SearchBuilder::new('RT::Users', undef) called at  
/usr/local/lib/perl5/site_perl/5.8.9/RT/Group_Overlay.pm line 843   
   RT::Group::UserMembersObj('RT::Group=HASH(0x16b327ac)') called at  
/usr/local/lib/perl5/site_perl/5.8.9/RT/Group_Overlay.pm line 878  
RT::Group::MemberEmailAddresses('RT::Group=HASH(0x16b327ac)') called  
at /usr/local/lib/perl5/site_perl/5.8.9/RT/Group_Overlay.pm line 899
  
RT::Group::MemberEmailAddressesAsString('RT::Group=HASH(0x16b327ac)')  
called at template line 3 eval 'package Text::Template::GEN2;  
; #line 1 template  my $GroupObj = RT::Group-new
Mar 16 00:01:53 alpha kernel: oup-new


It does work if I use this code:

To: { my $GroupObj = RT::Group-new($RT::SystemUser);
$GroupObj-LoadUserDefinedGroup('Group Name');
$GroupObj-MemberEmailAddressesAsString()}

But I don't understand the difference, is using $RT::SystemUser going  
to do anything bad? If this is ok and there is some problem with the  
code as is on the wiki should I update the data on the wiki?

thanks for any help, Andy.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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


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


[rt-users] Is RT allright being OK ?

2009-03-16 Thread jul
Hello,

I discovered I had mistakes in my scrips (forgot the -ISO cast), but I am
puzzled :

is it normal that my table and field name are lower case even though I
installed request tracker with the  rt-setup-database script ?

Will it be a problem upgrading ?
Here is a short sample of /etc/request-tracker3.8/schema.Pg :


CREATE TABLE Tickets (
  id INTEGER DEFAULT nextval('tickets_id_seq'),

  Starts TIMESTAMP NULL  ,
  Started TIMESTAMP NULL  ,
  Due TIMESTAMP NULL  ,
  Resolved TIMESTAMP NULL  ,

Here is a short sample of pg_dump -F p rt3  rt320090316.sql:

CREATE TABLE tickets (
id integer DEFAULT nextval('tickets_id_seq'::regclass) NOT NULL,

starts timestamp without time zone,
started timestamp without time zone,
due timestamp without time zone,
resolved timestamp without time zone,

I may seems stupid, but I prefer to bluntly reinstall my RT if I cannot
upgrade.

-- 
Julien Tayon // digital craftsman // making things simpler (when possible)

Tell a man there are 300 billion stars in the universe and he'll believe you.
Tell him a bench has wet paint on it and he'll have to touch to be sure.



___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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


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


[rt-users] Asset Tracker + 3.8.2 possible?

2009-03-16 Thread charlie derr
Greetings,
I'm just getting started with trying to set up a test-instance of RT.  
Before I possibly break what I've so far accomplished can 
anyone tell me if Asset Tracker 1.2.3 will work with rt-3.8.2?

In the README file there're instructions to patch rt-3.4 but I'm 
reluctant to run that against 3.8.2 without knowing that someone 
has done it before successfully.

thanks so much in advance for your time,
~c
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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


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


Re: [rt-users] RT 3.8.2 packages for Debian Lenny?

2009-03-16 Thread Dominic Hargreaves
On Wed, Feb 04, 2009 at 02:05:27PM +, Dominic Hargreaves wrote:
 On Tue, Jan 27, 2009 at 04:45:15PM +, Dominic Hargreaves wrote:
  I hesitate to say again, since I previously expected to be able to do an
  upload the same week. I'm just testing our current candidate, but
  there's a new bug which requires a new package upload to Debian which
  I'll want to get in before a new upload, so it may not be for another
  week or so.
 
 Current status is that this is currently stalled on a new package
 waiting in NEW[0] (libipc-run-safehandles-perl)
 
 I would hazard a guess that ftpmasters are busy preparing for the
 release of Lenny, so this might not get processed for a few weeks.

RT 3.8.2 packages are now in unstable.

Cheers,
Dominic.

-- 
Dominic Hargreaves, Systems Development and Support Team
Computing Services, University of Oxford
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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


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


Re: [rt-users] Asset Tracker + 3.8.2 possible?

2009-03-16 Thread Todd Chapman
I would use 1.2.4b1 from the repo.
http://code.google.com/p/asset-tracker-4rt/source/checkout

No patching of RT is necessary.

Confidence level is high. :)

On Mon, Mar 16, 2009 at 12:08 PM, charlie derr cd...@simons-rock.edu wrote:
 Greetings,
        I'm just getting started with trying to set up a test-instance of RT.  
 Before I possibly break what I've so far accomplished can
 anyone tell me if Asset Tracker 1.2.3 will work with rt-3.8.2?

        In the README file there're instructions to patch rt-3.4 but I'm 
 reluctant to run that against 3.8.2 without knowing that someone
 has done it before successfully.

                thanks so much in advance for your time,
                        ~c
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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


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

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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


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

[rt-users] ruby library for REST access status

2009-03-16 Thread Tom Lahti
I have completed a first version of a ruby library for accessing RT via the
REST interface.  It supports adding/modifying/corresponding on tickets,
adding/modifying users, and attachments (initially, as long as they fit in
memory.  Streaming attachments and chunking them via HTTP is on my todo
list).  It's functionally similar to RT::Client::REST in perl, but for ruby.

However, since I wrote this on company time I need company approval to open
source it.  I've requested that and am waiting for approval before releasing
the code.

Is there anyone on the list who would use this if it were open sourced?  It
might provide some leverage to get it released if we know if there are
others out there who will use it and possibly provide patches / feature
enhancements.

-- 
-- 
   Tom Lahti
   BIT Statement LLC

   (425)251-0833 x 117
   http://www.bitstatement.net/
-- 
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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


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


Re: [rt-users] Asset Tracker + 3.8.2 possible?

2009-03-16 Thread John BORIS
Charlie,
You can disregard that.  At least I did when I installed on my RT but I
am on 3.6

John J. Boris, Sr.
JEN-A-SyS Administrator
Archdiocese of Philadelphia
222 North 17th Street
Philadelphia, Pa. 19103
Tel: 215-965-1714
Fax: 215-587-3525
Remember! That light at the end of the tunnel
Just might be the headlight of an oncoming train!
 charlie derr cd...@simons-rock.edu 03/16/09 11:08 AM 
Greetings,
I'm just getting started with trying to set up a test-instance
of RT.  Before I possibly break what I've so far accomplished can 
anyone tell me if Asset Tracker 1.2.3 will work with rt-3.8.2?

In the README file there're instructions to patch rt-3.4 but I'm
reluctant to run that against 3.8.2 without knowing that someone 
has done it before successfully.

thanks so much in advance for your time,
~c
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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


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

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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


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


Re: [rt-users] Is RT allright being OK ?

2009-03-16 Thread Bill Cole
jul wrote, On 3/16/09 11:17 AM:
 Hello,
 
 I discovered I had mistakes in my scrips (forgot the -ISO cast), but I am
 puzzled :
 
 is it normal that my table and field name are lower case even though I
 installed request tracker with the  rt-setup-database script ?

Yes. SQL names are case-insensitive except when quoted (i.e. used as literals).

 Will it be a problem upgrading ?

No.


___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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


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


[rt-users] RTFM installation problem

2009-03-16 Thread shaker Khzym

Hi
  I try to install RTFM and I got this error when I ran make initdb

/usr/bin/perl -Ilib -I/opt/rt3/local/lib -I/opt/rt3/lib
/opt/rt3/sbin/rt-setup-database --action schema --datadir etc --dba
RT2 --prompt-for-dba-password
Setuid/gid script is writable by world.
...returned with error: 6400
make: *** [initdb] Error 25

any help 
Shaekir,

_
Chat with the whole group, and bring everyone together.
http://go.microsoft.com/?linkid=9650735___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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


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

[rt-users] Victor Da Fonseca/KW/ECS/SCHINDLER est absent(e).

2009-03-16 Thread victor . da . fonseca

Je serai absent(e) du  16/03/2009 au 20/03/2009.

I'am out of office between 16/03/2009 and 20/03/2009. Mail is not
forwarded.


*
Nota : Les informations contenues dans ce message sont 
exclusivement destineacute;es aux personnes nommeacute;es ci-
dessus et peuvent contenir des donneacute;es confidentielles ou 
proteacute;geacute;es.Une erreur de transmission n'entraicirc;ne
aucune renonciation agrave; la onfidentialiteacute; de ces 
donneacute;es. Si vous n'ecirc;tes pas le destinataire 
preacute;vu de ce message, vous ecirc;tes informeacute;que vous 
ne devez pas l'utiliser, le divulguer ou le copier, sous quelque 
forme que ce soit.Si vous avez reccedil;u ce courrier 
eacute;lectronique par erreur, merci de le supprimer ainsi que 
seseacute;ventuelles copies et d'informer immeacute;diatement 
l'expeacute;diteur.br
Notice : The information contained in this message is intended 
only foruse of the individual(s) named above and may contain 
confidential,proprietary or legally privileged information. No 
confidentiality or privilege is waived or lost by any 
mistransmission. If you are not the intended recipient of this 
message you are hereby notified that you must not use, 
disseminate, copy it in any form or take any action in reliance of 
it. If you have received this message in error please delete it 
and any copies of it and notify the sender immediately. 
**
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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


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


[rt-users] CreatedMonthly Graphs broken with Custom Field parameter?

2009-03-16 Thread Addam Schroll
I have a RT 3.8.2 instance setup and I like to use the CreatedMonthly
bar graph to see ticket histories.  The graph, however, appears to break
if you try to use it with a search that includes a custom field parameter.

For example, if I search for all tickets in our firewall queue with the
Request Type custom Field set to any valid value, I get a blank graph
with no totals at the bottom.  I also see the following warnings in the
RT logs.

[Mon Mar 16 20:56:28 2009] [warning]: DBD::mysql::st execute failed:
Column 'Created' in field list is ambiguous at
/usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 505.
(/usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm:505)

[Mon Mar 16 20:56:28 2009] [warning]: RT::Handle=HASH(0x985ec6c)
couldn't execute the query 'SELECT DISTINCT COUNT(main.id) AS id,
SUBSTR(Created,1,7) AS createdmonthly FROM Tickets main JOIN
ObjectCustomFieldValues ObjectCustomFieldValues_1  ON (
ObjectCustomFieldValues_1.CustomField = '7' ) AND (
ObjectCustomFieldValues_1.ObjectType = 'RT::Ticket' ) AND (
ObjectCustomFieldValues_1.Disabled = '0' ) AND (
ObjectCustomFieldValues_1.ObjectId = main.id )  WHERE (main.Status !=
'deleted') AND (main.Queue = '4' AND  (  (  (
ObjectCustomFieldValues_1.Content LIKE '%Host Add Request%' OR  (  (
ObjectCustomFieldValues_1.Content = '' OR
ObjectCustomFieldValues_1.Content IS NULL )  AND
ObjectCustomFieldValues_1.LargeContent LIKE '%Host Add Request%' )  )  )
 ) ) AND (main.Type = 'ticket') AND (main.EffectiveId = main.id)  GROUP
BY SUBSTR(Created,1,7) ' at
/usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 518

Has anyone else run into this issue?  Anyone found a workaround or solution?

Thanks,
Addam

--
Addam Schroll
IT Security and Privacy Analyst
IT Networks  Security, Purdue University
ad...@purdue.edu

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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


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


[rt-users] FW: RTFM installation problem

2009-03-16 Thread shaker Khzym










Hi
  I try to install RTFM and I got this error when I ran make initdb

/usr/bin/perl -Ilib -I/opt/rt3/local/lib -I/opt/rt3/lib
/opt/rt3/sbin/rt-setup-database --action schema --datadir etc --dba
RT2 --prompt-for-dba-password
Setuid/gid script is writable by world.
...returned with error: 6400
make: *** [initdb] Error 25

any help 
Shaekir,



_
Share photos with friends on Windows Live Messenger
http://go.microsoft.com/?linkid=9650734___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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


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

[rt-users] RT Performance - Intermittent slow spells

2009-03-16 Thread Aaron Guise
Hi,
We are currently having some intermittent problems where our RT stops
responding.  I have isolated this I think to a database problem of some
sort.  I turned on Slow Query logging and this is what MySQL picked up.  Any
ideas what may cause such performance issues.  It is intermittent but very
annoying when it does occur.  I have tuned the DB with mysqltuner and when
it does run proper then it really hums along.

# Time: 090317 12:42:29
# u...@host: rt[rt] @ localhost []
# Query_time: 11  Lock_time: 0  Rows_sent: 1  Rows_examined: 0
SELECT GET_LOCK('Apache-Session-288c54fb38d789956edc518ca4321abb', 3600);
# u...@host: rt[rt] @ localhost []
# Query_time: 11  Lock_time: 0  Rows_sent: 1  Rows_examined: 0
SELECT GET_LOCK('Apache-Session-288c54fb38d789956edc518ca4321abb', 3600);
# u...@host: rt[rt] @ localhost []
# Query_time: 11  Lock_time: 0  Rows_sent: 1  Rows_examined: 0
SELECT GET_LOCK('Apache-Session-288c54fb38d789956edc518ca4321abb', 3600);

-- 
Regards

Aaron
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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


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

[rt-users] sort by Custom field

2009-03-16 Thread Matt Hoover
I have some users asking to be able to CLICK on the headers in a search.
Headers that contain custom fields are not clickable.  How can I make them
functional and clickable by our users?

Matt
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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


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