Re: [rt-users] Ticket Data Seems Broken

2009-09-04 Thread Tim Gustafson
> If you are on RT 3.8.3 and newer then you can use > rt-validator to check consistency of the DB. This mostly worked. It ran and fixed enough stuff to make this particular ticket display properly, but then reported: DBD::mysql::st execute failed: The SELECT would examine more than MAX_JOIN_SIZ

Re: [rt-users] RT API

2009-09-04 Thread Ruslan Zakirov
Hello Rich, On Fri, Sep 4, 2009 at 9:20 PM, Rich West wrote: > I've gone down the phase 1 route with building a web submission system > for RT customized to our organization using the commandsbyemail > extension.  Oddly, I am having periodic problems with it where, some > times, the commands do no

Re: [rt-users] Ticket Data Seems Broken

2009-09-04 Thread Ken Crocker
Tim, The history for any ticket comes from the Transaction Table. Each Transaction record has Id's in the fields that reference what the transaction is about. For example, you have a ticket with a CF of ID #3. The value of that Custom Field exists in the ObjectCustomFieldValue Table. That tran

Re: [rt-users] Ticket Data Seems Broken

2009-09-04 Thread Ruslan Zakirov
Hello Tim, If you are on RT 3.8.3 and newer then you can use rt-validator to check consistency of the DB. On Sat, Sep 5, 2009 at 12:17 AM, Tim Gustafson wrote: > I have a ticket in my system that when you view the "Basics" screen, you > don't see all the History.  Instead, you get about 4-5 rows

Re: [rt-users] Redirect sending http-status code 200 instead of 302

2009-09-04 Thread Ruslan Zakirov
Hello Otmar, This issue has been fixed in RT 3.8.3. On Fri, Sep 4, 2009 at 7:07 PM, Otmar Lendl wrote: > > Hi, > > Versions: > > RT 3.8.2, RTIR 2.4.1, Apache 2.2.9, mod-perl2 2.0.4, Mason 1.39 > > Symptoms: > > Urls like .../rt/Ticket/Display.html?Action=Take&id=16522 execute the > Take, but don'

[rt-users] Ticket Data Seems Broken

2009-09-04 Thread Tim Gustafson
I have a ticket in my system that when you view the "Basics" screen, you don't see all the History. Instead, you get about 4-5 rows of history, and then you see: Can't call method "Name" on an undefined value at /usr/local/lib/perl5/site_perl/5.8.9/RT/Transaction_Overlay.pm line 700. I'm ass

[rt-users] RT API

2009-09-04 Thread Rich West
I've gone down the phase 1 route with building a web submission system for RT customized to our organization using the commandsbyemail extension. Oddly, I am having periodic problems with it where, some times, the commands do not get recognized (my guess is that the developer who created the pages

Re: [rt-users] MIME in RT.

2009-09-04 Thread Jesse Vincent
On Fri, Sep 04, 2009 at 08:50:55PM +0530, H Manohar rayker wrote: > Hi, > > > > Mails received to RT with "Content-type: multipart/mixed; > boundary="--=_1252065429-28139-0" in the mail header info are not > getting displayed back while replying or corresponding back VIA RT ( i.e, >

[rt-users] MIME in RT.

2009-09-04 Thread H Manohar rayker
Hi, Mails received to RT with "Content-type: multipart/mixed; boundary="--=_1252065429-28139-0" in the mail header info are not getting displayed back while replying or corresponding back VIA RT ( i.e, transaction->content) However Content-Type: text/plain; charset="utf-8" will get

[rt-users] Redirect sending http-status code 200 instead of 302

2009-09-04 Thread Otmar Lendl
Hi, Versions: RT 3.8.2, RTIR 2.4.1, Apache 2.2.9, mod-perl2 2.0.4, Mason 1.39 Symptoms: Urls like .../rt/Ticket/Display.html?Action=Take&id=16522 execute the Take, but don't show the Ticket. Debugging: The problem seems to be that RT redirects to itself to show the ticket with an URL that is

[rt-users] How to modify home-page queries

2009-09-04 Thread Roode, Eric
All, My search-fu is weak, it seems. How do I modify the standard queries that appear on the home page? The "highest priority tickets I own" and "newest unowned tickets", that is. The reason I ask is that we have created custom status codes, and any tickets with those status codes do

Re: [rt-users] RT-Users Digest, Vol 66, Issue 16

2009-09-04 Thread josé fernandez
ERE MISSING. > MASON missing dependencies: > XML:: RSS> = 1.05 ... MISSING > make: *** [testdeps] Error 1 > > I do not know how to install this dependency, because I went on the CPAN > website but I found nothing. > > Have you any

Re: [rt-users] Logging into rt.log from Scrips

2009-09-04 Thread Ruslan Zakirov
Hello Baskar, Set( $LogToFile, 'debug' ); $RT::Logger->debug("here is my test message"); On Fri, Sep 4, 2009 at 4:33 PM, Baskaraganesan Natarajan wrote: > Hi, > > > > I am writing scrips to customize my RT in Fedora 9 with MySQL back-end.  I > have configured RT to log into a file (rt.log) in RT

Re: [rt-users] Some users are losing their rights every night

2009-09-04 Thread Nathan Hurt
Hi All, This is an older issue I asked for help on awhile back. It has since been resolved and I wanted to make sure to share my experience with the community. The issue was users were seemingly losing their rights every night. The issue was user error. They had all navigated to the log in (pr

[rt-users] Logging into rt.log from Scrips

2009-09-04 Thread Baskaraganesan Natarajan
Hi, I am writing scrips to customize my RT in Fedora 9 with MySQL back-end. I have configured RT to log into a file (rt.log) in RT_SiteConfig.pm. Is it possible to get debug messages printed into the log file. I have added some print statements in scripts. I don't find them printed in rt.log

Re: [rt-users] Error - DBD::mysql::st execute failed: MySQL server has gone away

2009-09-04 Thread Nimbius
mysql server gone away is an indication there is a problem with the backend database serving RT. enable debugging in your mysql daemon and analyze the output for failures. is your mysql local or remote? make sure firewall settings permit remote connections. On Fri, 4 Sep 2009, Baskaraganesa

[rt-users] SOME DEPENDENCIES WERE MISSING. MASON missing dependencies

2009-09-04 Thread josé fernandez
Hello, has installed RT when running 'make fixdeps' is I always ended the following message: SOME DEPENDENCIES WERE MISSING. MASON missing dependencies: XML:: RSS> = 1.05 ... MISSING make: *** [testdeps] Error 1 I do not know how to install this dependency, because I went on the CPAN websi

Re: [rt-users] Transaction content empty.

2009-09-04 Thread H Manohar rayker
Hi, Hurrayyy... started working, just cleared off the old rt sessions. Thanks Manohar _ From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of H Manohar rayker Sent: Friday, September 04, 2009 12:52 PM To: rt-users@lists.b

[rt-users] Error - DBD::mysql::st execute failed: MySQL server has gone away

2009-09-04 Thread Baskaraganesan Natarajan
Retrying... From: Baskaraganesan Natarajan Sent: Friday, September 04, 2009 2:46 PM To: 'rt-users@lists.bestpractical.com' Subject: Error - DBD::mysql::st execute failed: MySQL server has gone away Sensitivity: Confidential Hi, I have RT up in a Fedora 9 box. It

[rt-users] Error - DBD::mysql::st execute failed: MySQL server has gone away

2009-09-04 Thread Baskaraganesan Natarajan
Hi, I have RT up in a Fedora 9 box. It was working properly. All of a sudden I see the following error when trying to create a ticket. DBD::mysql::st execute failed: MySQL server has gone away at /usr/lib/perl5/vendor_perl/5.10.0/Apache/Session/Lock/MySQL.pm line 71. I saw the same message i

[rt-users] Error - DBD::mysql::st execute failed: MySQL server has gone away

2009-09-04 Thread Baskaraganesan Natarajan
Hi, I have RT up in a Fedora 9 box. It was working properly. All of a sudden I see the following error when trying to create a ticket. DBD::mysql::st execute failed: MySQL server has gone away at /usr/lib/perl5/vendor_perl/5.10.0/Apache/Session/Lock/MySQL.pm line 71. I saw the same message i

[rt-users] Transaction content empty.

2009-09-04 Thread H Manohar rayker
Hi, Recently I made a new setup for RT3.8.4. All the things were working fine before couple of days, as of now I'm not getting any transaction content in the correspondence mails we receive when a ticket is created. Here below are the main templates. *)Autoreply templpate: Subject: