RE: [rt-users] CustomField is deleted automatically after modified by a scrip

2006-05-11 Thread David Di
Hi Steve, Thanks for the reply and what you explained was just what I suspected. But in this case how can I set a CF's value as the purpose of a scrip is to do the job without manual intervention. This one sometimes works but not stable so I can't make sure it always work and so I can't put it in

Re: [rt-users] TicketCustomFieldValues = ObjectCustomFieldValues ?

2006-05-11 Thread Mike Patterson
I think I figured it out. TicketCustomFieldValues -> ObjectCustomFieldValues and TicketCustomFieldValues.Ticket -> ObjectCustomFieldValues.ObjectId This solves all the issues I'm experiencing. Thanks, Mike -- Mike Patterson Systems Manager UC Berkeley Extension _

[rt-users] TicketCustomFieldValues = ObjectCustomFieldValues ?

2006-05-11 Thread Mike Patterson
I just came across another snag in my migration (3.4.2 -> 3.4.5) migration slap my wrist for not using RT's API... however we already have a bunch of reports calling on the mysql database table TicketCustomFieldValues and I don't want overhaul all those pages just yet. Can I simply substitute

[rt-users] Re: [3.6][FIX] Searches by custom fields

2006-05-11 Thread Joshua Colson
On Thu, 2006-05-11 at 21:55 +0400, Ruslan Zakirov wrote: > I reproduced problem when people search by one field with several > restrictions, for example "CF.{cf1} = 'foo' OR CF.{cf1} = 'bar'". > Also, change should fix issue when RT generate wrong SQL query with > reference to 'main.name' column th

Re: [rt-users] Binary Attachments Corrupted in Migration to new box

2006-05-11 Thread Mike Patterson
Todd, That fixed it. Thanks, Mike Todd Chapman wrote: Ithin you have to mysqldump with: --default-character-set=binary -Todd On Wed, May 10, 2006 at 08:36:41AM -0700, Mike Patterson wrote: My binary attachments (spreadsheets, screenshots, etc..) got corrupted after migrating to a new b

Re: [rt-users] Second question about Command Line interface

2006-05-11 Thread Tomasz Wlodek
And my followup question about granting use rights using command line interface. In the rt code I have found a routine: sub grant { my ($cmd) = @_; my $revoke = 0; while (@ARGV) { } $revoke = 1 if $cmd->{action} eq 'revoke'; } This routine does not seem to be doing anything

[rt-users] Re: Request Tracker

2006-05-11 Thread taan
The AdminCC can't see what is in the Approvals queue by clicking on the Approvals tab, onlt the Approval Ticket Owner can. However the AdminCC should be able to view the Ticket requiring Approval and from there, under links depends on, open the Approval Ticket and change the Owner. Of coarse, as

[rt-users] Second question about Command Line interface

2006-05-11 Thread Tomasz Wlodek
Ok and here is my second question about CLI. When I create users using CLI they are created as unprivileged users. Which means that they cannot even edit their own user information. How can I grant them rights using CLI? I would like evey user to be able to modify their information and post ticke

[rt-users] Command line interface problems

2006-05-11 Thread Tomasz Wlodek
Hi, I have two questions regarding the command line interface. Its description in the book is sketchy, at best. I want to create users using command line interface. I do /usr/bin/rt create -t user set username=test [EMAIL PROTECTED] password=test8 I want to create user with username (for login)

Re: [rt-users] RT3.6 bug/feature report!

2006-05-11 Thread Todd Chapman
On Thu, May 11, 2006 at 11:59:58AM -0400, Jesse Vincent wrote: > Does anyone feel that this change should _not_ be reversed? Should the > change only trigger if two txns are recorded? Should that second > transaction simply be run as the RT_System user? > My first preference would be to record th

Re: [rt-users] mandatory fields (to be filled in)?

2006-05-11 Thread Joshua Colson
On Thu, 2006-05-11 at 15:48 -0400, joe wrote: > Is it possible to add a field that is mandatory to be filled in? > > Joe You can add a mandatory custom field in 3.6. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help:

[rt-users] mandatory fields (to be filled in)?

2006-05-11 Thread joe
Is it possible to add a field that is mandatory to be filled in? Joe ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets

Re: [rt-users] RT3.6 bug/feature report!

2006-05-11 Thread Kenneth Crocker
Jesse Vincent wrote: Does anyone feel that this change should _not_ be reversed? Should the change only trigger if two txns are recorded? Should that second transaction simply be run as the RT_System user? On Thu, May 11, 2006 at 11:30:51AM -0400, Stephen Turner wrote: At Thursday 5/11/2006

[rt-users] Error with ticket search builder

2006-05-11 Thread Flynn, Timothy J
I am getting this error in the bottom right screen of search builder periodically. Any ideas? System is RT 3.4.5 on Postgres 8.1 error: RT::Attribute::Name Unimplemented in RT::Attributes. (/usr/local/rt3/lib/RT/Attributes_Overlay.pm line 81) context: ... 492:else { 4

[rt-users] Attachments on RT not being sent on the email

2006-05-11 Thread Pablo Povarchik
Hello Should RT send the uploaded files (attachments) on the correspondence email? If yes, it's not working on our RT, how do we workaround this? Thanks -- Pablo Povarchik de Carrasquedo Quality Colocation and Dedicated Servers services Colocation facilities include F

Re: [rt-users] Prevent queue mailing back

2006-05-11 Thread JB Segal
Quoth Ruslan Zakirov ([EMAIL PROTECTED]): > From FAQ: "search in mail archives". > http://marc.theaimsgroup.com/?l=rt-users&w=2&r=1&s=disable+scrip&q=b Thanks. I'd searched before - a month or 2 ago, the last time I was thinking about this - and not found anything. I have no idea what I searched o

Re: [rt-users] Prevent queue mailing back

2006-05-11 Thread Ruslan Zakirov
From FAQ: "search in mail archives". http://marc.theaimsgroup.com/?l=rt-users&w=2&r=1&s=disable+scrip&q=b Solutions: http://marc.theaimsgroup.com/?l=rt-users&m=114125434731313&w=2 http://marc.theaimsgroup.com/?l=rt-users&m=114735506430230&w=2 http://marc.theaimsgroup.com/?l=rt-users&m=11473570941

[rt-users] Re: [3.6][FIX] Searches by custom fields

2006-05-11 Thread Ruslan Zakirov
I reproduced problem when people search by one field with several restrictions, for example "CF.{cf1} = 'foo' OR CF.{cf1} = 'bar'". Also, change should fix issue when RT generate wrong SQL query with reference to 'main.name' column that doesn't exist. If you see other issues feel free to send lin

Re: [rt-users] Re: [3.6][FIX] Searches by custom fields

2006-05-11 Thread Joshua Colson
On Thu, 2006-05-11 at 10:37 -0700, Joshua Colson wrote: > At least in the 3.6 version, RT now supports the following in the > RT_SiteConfig to log SQL queries: > > Set($StatementLog, ''); > > ... for example: > > > > Set($StatementLog, 'debug'); > > > > will log all SQL statements when log

Re: [rt-users] Global Scrip, but individually removeable?

2006-05-11 Thread Kenneth Crocker
Peter Collins wrote: I've got version 3.2.3 right now. Let's say I have a global scrip that I want to apply to MOST of the queues but not all. The only way I can see to do this is to delete the scrip from the global scrip place and then recreate it one by one for all the queues except the one

[rt-users] Re: [3.6][FIX] Searches by custom fields

2006-05-11 Thread Joshua Colson
On Thu, 2006-05-11 at 13:08 -0400, Rangarajan Radhakrishnan wrote: > Will it be possible for you to put a debug statement in > DBIx::SearchBuilder as part of DoQuery that prints out the > QueryString. > > Details in this thread: > http://lists.bestpractical.com/pipermail/rt-users/2006-May/039168.

[rt-users] Queue contents not visible

2006-05-11 Thread Jay Vlavianos
Title: Queue contents not visible This should be a permissions issue, but no matter permissions I give to myself I can’t see the contents of a queue. Now this queue is an approval queue where the tickets are created via a template, but it there something specific about the ticket creation th

[rt-users] Re: [3.6][FIX] Searches by custom fields

2006-05-11 Thread Rangarajan Radhakrishnan
Joshua, I am somewhat tied up with other stuff, but will give it a shot as soon as I get a chance. Will it be possible for you to put a debug statement in DBIx::SearchBuilder as part of DoQuery that prints out the QueryString. Details in this thread: http://lists.bestpractical.com/pipermail/

Re: [rt-users] basic info about localisation (I want to "translate" RT to Greek)

2006-05-11 Thread Joshua Colson
On Thu, 2006-05-11 at 19:35 +0300, Nick Demou wrote: > thanks Joshua - I've read the sample chapter online and it seems a > good book anyway > If I have any problems later should I ask here or on the devel list? No problem. It is probably more appropriate on the rt-devel list. -- Joshua Colson <

Re: [rt-users] RT3.6 bug/feature report!

2006-05-11 Thread Joshua Colson
On Thu, 2006-05-11 at 11:59 -0400, Jesse Vincent wrote: > Does anyone feel that this change should _not_ be reversed? Should the > change only trigger if two txns are recorded? Should that second > transaction simply be run as the RT_System user? I tend to agree with the OP. It seems to me that li

Re: [rt-users] basic info about localisation (I want to "translate" RT to Greek)

2006-05-11 Thread Jesse Vincent
On Thu, May 11, 2006 at 01:52:29PM +0300, Nick Demou wrote: > I've spent some time with RT and I liked it :-). So now I am willing > to begin translating most texts to my language (Greek) so that other > people can feel more comfortable with the web interface and the > automated emails. I would

Re: [rt-users] Lack of trailing slash causing porblems in IE

2006-05-11 Thread JB Segal
Quoth Brendan Arnold ([EMAIL PROTECTED]): > Hi again, > > I still have the problem. I have found out some more information > though. After checking the logs it seems that IE, when submitting the > form info, actually does not generate a log entry. Also the 'Page > cannot be found' error appears al

Re: [rt-users] basic info about localisation (I want to "translate" RT to Greek)

2006-05-11 Thread Nick Demou
2006/5/11, Joshua Colson <[EMAIL PROTECTED]>: On Thu, 2006-05-11 at 13:52 +0300, Nick Demou wrote: > I've spent some time with RT and I liked it :-). So now I am willing > to begin translating most texts to my language (Greek) so that other > people can feel more comfortable with the web interfac

Re: [rt-users] Prevent queue mailing back

2006-05-11 Thread JB Segal
Quoth Ruslan Zakirov ([EMAIL PROTECTED]): > On 4/3/06, Michael Shanks <[EMAIL PROTECTED]> wrote: > > Hello, > > > > Could someone point me in the right direction, I have several queues setup > > that I don't want mailing back when an e-mail is submitted, how is this > > achieved? > > > > Delte auto

Re: [rt-users] RT3.6 bug/feature report!

2006-05-11 Thread Jesse Vincent
Does anyone feel that this change should _not_ be reversed? Should the change only trigger if two txns are recorded? Should that second transaction simply be run as the RT_System user? On Thu, May 11, 2006 at 11:30:51AM -0400, Stephen Turner wrote: > At Thursday 5/11/2006 10:27 AM, Jesse Vincent w

[rt-users] Creating Templates/Scrip to reply to Failed Ticket Creation

2006-05-11 Thread Lawrence Wong
Hi all, I'm very new to RT having just installed RT-3.4.5 so apologies if my query has been answered before. I've tried searching the RT website as well as Google but couldn't find anything close. I noticed RT comes by default with a Scrip to cater for auto replying upon successful creation of a

Re: [rt-users] Notifying a certain user when a ticket is created in a Queue

2006-05-11 Thread John Boris
Steve, Thanks. I will look into that. This is all new to me. I did get a response about a Perl Module and I am in the process of trying to add that. This option is a good learning tool for me to see what is involved in creating templates and the other option is a learning tool for me to add module

Re: [rt-users] basic info about localisation (I want to "translate" RT to Greek)

2006-05-11 Thread Joshua Colson
On Thu, 2006-05-11 at 13:52 +0300, Nick Demou wrote: > I've spent some time with RT and I liked it :-). So now I am willing > to begin translating most texts to my language (Greek) so that other > people can feel more comfortable with the web interface and the > automated emails. I would be gratefu

[rt-users] Re: [3.6][FIX] Searches by custom fields

2006-05-11 Thread Joshua Colson
On Thu, 2006-05-11 at 11:53 +0400, Ruslan Zakirov wrote: > Hello. > > I've commited fixes several fixes into 3.5 branch that should fix > issues with searches by CFs. > Please test it with your test cases and report back. > I've downloaded the current release of 3.5-TESTING (5204), built it an

Re: [rt-users] RT3.6 bug/feature report!

2006-05-11 Thread Sven Sternberger
On Thu, 2006-05-11 at 10:27 -0400, Jesse Vincent wrote: > On Thu, May 11, 2006 at 03:58:11PM +0200, Sven Sternberger wrote: > > I noticed that ther is a difference between 3.0 and 3.6rc1 in the > > access rights handling > > That's correct. There were complaints about the old behaviour. I can't >

Re: [rt-users] RT3.6 bug/feature report!

2006-05-11 Thread Stephen Turner
At Thursday 5/11/2006 10:27 AM, Jesse Vincent wrote: On Thu, May 11, 2006 at 03:58:11PM +0200, Sven Sternberger wrote: > Hello! > > I noticed that ther is a difference between 3.0 and 3.6rc1 in the > access rights handling That's correct. There were complaints about the old behaviour. I can't r

Re: [rt-users] RT3.6 bug/feature report!

2006-05-11 Thread Jesse Vincent
On Thu, May 11, 2006 at 03:58:11PM +0200, Sven Sternberger wrote: > Hello! > > I noticed that ther is a difference between 3.0 and 3.6rc1 in the > access rights handling That's correct. There were complaints about the old behaviour. I can't remember if simply changing the default about how man

[rt-users] RT3.6 bug/feature report!

2006-05-11 Thread Sven Sternberger
Hello! I noticed that ther is a difference between 3.0 and 3.6rc1 in the access rights handling Situation: Two Queues named qa and qb. The user has the right to modify tickets in qa but not in qb. In 3.0 it is possible, to set a link from a ticket in qa to to a ticket in qb. In 3.6 I get permiss

Re: [rt-users] Global Scrip, but individually removeable?

2006-05-11 Thread Jesse Vincent
On Thu, May 11, 2006 at 09:43:31AM -0400, Stephen Turner wrote: > At Wednesday 5/10/2006 09:57 PM, Peter Collins wrote: > > > >I've got version 3.2.3 right now. > > > >Let's say I have a global scrip that I want to apply to MOST of the queues > >but not all. The only way I can see to do this is to

Re: [rt-users] CustomField is deleted automatically after modified by a scrip

2006-05-11 Thread Stephen Turner
At Thursday 5/11/2006 03:52 AM, David Di wrote: I encountered a strange problem when setting value for a custom field. If anyone can give me a lead that will be appreciated. Note: this action is to set current transaction user to be the Evaluator, fill in his real name instead of RT id. Hi

Re: [rt-users] Global Scrip, but individually removeable?

2006-05-11 Thread Stephen Turner
At Wednesday 5/10/2006 09:57 PM, Peter Collins wrote: I've got version 3.2.3 right now. Let's say I have a global scrip that I want to apply to MOST of the queues but not all. The only way I can see to do this is to delete the scrip from the global scrip place and then recreate it one by one fo

Re: [rt-users] Notifying a certain user when a ticket is created in a Queue

2006-05-11 Thread Stephen Turner
At Wednesday 5/10/2006 05:01 PM, John Boris wrote: Can a scrip be written that will notify a set of users that a ticket has been created in a queue without assigning the ticket to that user or making that person an AdminCc? I don't want to send a bunch of duplicate emails. I want the certain gr

[rt-users] Error while starting the Apache Server

2006-05-11 Thread Prasad Deshpande
Hi,   I am using RT 3.2.3 on Red Hat 9, When I am starting the Apache Server it gives following error message.   Using an array as a reference is deprecated at /usr/local/lib/perl5/site_perl/5.8.5/Date/Format.pm line 88.   Will this message affect the RT functionality ?   Also I am

[rt-users] basic info about localisation (I want to "translate" RT to Greek)

2006-05-11 Thread Nick Demou
I've spent some time with RT and I liked it :-). So now I am willing to begin translating most texts to my language (Greek) so that other people can feel more comfortable with the web interface and the automated emails. I would be gratefull if you could you give me some pointers to related informa

[rt-users] CustomField is deleted automatically after modified by a scrip

2006-05-11 Thread David Di
Title: Message I encountered a strange problem when setting value for a custom field. If anyone can give me a lead that will be appreciated. The background of this problem is listed below:     RT version: 3.4.3 CustomField: Evaluator     Type- Enter one value,     Applied to: Tickets,   

[rt-users] [3.6][FIX] Searches by custom fields

2006-05-11 Thread Ruslan Zakirov
Hello. I've commited fixes several fixes into 3.5 branch that should fix issues with searches by CFs. Please test it with your test cases and report back. -- Best regards, Ruslan. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users C