[rt-users] Possible "My Tickets" bug
rt-3.6.0pre1 SearchBuilder-1.43 The default saved search for "My Tickets" is defined as: Owner = '__CurrentUser__' OR AdminCc.Name LIKE '__CurrentUser__' however '__CurrentUser__' is converted to the UserID number which is resolved for Owner but not for AdminCC.Name (even if "LIKE" is changed to "="). Taan ___ 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 with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
[rt-users] ExtractCustomFieldValues Scrip
Hi all, Does anyone have or know where I can find out more info on this scrip? Or some sort of a tutorial on how to use / install etc? I know I need the scrip if I want to extract the customer field values from forms submitted to RT, but I'm having trouble finding much info about the specifics... Regards, Anthony ___ 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 with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
[rt-users] editing the predefined search
Can someone please confirm that the only ACL that allows users to "edit the predefined search" via the "RT at glance" page is "SuperUser" thanks Taan ___ 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 with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
Re: [rt-users] Re: Request Tracker
Make sure an owner is assigned to the approval ticket and that they have the correct ACLs. For some reason even though I give privileged users the required access I still had to assign appropriate ACL's on a per queue basis (ie to the Approval queue). Hope this helps. Taan [EMAIL PROTECTED] wrote: Sorry, Craig. Im still stucked here. Philip Kine gave some points on approval but it doesn't work for me (Subject: How to debug RT better). You also try it and hopefully you give me feedback. TY Hi, I saw your post on the Request Tracker mailing list regarding the Approvals no longer showing up. I'm having the same problem after upgrading. Did you ever get an answer? ___ 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 with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
[rt-users] Re: Request Tracker
Sorry, Craig. Im still stucked here. Philip Kine gave some points on approval but it doesn't work for me (Subject: How to debug RT better). You also try it and hopefully you give me feedback. TY > Hi, > > > > I saw your post on the Request Tracker mailing list regarding the > Approvals no longer showing up. I'm having the same problem after > upgrading. Did you ever get an answer? > > > > Thanks, > > > > Craig McDaniel > > Per-Sé Technologies > > > > This E-mail message is for the sole use of the intended recipient(s) and > may contain confidential and privileged information. Any unauthorized > review, use, disclosure or distribution is prohibited. If you are not the > intended recipient, please contact the sender by reply E-mail, and destroy > all copies of the original message. > ___ 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 with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
Re: [rt-users] Cannot assign ticket
William Catlan wrote: Kenn, I appreciate the confirmation that the feature works. I have tried a number of different ways, including the more granular use of permissions at the queue level. Can you share the exact permissions you give to a group to allow them to assign an owner to a ticket using People -> Owner driop down, as well as the exact permissions you give to a group to allow them to be assigned a ticket? I think I've tried all reasonable configurations, and it is not working for me. My version of RT is 3.4.5 ... what version are you running? Thanks, Bill -Original Message- From: Kenneth Crocker [mailto:[EMAIL PROTECTED] Sent: Friday, May 05, 2006 2:21 PM To: William Catlan Cc: Ruslan Zakirov; rt-users@lists.bestpractical.com Subject: Re: [rt-users] Cannot assign ticket William Catlan wrote: 3.6. Assigning a Ticket Tickets can have an owner-the user responsible for working on the ticket or for coordinating the work. To assign a ticket to someone, go to the People form from the ticket display page, and select the user from the Owner drop-down list, as shown in Figure 3-7. This list contains the usernames of all the users allowed to own tickets in the ticket's current queue. I try this, and only "Nobody" appears as an option. Grant right OwnTicket to groups/users who should be able to OwnTicket. http://wiki.bestpractical.com/?OwnTicket Thanks Ruslan. Of course, I did grant that right to a group, at both the Queue and Global levels, along with SeeQueue, but I still could not assign a ticket to someone in the group. I am hoping that someone will confirm this is a bug, or show me something I missed. Bill ___ 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 with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html Bill, If you already have a group with the correct permissions to see a ticket (seeQueue, SeeTicket, etc.) for a specific Queue, why in the world do you also grant any global rights at all? The whole point of making a Queue have group specific rights allows much more specific de-bugging when it comes to problems like this,. I think too many users of RT use the "shotgun" approach to granting rights and privileges. GLobal stuff just might be negateing any Queue specific group rights. It's almost like a programmer who isnb't sure he checked for something in his code so he puts the same code that does the checking all over the progrm. It's redundant and makes everything much more difficult to debug. I think you need to go back to the drawing board on rights and decide how to tighten up the rights by being specific, not global and then see what you get and debug from there. That is how ours is set up and we have 23 Queues (for individual IT software support groups ) and more than twice than many groups (1 group for technical support of an application and 1 group for the user - who get less rights). Plus, we have created an approval workflow that allows for a specific Queue to hande the review/approval/rejection process for several other Queues and ALL work and documentation stays with the original ticket number, even though the original ticket make be moved to different Queues. This cannot be done when you have a bunch of shotgun/global rights floating around. Hopes this concept helps. Kenn Will, This will take a bit of time to walk thru but, here goes. First, we create a Queue (meaningful name - of course). Someone who is a superuser must do this. Then we set up globally (for each person assigned as the AdminCC of said Queue) one roght only "SeeConfigTab". This allows the AdminCc to administrate his own Queue. We also set up globally for "everyone" all the CreateSavedSearch, EditSavedSearch, etc proviliges.). For global stuff, that's it. Now, create a group and name it for it's function pertaining to the Queue your going to give it rights to, ie. Queuename-Technicians, or Queuename-Support, Queuename-users. By creating groups, you save yourself the redundant effort of setting up individuals with the same rights to the same Queues. So. create a group. Then add some members. Remember, you can have any number of groups with different or the same rights to a Queue. Once you have created the group and populated it, give each group it's own set of priviliges as pertains to A single Queue. So you go into Configuration (the same superuser is doing this), then Queue, pick the Queue, then slip down to group rights (on the lefthand side of the screen) and click that. These rights all pertain to the Queue level only so
Re: [rt-users] Re: How to debug RT3 better
Hi Philip, Thanks for your response. My approval system was working when I'am still using 3.0.5. But after I upgraded to 3.4.5, this no longer works. I still tried your suggestion. I checked the permissions (even select everything) and reviewed the wiki. I checked the rt.log (full) and see nothing there. >> It's currently working except from the approval link which doesn't > show anything even I > selected pending, approved or denied, etc. > > One thing I found when implementing an Approvals system was that testing > is impossible without two user IDs. If you try to open a ticket needing > approval and try to approve it yourself etc., the RT mechanisms to > prevent viscious circle emails and spurious replies mess this up. Create > a test user to open tickets needing approval and if you're using the > GUI, log them in in a separate browser (I even used IE for the test user > and firefox for the approver because if you've every selected "remember > my password" or whatever in a broswer, it'll auto-log you in when you > click links in the GUI etc.). I could get nothing to appear in the > approvals section until I did this. Approvals is pretty tricky to set > up. You need lots of custom scrips and an idea of how you want it to > work. I have a system for it which may or may not be of use to people > which I can wikify if desireable. It took me a long time to make it work > but it's not complex once it's all working. > ___ > 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 with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > > > We're hiring! Come hack Perl for Best Practical: > http://bestpractical.com/about/jobs.html > ___ 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 with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
[rt-users] There is a podcast interview with Jesse..
on http://www.perlcast.com - all about Jifty. Very interesting, check it out if haven't already. -- Scott T. Hildreth <[EMAIL PROTECTED]> ___ 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 with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
[rt-users] How to delete users?
Hi, Due to some testing I had to create several fake users in RT. Those users were never added to any group, ever posted anything, never created any ticket. Now I need to delete them. The manual says that you cannot delete users, only disable them. Well, I do not believe that I cannot do what I want. I want to delete them in order not to pollute databases with junk. I want to go to rt database, go to table Users and execute mysql delete command on those users. This will delete them. But is it enough? Is the user information cross referenced somehow from other tables? Those users did not do any activity, so they do not own any tickets, and the like. I assume that they do not appear in any tables but Users, but I would like to be sure. Tomasz Wlodek| tel 631-344-7448 Brookhaven Laboratory, Building 510M | fax 631-344-7616 Upton NY 11973-5000 | ___ 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 with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
RE: [rt-users] Cannot assign ticket
Kenn, I appreciate the confirmation that the feature works. I have tried a number of different ways, including the more granular use of permissions at the queue level. Can you share the exact permissions you give to a group to allow them to assign an owner to a ticket using People -> Owner driop down, as well as the exact permissions you give to a group to allow them to be assigned a ticket? I think I've tried all reasonable configurations, and it is not working for me. My version of RT is 3.4.5 ... what version are you running? Thanks, Bill -Original Message- From: Kenneth Crocker [mailto:[EMAIL PROTECTED] Sent: Friday, May 05, 2006 2:21 PM To: William Catlan Cc: Ruslan Zakirov; rt-users@lists.bestpractical.com Subject: Re: [rt-users] Cannot assign ticket William Catlan wrote: >> 3.6. Assigning a Ticket >> >> Tickets can have an owner-the user responsible for working on the >> > ticket or > >> for coordinating the work. To assign a ticket to someone, go to the >> > People > >> form from the ticket display page, and select the user from the Owner >> drop-down list, as shown in Figure 3-7. This list contains the >> > usernames of > >> all the users allowed to own tickets in the ticket's current queue. >> >> I try this, and only "Nobody" appears as an option. >> > Grant right OwnTicket to groups/users who should be able to OwnTicket. > http://wiki.bestpractical.com/?OwnTicket > > Thanks Ruslan. Of course, I did grant that right to a group, at both > the Queue and Global levels, along with SeeQueue, but I still could not > assign a ticket to someone in the group. > > I am hoping that someone will confirm this is a bug, or show me > something I missed. > > Bill > ___ > 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 with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > > > We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html > > Bill, If you already have a group with the correct permissions to see a ticket (seeQueue, SeeTicket, etc.) for a specific Queue, why in the world do you also grant any global rights at all? The whole point of making a Queue have group specific rights allows much more specific de-bugging when it comes to problems like this,. I think too many users of RT use the "shotgun" approach to granting rights and privileges. GLobal stuff just might be negateing any Queue specific group rights. It's almost like a programmer who isnb't sure he checked for something in his code so he puts the same code that does the checking all over the progrm. It's redundant and makes everything much more difficult to debug. I think you need to go back to the drawing board on rights and decide how to tighten up the rights by being specific, not global and then see what you get and debug from there. That is how ours is set up and we have 23 Queues (for individual IT software support groups ) and more than twice than many groups (1 group for technical support of an application and 1 group for the user - who get less rights). Plus, we have created an approval workflow that allows for a specific Queue to hande the review/approval/rejection process for several other Queues and ALL work and documentation stays with the original ticket number, even though the original ticket make be moved to different Queues. This cannot be done when you have a bunch of shotgun/global rights floating around. Hopes this concept helps. Kenn ___ 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 with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
[rt-users] Fetchmail start-up on system boot
Guys, I as able to manage throw the configuration of fetchmail in order to poll my queue emails from my email Server. I create an account, set the .fetchmailrc and so. When starting the service (# /usr/bin/fetchmail) the app works fine. As finishing the job I wanted to add fetchmail to run when the system boots, so when to the /etc/rc.local and add the line /usr/bin/fetchmail. Unfortunatly this isn’t working… Anyone run throw the same problem/mistake?? Many Thanks Sebastian.- ___ 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 with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
RE: [rt-users] Distinguish between the comments in ticket
Searchable archive: http://lists.bestpractical.com/search.html Eric Schultz United Online From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kristopher LuskSent: Monday, May 08, 2006 12:59 PMTo: 'Kristopher Lusk'; rt-users@lists.bestpractical.comSubject: RE: [rt-users] Distinguish between the comments in ticket Hi again List, So, has this one been asked before? Oh, and I am running v. 3.2.2. Also, can someone provide me with a link to the/a searchable archive? Thanks, Kristopher From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kristopher LuskSent: Monday, May 08, 2006 9:15 AMTo: rt-users@lists.bestpractical.comSubject: [rt-users] Distinguish between the comments in ticket Is there is a way to color code the different comments in the RT ticket system? For example, if you want Customer Comments to appear differently than your Own (in-house) Comments, how could we accomplish this? ___ 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 with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
RE: [rt-users] Distinguish between the comments in ticket
Hi again List, So, has this one been asked before? Oh, and I am running v. 3.2.2. Also, can someone provide me with a link to the/a searchable archive? Thanks, Kristopher From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kristopher Lusk Sent: Monday, May 08, 2006 9:15 AM To: rt-users@lists.bestpractical.com Subject: [rt-users] Distinguish between the comments in ticket Is there is a way to color code the different comments in the RT ticket system? For example, if you want Customer Comments to appear differently than your Own (in-house) Comments, how could we accomplish this? ___ 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 with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
RE: [rt-users] User customfields not showing up in the user form
thanks Quoting Nathalie Gagnon <[EMAIL PROTECTED]>: Hi amit, It's not necessary to modify code. Into wed page of RT, verify if you selected your custom field into Configuration-global-custom field-users. After that, you grant rights to see or modify this custom field to users or groups you want to. I hope it will help you ! Take care! Nat Nathalie Gagnon Programmeure Les Industries Amisco Ltée L'Islet QC, G0R 2C0 [EMAIL PROTECTED] -Message d'origine- De: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED] Date: 8 mai, 2006 11:57 À: rt-users@lists.bestpractical.com Objet: [rt-users] User customfields not showing up in the user form Hi, I have created customfiedls which applies to Users. Since RT 3.4.5 allows us to create custom fields which apply to users or groups. But the custom field does not show up in the user form. There is a place in the user form to show the user custom fields but it is alway empty. I checked in the code. It seems that the code is trying to join CustomFields and ObjectCustomFields to get back a row which applies to the user in the form. But from the code it seems that a row in ObjectCustomFields is only created for Ticket customfields and not user and group customfields, and it is only created for ticket customfields when a queue is selected in "Applies To" form. But Applies to does not come up for the user custom fields. When I put a row in ObjectCustomFields with Object Id 0 (apply to all users) then I can see the customfield in the user form. Could someone please clarify why is a row not created in ObjectCustomFields for the user custom fields/or shouldnt' there be a applies to form for user custom fields so that we can select which user does the customfield applies to ? thanks amit ___ 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 with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html ___ 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 with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
Re: [rt-users] A bug? Searchbuilder?
Appears that the problem is happening because of presence of "main.name
= 'Tournummer'".
The problem happens because "main" is an alias for Tickets table and the
Tickets table has no column called "name".
What you run this SELECT query against the database (I deal with oracle,
you with MySQL) you are going to get some error:
Try running the following against your DB:
SELECT DISTINCT main.* FROM (((Tickets main LEFT JOIN
ObjectCustomFields ObjectCustomFields_1 ON (
ObjectCustomFields_1.ObjectId = main.Queue)) LEFT JOIN CustomFields
CustomFields_2 ON ( CustomFields_2.id =
ObjectCustomFields_1.CustomField)) LEFT JOIN ObjectCustomFieldValues
ObjectCustomFieldValues_3 ON ((ObjectCustomFieldValues_3.ObjectId =
main.id)) AND ( ObjectCustomFieldValues_3.CustomField =
CustomFields_2.id) AND ( (ObjectCustomFieldValues_3.Disabled = '0')) AND
( (ObjectCustomFieldValues_3.ObjectType = 'RT::Ticket'))) WHERE
((CustomFields_2.name = 'Tournummer')) AND ((main.EffectiveId =
main.id)) AND ((main.Status != 'deleted')) AND ((main.Type = 'ticket'))
AND ((main.name = 'Tournummer')) AND ( ( (main.Queue = '5') ) AND ( (
(ObjectCustomFieldValues_3.Content = '03376') ) OR (
(ObjectCustomFieldValues_3.Content = '03361') ) ) AND ( (main.Status =
'new')OR(main.Status = 'open')Or(main.Status = 'stalled')OR(main.Status
= 'resolved') ) )
The trouble is that we need to spend a lot more time trying to figure
out whether its a problem with DBIx::SearchBuilder or the code calling it.
Hopefully, somebody who knows will read our posts
Torsten Brumm wrote:
Hi Rangarajan,
Here is the Output at the error log:
[Mon May 08 16:26:20 2006] [error] [client 10.63.253.97] FastCGI:
server "/opt/rt3/bin/mason_handler.fcgi" stderr: RR: SearchBuilder.pm:
_DoSearch: QueryString is: SELECT DISTINCT main.* FROM (GroupMembers
main LEFT JOIN Groups Groups_1 ON ( Groups_1.id = main.GroupId))
WHERE ((Groups_1.Domain = 'SystemInternal')OR(Groups_1.Domain =
'UserDefined')) AND ((main.MemberId = '225')) ORDER BY
Groups_1.Domain ASC, Groups_1.Name ASC , referer:
http://astdev.int.kn/Sendungen/index.html
[Mon May 08 16:26:20 2006] [error] [client 10.63.253.97] FastCGI:
server "/opt/rt3/bin/mason_handler.fcgi" stderr: RR: SearchBuilder.pm:
_DoSearch: QueryString is: SELECT DISTINCT main.* FROM (((Tickets
main LEFT JOIN ObjectCustomFields ObjectCustomFields_1 ON (
ObjectCustomFields_1.ObjectId = main.Queue)) LEFT JOIN CustomFields
CustomFields_2 ON ( CustomFields_2.id =
ObjectCustomFields_1.CustomField)) LEFT JOIN ObjectCustomFieldValues
ObjectCustomFieldValues_3 ON ((ObjectCustomFieldValues_3.ObjectId =
main.id)) AND ( ObjectCustomFieldValues_3.CustomField =
CustomFields_2.id) AND ( (ObjectCustomFieldValues_3.Disabled = '0'))
AND ( (ObjectCustomFieldValues_3.ObjectType = 'RT::Ticket'))) WHERE
((CustomFields_2.name = 'Tournummer')) AND ((main.EffectiveId =
main.id)) AND ((main.Status != 'deleted')) AND ((main.Type =
'ticket')) AND ((main.name = 'Tournummer')) AND ( ( (main.Queue = '5')
) AND ( ( (ObjectCustomFieldValues_3.Content = '03376') ) OR (
(ObjectCustomFieldValues_3.Content = '03361') ) ) AND ( (main.Status
= 'new')OR(main.Status = 'open')Or(main.Status =
'stalled')OR(main.Status = 'resolved') ) ) ORDER, referer:
http://astdev.int.kn/Sendungen/index.html
This looks strange, i don't understand a word... argh...
Torsten
Rangarajan Radhakrishnan schrieb:
In SearchBuilder.pm, inside "sub _DoSearch" you can use:
print STDERR "RR: SearchBuilder.pm: _DoSearch: QueryString is:
$QueryString\n";
(right after the statement "my $QueryString =
$self->BuildSelectQuery();")
When you do this queries against the database will result in the
query getting printed in apache error_log (please check your apache
config if you are unsure about location and naming of error log).
For adding this debug statement, you may have to interact with your
sys admin if your DBIx::SearchBuilder was installed by your sys admin
and you don't have write privileges. Hope this helps.
Torsten Brumm wrote:
Hi Rangarajan,
I'm using Mysql 4.12, i have also tried to update DBIxSearchbuilder
from the old version to the newest, same result.
> If you can, you may want to print out the query that is being
generated by putting some debug statement in DBIx::SearchBuilder.
And see if it runs against the database you are using.
How can i do this? Now idea at this moment.
Thanks
Torsten
PS: The problem looks similar to yours. i also have tried this with
3.6pre1, same result.
Rangarajan Radhakrishnan schrieb:
Torsten Brumm wrote:
Hi RT Users,
I think, i found a bug, or i'm too dumb.
I'm trying the following query (from within a website, but also
occurs from the Query Builder)
( Queue = 'GAI_ABF_NW' ) AND ( 'CF.{Tournummer}' = '03376' OR
'CF.{Tournummer}' = '03361' ) AND ( Status = 'new' OR Status =
'open' Or Status = 'stalled' OR Status = 'resolved')
In this Query, CF.{Tournumm
RE: [rt-users] User customfields not showing up in the user form
Hi amit, It's not necessary to modify code. Into wed page of RT, verify if you selected your custom field into Configuration-global-custom field-users. After that, you grant rights to see or modify this custom field to users or groups you want to. I hope it will help you ! Take care! Nat Nathalie Gagnon Programmeure Les Industries Amisco Ltée L'Islet QC, G0R 2C0 [EMAIL PROTECTED] > -Message d'origine- > De: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED] > Date: 8 mai, 2006 11:57 > À:rt-users@lists.bestpractical.com > Objet:[rt-users] User customfields not showing up in the user form > > Hi, > > I have created customfiedls which applies to Users. Since RT 3.4.5 allows > us to > create custom fields which apply to users or groups. > > But the custom field does not show up in the user form. There is a place > in the > user form to show the user custom fields but it is alway empty. > > I checked in the code. It seems that the code is trying to join > CustomFields and > ObjectCustomFields to get back a row which applies to the user in the > form. > > But from the code it seems that a row in ObjectCustomFields is only > created for > Ticket customfields and not user and group customfields, and it is only > created > for ticket customfields when a queue is selected in "Applies To" form. But > Applies to does not come up for the user custom fields. > > When I put a row in ObjectCustomFields with Object Id 0 (apply to all > users) > then I can see the customfield in the user form. > > Could someone please clarify why is a row not created in > ObjectCustomFields for > the user custom fields/or shouldnt' there be a applies to form for user > custom > fields so that we can select which user does the customfield applies to ? > > thanks > amit > ___ > 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 with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > > > We're hiring! Come hack Perl for Best Practical: > http://bestpractical.com/about/jobs.html ___ 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 with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
RE: [rt-users] Edit Ticket
> is it posible to edit an existing ticket? > > (i.E if there is a mistake in spelling) > > Thanks for all help, > > Matthias Sure, if you edit the information the database :-) Here's the query I use to get the right rows out of the database: SELECT * FROM attachments WHERE transactionid IN (SELECT id FROM transactions WHERE objectid = $ticket) AND contenttype = 'text/plain' I actually have a script that wraps around this query display each piece of content one piece at a time in an editing session, and if the temp file changes on disk that I used for this, then I update the information for that "attachment" in the database. This is useful for when someone accidentally puts sensitive information in a ticket, like a password. I don't fix content for typoes, else I'd be doing nothing else all day :-) Eric Schultz United Online ___ 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 with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
[rt-users] Edit Ticket
Hello is it posible to edit an existing ticket? (i.E if there is a mistake in spelling) Thanks for all help, Matthias -- ___ Matthias Meier Fornoff und Heintzenberg GmbH Consulting, DV-Systeme, Dienstleistungen Hauptstr. 4, D-79224 Umkirch Tel +49 7665 937-0, Fax -150 ___ 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 with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
Re: [rt-users] Lack of trailing slash causing porblems in IE
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 almost immediately which gives me the impression that IE does not even attempt to connect to the server before it gives the error. It also seems to happen more often if you wait about 60 seconds or more before submitting the form. Does anyone else have this problem as it is driving me crazy! Regards, Brendan On 4/28/06, Ruslan Zakirov <[EMAIL PROTECTED]> wrote: The first variant of the settings is correct. On 4/28/06, Brendan Arnold <[EMAIL PROTECTED]> wrote: > OK I have set ScriptAlias as suggested, although the problems still > persist on occasion. > > The Web* vars from RT_SiteConfig are as follows, > > Set($WebPath , "/rt"); > Set($WebBaseURL , "https://example.com";); > Set($WebURL , $WebBaseURL . $WebPath . "/"); > > Should this be instead... > > Set($WebPath , "/rt/"); > Set($WebBaseURL , "https://example.com";); > Set($WebURL , $WebBaseURL . $WebPath); > > Regards, > > Brendan > ___ > 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 with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > > > We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html > -- Best regards, Ruslan. ___ 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 with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
RE: [rt-users] Images in Tickets
I commented out this section of code in
/share/html/Ticket/Elements/ShowTransactionAttachments:
#elsif ( $message->ContentType =~ /^image\//i ) {
#$m->out('' );
#}
Hope this helps!
Eric Schultz
United Online
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Nick
Metrowsky
Sent: Monday, May 08, 2006 6:54 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Images in Tickets
Hi Everyone,
Once in a while we receive SPAM into our ticket queues, with
embedded images. Is there a way to configure Request Tracker to not
display the images when a ticket it viewed? Attachments can only be
viewed when one click on a link; is it possible for images as well?
Take care!
Nick
-
Nick Metrowsky
Consulting System Administrator
303-684-4785 Office
303-684-4100 Fax
[EMAIL PROTECTED]
DigitalGlobe (r), An Imaging and Information Company
http://www.digitalglobe.com
-
___
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 with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
We're hiring! Come hack Perl for Best Practical:
http://bestpractical.com/about/jobs.html
[rt-users] User customfields not showing up in the user form
Hi, I have created customfiedls which applies to Users. Since RT 3.4.5 allows us to create custom fields which apply to users or groups. But the custom field does not show up in the user form. There is a place in the user form to show the user custom fields but it is alway empty. I checked in the code. It seems that the code is trying to join CustomFields and ObjectCustomFields to get back a row which applies to the user in the form. But from the code it seems that a row in ObjectCustomFields is only created for Ticket customfields and not user and group customfields, and it is only created for ticket customfields when a queue is selected in "Applies To" form. But Applies to does not come up for the user custom fields. When I put a row in ObjectCustomFields with Object Id 0 (apply to all users) then I can see the customfield in the user form. Could someone please clarify why is a row not created in ObjectCustomFields for the user custom fields/or shouldnt' there be a applies to form for user custom fields so that we can select which user does the customfield applies to ? thanks amit ___ 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 with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
Re: [rt-users] Quick Ticket Creation Box - and code to change passwords back to md5 base 64
On Mon, May 08, 2006 at 06:58:28AM -0700, Winn Johnston wrote: > hello all, > > I have up graded to RT 3.4.5, everything seems to be working just fine. > Except for the Quick Ticket Creation Box on the main page. After using the > Quick Create ticket option, the ticket is never created. Using the long form > it works. Am i missing an option that needs to be turned on in one of the > configuration files? Thanks in advance. That should "just work." Is anything showing up in RT's logs? ___ 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 with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
Re: [rt-users] reminders for tickets
You're redefining variables that are already defined. Does the unmodified for local install version of rt-remind.pm work? If so, you botched the mods on your local. Jay Vlavianos wrote: Greetings. I dropped this one in here a couple days ago to no response. Thought I would try again, as I cant imagine that I am the only person who wants to have people reminded that they have tickets J I am running rt-remind.pm (modified for local install) seems to fail on the following 4 lines (on other overlays?) when I run it from the command line. Has anyone experienced this before? Errors: "my" variable $id masks earlier declaration in same scope at RT/CustomField_Overlay.pm line 879. "my" variable $id masks earlier declaration in same scope at RT/CustomField_Overlay.pm line 914. "my" variable $msg masks earlier declaration in same scope at RT/Ticket_Overlay.pm line 3021. "my" variable $groupmembers masks earlier declaration in same scope at RT/Tickets_Overlay.pm line 921. Thanks, -Jay ___ 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 with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html -- Drew Barnes Applications Analyst Raymond Walters College University of Cincinnati ___ 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 with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
Re: [rt-users] A bug? Searchbuilder?
Hi Rangarajan,
Here is the Output at the error log:
[Mon May 08 16:26:20 2006] [error] [client 10.63.253.97] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: RR: SearchBuilder.pm:
_DoSearch: QueryString is: SELECT DISTINCT main.* FROM (GroupMembers
main LEFT JOIN Groups Groups_1 ON ( Groups_1.id = main.GroupId))
WHERE ((Groups_1.Domain = 'SystemInternal')OR(Groups_1.Domain =
'UserDefined')) AND ((main.MemberId = '225')) ORDER BY Groups_1.Domain
ASC, Groups_1.Name ASC , referer: http://astdev.int.kn/Sendungen/index.html
[Mon May 08 16:26:20 2006] [error] [client 10.63.253.97] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: RR: SearchBuilder.pm:
_DoSearch: QueryString is: SELECT DISTINCT main.* FROM (((Tickets main
LEFT JOIN ObjectCustomFields ObjectCustomFields_1 ON (
ObjectCustomFields_1.ObjectId = main.Queue)) LEFT JOIN CustomFields
CustomFields_2 ON ( CustomFields_2.id =
ObjectCustomFields_1.CustomField)) LEFT JOIN ObjectCustomFieldValues
ObjectCustomFieldValues_3 ON ((ObjectCustomFieldValues_3.ObjectId =
main.id)) AND ( ObjectCustomFieldValues_3.CustomField =
CustomFields_2.id) AND ( (ObjectCustomFieldValues_3.Disabled = '0')) AND
( (ObjectCustomFieldValues_3.ObjectType = 'RT::Ticket'))) WHERE
((CustomFields_2.name = 'Tournummer')) AND ((main.EffectiveId =
main.id)) AND ((main.Status != 'deleted')) AND ((main.Type = 'ticket'))
AND ((main.name = 'Tournummer')) AND ( ( (main.Queue = '5') ) AND ( (
(ObjectCustomFieldValues_3.Content = '03376') ) OR (
(ObjectCustomFieldValues_3.Content = '03361') ) ) AND ( (main.Status =
'new')OR(main.Status = 'open')Or(main.Status = 'stalled')OR(main.Status
= 'resolved') ) ) ORDER, referer: http://astdev.int.kn/Sendungen/index.html
This looks strange, i don't understand a word... argh...
Torsten
Rangarajan Radhakrishnan schrieb:
In SearchBuilder.pm, inside "sub _DoSearch" you can use:
print STDERR "RR: SearchBuilder.pm: _DoSearch: QueryString is:
$QueryString\n";
(right after the statement "my $QueryString =
$self->BuildSelectQuery();")
When you do this queries against the database will result in the
query getting printed in apache error_log (please check your apache
config if you are unsure about location and naming of error log).
For adding this debug statement, you may have to interact with your
sys admin if your DBIx::SearchBuilder was installed by your sys admin
and you don't have write privileges. Hope this helps.
Torsten Brumm wrote:
Hi Rangarajan,
I'm using Mysql 4.12, i have also tried to update DBIxSearchbuilder
from the old version to the newest, same result.
> If you can, you may want to print out the query that is being
generated by putting some debug statement in DBIx::SearchBuilder. And
see if it runs against the database you are using.
How can i do this? Now idea at this moment.
Thanks
Torsten
PS: The problem looks similar to yours. i also have tried this with
3.6pre1, same result.
Rangarajan Radhakrishnan schrieb:
Torsten Brumm wrote:
Hi RT Users,
I think, i found a bug, or i'm too dumb.
I'm trying the following query (from within a website, but also
occurs from the Query Builder)
( Queue = 'GAI_ABF_NW' ) AND ( 'CF.{Tournummer}' = '03376' OR
'CF.{Tournummer}' = '03361' ) AND ( Status = 'new' OR Status =
'open' Or Status = 'stalled' OR Status = 'resolved')
In this Query, CF.{Tournummer} is a normal Custom field.
If i fire this Query i get the following error:
[Mon May 08 13:00:45 2006] [error] [client 10.63.253.97] FastCGI:
server "/opt/rt3/bin/mason_handler.fcgi" stderr:
\tHTML::Mason::CGIHandler::_handler('HTML::Mason::CGIHandler=HASH(0x9dec5d8)',
'HASH(0x9f06f28)') called at
/usr/lib/perl5/vendor_perl/5.8.6/HTML/Mason/CGIHandler.pm line 73,
referer: http://astdev.int.kn/Sendungen/index.html
I'm running RT 3.5.6 on Fedora Core:
Perl v5.8.6 under linux
Apache::Session v1.6;
Apache::Session::Generate::MD5 v2.1;
Apache::Session::Lock::MySQL v1.00;
Apache::Session::MySQL v1.01;
Apache::Session::Serialize::Storable v1.00;
Apache::Session::Store::DBI v1.02;
Apache::Session::Store::MySQL v1.04;
AutoLoader v5.60;
base v2.06;
Benchmark v1.06;
bytes v1.01;
Cache::Simple::TimedExpiry v0.23;
capitalization v0.03;
Carp v1.03;
CGI v3.10;
CGI::Cookie v1.25;
CGI::Fast v1.05;
CGI::Util v1.5;
Class::Container v0.12;
Class::Data::Inheritable v0.04;
Class::ReturnValue v0.53;
Clone v0.18;
constant v1.04;
Cwd v3.01;
Data::Dumper v2.121_02;
Date::Format v2.22;
Date::Parse v2.27;
DBD::mysql v2.9007;
DBI v1.48;
DBIx::SearchBuilder v1.38;
DBIx::SearchBuilder::Union v0;
DBIx::SearchBuilder::Unique v0.01;
Devel::StackTrace v1.12;
Devel::StackTraceFrame v0.6;
Devel::Symdump v2.03;
Digest::base v1.00;
Digest::MD5 v2.33;
DynaLoader v1.05;
Encode v2.08;
Encode::Alias v2.02;
Encode::Config v2.00;
Encode::Encoding v2.02;
Errno v1.09;
Exception::Class v1.21;
Exception::Class::Base v1.2;
Exporter v5.58;
Exporter::Heavy
[rt-users] Distinguish between the comments in ticket
Is there is a way to color code the different comments in the RT ticket system? For example, if you want Customer Comments to appear differently than your Own (in-house) Comments, how could we accomplish this? ___ 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 with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
[rt-users] User preferences
Hello I would like to set it so users can update their own preferences from within their weblogin, currently they can only change their password with selfservice, any idea how to achive this ___ 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 with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
[rt-users] Quick Ticket Creation Box - and code to change passwords back to md5 base 64
hello all, I have up graded to RT 3.4.5, everything seems to be working just fine. Except for the Quick Ticket Creation Box on the main page. After using the Quick Create ticket option, the ticket is never created. Using the long form it works. Am i missing an option that needs to be turned on in one of the configuration files? Thanks in advance. Also here below is some code you might find usefull. The RT 3.4.5 uses a hex encoded password, this is diffrent than the previous versions that use a base64 encoded password. If your shop is like ours then you copy the RT users database around the network and use it to authenticate users for other apps. Below is some perl code that will re-encode the new Hex format back to the base64. #!/usr/bin/perl # load module use DBI; use MIME::Base64 qw(); use bytes; @mysqlcopy
=(/usr/bin/mysqldump --host=rt.dnc.org -uroot --add-drop-table --compress --add-locks -e rt3 Users Groups CachedGroupMembers | /usr/bin/mysql --host=192.168.10.47 -uroot -plemon -C rt3);system (@args); #querymy $query = qq( SELECT * From Users WHERE CHAR_LENGTH(Password)< 33 AND (CHAR_LENGTH(Password) != 13)); # connectmy $dbh = DBI->connect("DBI:mysql:database=rt3;host=localhost", "root", "", {'RaiseError' => 1}); my $sth = $dbh->prepare($query);$sth->execute(); # iterate through resultset # print values while(my $ref = $sth->fetchrow_hashref()) { $old_encoded_pwd = $ref->{'Password'};my $md5 = MIME::Base64::encode(pack "H*", "$old_encoded_pwd"); print "User: $ref->{'Name'}\n";print
"Password: $ref->{'Password'}\n"; substr($md5,-3) =''; print "New Password: '$md5'\n"; # execute INSERT query my $rows = $dbh->do("update Users SET Password= '$md5' WHERE Name='$ref->{Name}';"); print "$rows row(s) affected\n"; print "--\n"; } # clean up $dbh->disconnect();
Yahoo! Messenger with Voice. PC-to-Phone calls for ridiculously low rates.___
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 with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
We're hiring! Come hack Perl for Best Practical:
http://bestpractical.com/about/jobs.html
[rt-users] reminders for tickets
Title: reminders for tickets Greetings. I dropped this one in here a couple days ago to no response. Thought I would try again, as I cant imagine that I am the only person who wants to have people reminded that they have tickets J I am running rt-remind.pm (modified for local install) seems to fail on the following 4 lines (on other overlays?) when I run it from the command line. Has anyone experienced this before? Errors: "my" variable $id masks earlier declaration in same scope at RT/CustomField_Overlay.pm line 879. "my" variable $id masks earlier declaration in same scope at RT/CustomField_Overlay.pm line 914. "my" variable $msg masks earlier declaration in same scope at RT/Ticket_Overlay.pm line 3021. "my" variable $groupmembers masks earlier declaration in same scope at RT/Tickets_Overlay.pm line 921. Thanks, -Jay ___ 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 with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
Re: [rt-users] A bug? Searchbuilder?
In SearchBuilder.pm, inside "sub _DoSearch" you can use:
print STDERR "RR: SearchBuilder.pm: _DoSearch: QueryString is:
$QueryString\n";
(right after the statement "my $QueryString = $self->BuildSelectQuery();")
When you do this queries against the database will result in the query
getting printed in apache error_log (please check your apache config if
you are unsure about location and naming of error log).
For adding this debug statement, you may have to interact with your sys
admin if your DBIx::SearchBuilder was installed by your sys admin and
you don't have write privileges. Hope this helps.
Torsten Brumm wrote:
Hi Rangarajan,
I'm using Mysql 4.12, i have also tried to update DBIxSearchbuilder
from the old version to the newest, same result.
> If you can, you may want to print out the query that is being
generated by putting some debug statement in DBIx::SearchBuilder. And
see if it runs against the database you are using.
How can i do this? Now idea at this moment.
Thanks
Torsten
PS: The problem looks similar to yours. i also have tried this with
3.6pre1, same result.
Rangarajan Radhakrishnan schrieb:
Torsten Brumm wrote:
Hi RT Users,
I think, i found a bug, or i'm too dumb.
I'm trying the following query (from within a website, but also
occurs from the Query Builder)
( Queue = 'GAI_ABF_NW' ) AND ( 'CF.{Tournummer}' = '03376' OR
'CF.{Tournummer}' = '03361' ) AND ( Status = 'new' OR Status =
'open' Or Status = 'stalled' OR Status = 'resolved')
In this Query, CF.{Tournummer} is a normal Custom field.
If i fire this Query i get the following error:
[Mon May 08 13:00:45 2006] [error] [client 10.63.253.97] FastCGI:
server "/opt/rt3/bin/mason_handler.fcgi" stderr:
\tHTML::Mason::CGIHandler::_handler('HTML::Mason::CGIHandler=HASH(0x9dec5d8)',
'HASH(0x9f06f28)') called at
/usr/lib/perl5/vendor_perl/5.8.6/HTML/Mason/CGIHandler.pm line 73,
referer: http://astdev.int.kn/Sendungen/index.html
I'm running RT 3.5.6 on Fedora Core:
Perl v5.8.6 under linux
Apache::Session v1.6;
Apache::Session::Generate::MD5 v2.1;
Apache::Session::Lock::MySQL v1.00;
Apache::Session::MySQL v1.01;
Apache::Session::Serialize::Storable v1.00;
Apache::Session::Store::DBI v1.02;
Apache::Session::Store::MySQL v1.04;
AutoLoader v5.60;
base v2.06;
Benchmark v1.06;
bytes v1.01;
Cache::Simple::TimedExpiry v0.23;
capitalization v0.03;
Carp v1.03;
CGI v3.10;
CGI::Cookie v1.25;
CGI::Fast v1.05;
CGI::Util v1.5;
Class::Container v0.12;
Class::Data::Inheritable v0.04;
Class::ReturnValue v0.53;
Clone v0.18;
constant v1.04;
Cwd v3.01;
Data::Dumper v2.121_02;
Date::Format v2.22;
Date::Parse v2.27;
DBD::mysql v2.9007;
DBI v1.48;
DBIx::SearchBuilder v1.38;
DBIx::SearchBuilder::Union v0;
DBIx::SearchBuilder::Unique v0.01;
Devel::StackTrace v1.12;
Devel::StackTraceFrame v0.6;
Devel::Symdump v2.03;
Digest::base v1.00;
Digest::MD5 v2.33;
DynaLoader v1.05;
Encode v2.08;
Encode::Alias v2.02;
Encode::Config v2.00;
Encode::Encoding v2.02;
Errno v1.09;
Exception::Class v1.21;
Exception::Class::Base v1.2;
Exporter v5.58;
Exporter::Heavy v5.58;
FCGI v0.67;
Fcntl v1.05;
File::Basename v2.73;
File::Glob v1.03;
File::Path v1.06;
File::Spec v3.01;
File::Spec::Unix v1.5;
File::Temp v0.14;
FileHandle v2.01;
HTML::Entities v1.29;
HTML::Mason v1.3101;
HTML::Mason::CGIHandler v1.00;
HTML::Mason::Exception v1.1;
HTML::Mason::Exception::Abort v1.1;
HTML::Mason::Exception::Compilation v1.1;
HTML::Mason::Exception::Compilation::IncompatibleCompiler v1.1;
HTML::Mason::Exception::Compiler v1.1;
HTML::Mason::Exception::Decline v1.1;
HTML::Mason::Exception::Params v1.1;
HTML::Mason::Exception::Syntax v1.1;
HTML::Mason::Exception::System v1.1;
HTML::Mason::Exception::TopLevelNotFound v1.1;
HTML::Mason::Exception::VirtualMethod v1.1;
HTML::Mason::Exceptions v1.43;
HTML::Parser v3.45;
HTML::Scrubber v0.08;
I18N::LangTags v0.35;
I18N::LangTags::Detect v1.03;
integer v1.00;
IO v1.21;
IO::File v1.10;
IO::Handle v1.24;
IO::InnerFile v2.110;
IO::Lines v2.110;
IO::Scalar v2.110;
IO::ScalarArray v2.110;
IO::Seekable v1.09;
IO::Wrap v2.110;
IO::WrapTie v2.110;
IPC::Open2 v1.01;
IPC::Open3 v1.0106;
lib v0.5565;
List::Util v1.14;
locale v1.00;
Locale::Maketext v1.09;
Locale::Maketext::Fuzzy v0.02;
Locale::Maketext::Lexicon v0.53;
Locale::Maketext::Lexicon::Gettext v0.14;
Log::Dispatch v2.11;
Log::Dispatch::Base v1.09;
Log::Dispatch::Output v1.26;
Log::Dispatch::Screen v1.17;
Log::Dispatch::Syslog v1.18;
Mail::Address v1.67;
Mail::Field v1.67;
Mail::Field::AddrList v1.67;
Mail::Field::Date v1.67;
Mail::Header v1.67;
Mail::Internet v1.67;
MIME::Base64 v3.05;
MIME::Body v5.417;
MIME::Decoder v5.417;
MIME::Entity v5.417;
MIME::Field::ContDisp v5.417;
MIME::Field::ConTraEnc v5.417;
MIME::Field::ContType v5.417;
MIME::Field::ParamVal v5.417;
MIME::Head v5.417;
MIME::Parser v5.417;
MIME::QuotedPrint v3.03;
MIME::Tools v5.417;
MIME
[rt-users] Images in Tickets
Hi Everyone, Once in a while we receive SPAM into our ticket queues, with embedded images. Is there a way to configure Request Tracker to not display the images when a ticket it viewed? Attachments can only be viewed when one click on a link; is it possible for images as well? Take care! Nick - Nick Metrowsky Consulting System Administrator 303-684-4785 Office 303-684-4100 Fax [EMAIL PROTECTED] DigitalGlobe ®, An Imaging and Information Company http://www.digitalglobe.com - ___ 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 with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
Re: [rt-users] A bug? Searchbuilder?
Hi Rangarajan,
I'm using Mysql 4.12, i have also tried to update DBIxSearchbuilder
from the old version to the newest, same result.
> If you can, you may want to print out the query that is being
generated by putting some debug statement in DBIx::SearchBuilder. And
see if it runs against the database you are using.
How can i do this? Now idea at this moment.
Thanks
Torsten
PS: The problem looks similar to yours. i also have tried this with
3.6pre1, same result.
Rangarajan Radhakrishnan schrieb:
Torsten Brumm wrote:
Hi RT Users,
I think, i found a bug, or i'm too dumb.
I'm trying the following query (from within a website, but also
occurs from the Query Builder)
( Queue = 'GAI_ABF_NW' ) AND ( 'CF.{Tournummer}' = '03376' OR
'CF.{Tournummer}' = '03361' ) AND ( Status = 'new' OR Status = 'open'
Or Status = 'stalled' OR Status = 'resolved')
In this Query, CF.{Tournummer} is a normal Custom field.
If i fire this Query i get the following error:
[Mon May 08 13:00:45 2006] [error] [client 10.63.253.97] FastCGI:
server "/opt/rt3/bin/mason_handler.fcgi" stderr:
\tHTML::Mason::CGIHandler::_handler('HTML::Mason::CGIHandler=HASH(0x9dec5d8)',
'HASH(0x9f06f28)') called at
/usr/lib/perl5/vendor_perl/5.8.6/HTML/Mason/CGIHandler.pm line 73,
referer: http://astdev.int.kn/Sendungen/index.html
I'm running RT 3.5.6 on Fedora Core:
Perl v5.8.6 under linux
Apache::Session v1.6;
Apache::Session::Generate::MD5 v2.1;
Apache::Session::Lock::MySQL v1.00;
Apache::Session::MySQL v1.01;
Apache::Session::Serialize::Storable v1.00;
Apache::Session::Store::DBI v1.02;
Apache::Session::Store::MySQL v1.04;
AutoLoader v5.60;
base v2.06;
Benchmark v1.06;
bytes v1.01;
Cache::Simple::TimedExpiry v0.23;
capitalization v0.03;
Carp v1.03;
CGI v3.10;
CGI::Cookie v1.25;
CGI::Fast v1.05;
CGI::Util v1.5;
Class::Container v0.12;
Class::Data::Inheritable v0.04;
Class::ReturnValue v0.53;
Clone v0.18;
constant v1.04;
Cwd v3.01;
Data::Dumper v2.121_02;
Date::Format v2.22;
Date::Parse v2.27;
DBD::mysql v2.9007;
DBI v1.48;
DBIx::SearchBuilder v1.38;
DBIx::SearchBuilder::Union v0;
DBIx::SearchBuilder::Unique v0.01;
Devel::StackTrace v1.12;
Devel::StackTraceFrame v0.6;
Devel::Symdump v2.03;
Digest::base v1.00;
Digest::MD5 v2.33;
DynaLoader v1.05;
Encode v2.08;
Encode::Alias v2.02;
Encode::Config v2.00;
Encode::Encoding v2.02;
Errno v1.09;
Exception::Class v1.21;
Exception::Class::Base v1.2;
Exporter v5.58;
Exporter::Heavy v5.58;
FCGI v0.67;
Fcntl v1.05;
File::Basename v2.73;
File::Glob v1.03;
File::Path v1.06;
File::Spec v3.01;
File::Spec::Unix v1.5;
File::Temp v0.14;
FileHandle v2.01;
HTML::Entities v1.29;
HTML::Mason v1.3101;
HTML::Mason::CGIHandler v1.00;
HTML::Mason::Exception v1.1;
HTML::Mason::Exception::Abort v1.1;
HTML::Mason::Exception::Compilation v1.1;
HTML::Mason::Exception::Compilation::IncompatibleCompiler v1.1;
HTML::Mason::Exception::Compiler v1.1;
HTML::Mason::Exception::Decline v1.1;
HTML::Mason::Exception::Params v1.1;
HTML::Mason::Exception::Syntax v1.1;
HTML::Mason::Exception::System v1.1;
HTML::Mason::Exception::TopLevelNotFound v1.1;
HTML::Mason::Exception::VirtualMethod v1.1;
HTML::Mason::Exceptions v1.43;
HTML::Parser v3.45;
HTML::Scrubber v0.08;
I18N::LangTags v0.35;
I18N::LangTags::Detect v1.03;
integer v1.00;
IO v1.21;
IO::File v1.10;
IO::Handle v1.24;
IO::InnerFile v2.110;
IO::Lines v2.110;
IO::Scalar v2.110;
IO::ScalarArray v2.110;
IO::Seekable v1.09;
IO::Wrap v2.110;
IO::WrapTie v2.110;
IPC::Open2 v1.01;
IPC::Open3 v1.0106;
lib v0.5565;
List::Util v1.14;
locale v1.00;
Locale::Maketext v1.09;
Locale::Maketext::Fuzzy v0.02;
Locale::Maketext::Lexicon v0.53;
Locale::Maketext::Lexicon::Gettext v0.14;
Log::Dispatch v2.11;
Log::Dispatch::Base v1.09;
Log::Dispatch::Output v1.26;
Log::Dispatch::Screen v1.17;
Log::Dispatch::Syslog v1.18;
Mail::Address v1.67;
Mail::Field v1.67;
Mail::Field::AddrList v1.67;
Mail::Field::Date v1.67;
Mail::Header v1.67;
Mail::Internet v1.67;
MIME::Base64 v3.05;
MIME::Body v5.417;
MIME::Decoder v5.417;
MIME::Entity v5.417;
MIME::Field::ContDisp v5.417;
MIME::Field::ConTraEnc v5.417;
MIME::Field::ContType v5.417;
MIME::Field::ParamVal v5.417;
MIME::Head v5.417;
MIME::Parser v5.417;
MIME::QuotedPrint v3.03;
MIME::Tools v5.417;
MIME::Words v5.417;
Module::Refresh v0.08;
Module::Versions::Report v1.02;
overload v1.02;
Params::Validate v0.78;
POSIX v1.08;
re v0.04;
Regexp::Common v2.120;
Regexp::Common::delimited v2.104;
RT v3.5.6;
RT::Interface::Email v1.02;
Scalar::Util v1.14;
SelectSaver v1.00;
Socket v1.77;
Storable v2.13;
strict v1.03;
Symbol v1.05;
Sys::Hostname v1.11;
Sys::Syslog v0.08;
Text::Autoformat v1.13;
Text::Quoted v1.8;
Text::Reform v1.11;
Text::Tabs v98.112801;
Text::Template v1.44;
Text::Wrapper v1.000;
Time::HiRes v1.65;
Time::JulianDay v2003.1125;
Time::Local v1.1;
Time::ParseDate v2003.1126;
Time::Timezone v2003.0
Re: [rt-users] A bug? Searchbuilder?
Torsten Brumm wrote:
Hi RT Users,
I think, i found a bug, or i'm too dumb.
I'm trying the following query (from within a website, but also occurs
from the Query Builder)
( Queue = 'GAI_ABF_NW' ) AND ( 'CF.{Tournummer}' = '03376' OR
'CF.{Tournummer}' = '03361' ) AND ( Status = 'new' OR Status = 'open'
Or Status = 'stalled' OR Status = 'resolved')
In this Query, CF.{Tournummer} is a normal Custom field.
If i fire this Query i get the following error:
[Mon May 08 13:00:45 2006] [error] [client 10.63.253.97] FastCGI:
server "/opt/rt3/bin/mason_handler.fcgi" stderr:
\tHTML::Mason::CGIHandler::_handler('HTML::Mason::CGIHandler=HASH(0x9dec5d8)',
'HASH(0x9f06f28)') called at
/usr/lib/perl5/vendor_perl/5.8.6/HTML/Mason/CGIHandler.pm line 73,
referer: http://astdev.int.kn/Sendungen/index.html
I'm running RT 3.5.6 on Fedora Core:
Perl v5.8.6 under linux
Apache::Session v1.6;
Apache::Session::Generate::MD5 v2.1;
Apache::Session::Lock::MySQL v1.00;
Apache::Session::MySQL v1.01;
Apache::Session::Serialize::Storable v1.00;
Apache::Session::Store::DBI v1.02;
Apache::Session::Store::MySQL v1.04;
AutoLoader v5.60;
base v2.06;
Benchmark v1.06;
bytes v1.01;
Cache::Simple::TimedExpiry v0.23;
capitalization v0.03;
Carp v1.03;
CGI v3.10;
CGI::Cookie v1.25;
CGI::Fast v1.05;
CGI::Util v1.5;
Class::Container v0.12;
Class::Data::Inheritable v0.04;
Class::ReturnValue v0.53;
Clone v0.18;
constant v1.04;
Cwd v3.01;
Data::Dumper v2.121_02;
Date::Format v2.22;
Date::Parse v2.27;
DBD::mysql v2.9007;
DBI v1.48;
DBIx::SearchBuilder v1.38;
DBIx::SearchBuilder::Union v0;
DBIx::SearchBuilder::Unique v0.01;
Devel::StackTrace v1.12;
Devel::StackTraceFrame v0.6;
Devel::Symdump v2.03;
Digest::base v1.00;
Digest::MD5 v2.33;
DynaLoader v1.05;
Encode v2.08;
Encode::Alias v2.02;
Encode::Config v2.00;
Encode::Encoding v2.02;
Errno v1.09;
Exception::Class v1.21;
Exception::Class::Base v1.2;
Exporter v5.58;
Exporter::Heavy v5.58;
FCGI v0.67;
Fcntl v1.05;
File::Basename v2.73;
File::Glob v1.03;
File::Path v1.06;
File::Spec v3.01;
File::Spec::Unix v1.5;
File::Temp v0.14;
FileHandle v2.01;
HTML::Entities v1.29;
HTML::Mason v1.3101;
HTML::Mason::CGIHandler v1.00;
HTML::Mason::Exception v1.1;
HTML::Mason::Exception::Abort v1.1;
HTML::Mason::Exception::Compilation v1.1;
HTML::Mason::Exception::Compilation::IncompatibleCompiler v1.1;
HTML::Mason::Exception::Compiler v1.1;
HTML::Mason::Exception::Decline v1.1;
HTML::Mason::Exception::Params v1.1;
HTML::Mason::Exception::Syntax v1.1;
HTML::Mason::Exception::System v1.1;
HTML::Mason::Exception::TopLevelNotFound v1.1;
HTML::Mason::Exception::VirtualMethod v1.1;
HTML::Mason::Exceptions v1.43;
HTML::Parser v3.45;
HTML::Scrubber v0.08;
I18N::LangTags v0.35;
I18N::LangTags::Detect v1.03;
integer v1.00;
IO v1.21;
IO::File v1.10;
IO::Handle v1.24;
IO::InnerFile v2.110;
IO::Lines v2.110;
IO::Scalar v2.110;
IO::ScalarArray v2.110;
IO::Seekable v1.09;
IO::Wrap v2.110;
IO::WrapTie v2.110;
IPC::Open2 v1.01;
IPC::Open3 v1.0106;
lib v0.5565;
List::Util v1.14;
locale v1.00;
Locale::Maketext v1.09;
Locale::Maketext::Fuzzy v0.02;
Locale::Maketext::Lexicon v0.53;
Locale::Maketext::Lexicon::Gettext v0.14;
Log::Dispatch v2.11;
Log::Dispatch::Base v1.09;
Log::Dispatch::Output v1.26;
Log::Dispatch::Screen v1.17;
Log::Dispatch::Syslog v1.18;
Mail::Address v1.67;
Mail::Field v1.67;
Mail::Field::AddrList v1.67;
Mail::Field::Date v1.67;
Mail::Header v1.67;
Mail::Internet v1.67;
MIME::Base64 v3.05;
MIME::Body v5.417;
MIME::Decoder v5.417;
MIME::Entity v5.417;
MIME::Field::ContDisp v5.417;
MIME::Field::ConTraEnc v5.417;
MIME::Field::ContType v5.417;
MIME::Field::ParamVal v5.417;
MIME::Head v5.417;
MIME::Parser v5.417;
MIME::QuotedPrint v3.03;
MIME::Tools v5.417;
MIME::Words v5.417;
Module::Refresh v0.08;
Module::Versions::Report v1.02;
overload v1.02;
Params::Validate v0.78;
POSIX v1.08;
re v0.04;
Regexp::Common v2.120;
Regexp::Common::delimited v2.104;
RT v3.5.6;
RT::Interface::Email v1.02;
Scalar::Util v1.14;
SelectSaver v1.00;
Socket v1.77;
Storable v2.13;
strict v1.03;
Symbol v1.05;
Sys::Hostname v1.11;
Sys::Syslog v0.08;
Text::Autoformat v1.13;
Text::Quoted v1.8;
Text::Reform v1.11;
Text::Tabs v98.112801;
Text::Template v1.44;
Text::Wrapper v1.000;
Time::HiRes v1.65;
Time::JulianDay v2003.1125;
Time::Local v1.1;
Time::ParseDate v2003.1126;
Time::Timezone v2003.0211;
Time::Zone v2.22;
utf8 v1.04;
vars v1.01;
warnings v1.03;
warnings::register v1.00;
XSLoader v0.02;
Any Ideas or hints???
Thanks
Torsten
___
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 with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
We're hiring! Come hack Perl for Best Practical
Re: [rt-users] scrip and transaction
On Mon, May 08, 2006 at 07:03:27AM -0400, Roman Steven wrote: > I have a scrip which is supposed to run on a transaction. > > Does creating a ticket count as a transaction and therefore the scrip will > get executed? Creating a ticket results in a "Create" transaction. > > Also, if in the scrip I am changing some ticket values, do they also count > as transactions and therefore the scrip will execute as well ? Yes. > > Roman > ___ > 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 with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > > > We're hiring! Come hack Perl for Best Practical: > http://bestpractical.com/about/jobs.html ___ 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 with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
Re: [rt-users] Transaction Type/Field
Here's what I have in my public RT: qlite> select distinct(Type) from Transactions; Create Set CustomField EmailRecord Comment Status AddLink DeleteLink Take Give Told Correspond AddWatcher Steal CommentEmailRecord select distinct(Field) from Transactions; Password Status RefersTo Owner Told Description Priority TimeLeft AdminCc DependsOn Lang DependedOnBy Subject HasComponent ComponentOf TimeEstimated MergedInto ReferredToBy Starts Started Due Requestor FinalPriority Queue (I deleted the numeric references to Custom Fields) On Mon, May 08, 2006 at 04:54:12PM +1000, taan wrote: > Can somebody point me in the right direction as to where I can find a > list of Transaction Types and Transaction Fields (if one exists). I > can't seem to locate it in RT Essentials, RT Wiki or mailing list. > > thanks > Taan > ___ > 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 with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > > > We're hiring! Come hack Perl for Best Practical: > http://bestpractical.com/about/jobs.html ___ 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 with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
[rt-users] A bug? Searchbuilder?
Hi RT Users,
I think, i found a bug, or i'm too dumb.
I'm trying the following query (from within a website, but also occurs
from the Query Builder)
( Queue = 'GAI_ABF_NW' ) AND ( 'CF.{Tournummer}' = '03376' OR
'CF.{Tournummer}' = '03361' ) AND ( Status = 'new' OR Status = 'open' Or
Status = 'stalled' OR Status = 'resolved')
In this Query, CF.{Tournummer} is a normal Custom field.
If i fire this Query i get the following error:
[Mon May 08 13:00:45 2006] [error] [client 10.63.253.97] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
\tHTML::Mason::CGIHandler::_handler('HTML::Mason::CGIHandler=HASH(0x9dec5d8)',
'HASH(0x9f06f28)') called at
/usr/lib/perl5/vendor_perl/5.8.6/HTML/Mason/CGIHandler.pm line 73,
referer: http://astdev.int.kn/Sendungen/index.html
I'm running RT 3.5.6 on Fedora Core:
Perl v5.8.6 under linux
Apache::Session v1.6;
Apache::Session::Generate::MD5 v2.1;
Apache::Session::Lock::MySQL v1.00;
Apache::Session::MySQL v1.01;
Apache::Session::Serialize::Storable v1.00;
Apache::Session::Store::DBI v1.02;
Apache::Session::Store::MySQL v1.04;
AutoLoader v5.60;
base v2.06;
Benchmark v1.06;
bytes v1.01;
Cache::Simple::TimedExpiry v0.23;
capitalization v0.03;
Carp v1.03;
CGI v3.10;
CGI::Cookie v1.25;
CGI::Fast v1.05;
CGI::Util v1.5;
Class::Container v0.12;
Class::Data::Inheritable v0.04;
Class::ReturnValue v0.53;
Clone v0.18;
constant v1.04;
Cwd v3.01;
Data::Dumper v2.121_02;
Date::Format v2.22;
Date::Parse v2.27;
DBD::mysql v2.9007;
DBI v1.48;
DBIx::SearchBuilder v1.38;
DBIx::SearchBuilder::Union v0;
DBIx::SearchBuilder::Unique v0.01;
Devel::StackTrace v1.12;
Devel::StackTraceFrame v0.6;
Devel::Symdump v2.03;
Digest::base v1.00;
Digest::MD5 v2.33;
DynaLoader v1.05;
Encode v2.08;
Encode::Alias v2.02;
Encode::Config v2.00;
Encode::Encoding v2.02;
Errno v1.09;
Exception::Class v1.21;
Exception::Class::Base v1.2;
Exporter v5.58;
Exporter::Heavy v5.58;
FCGI v0.67;
Fcntl v1.05;
File::Basename v2.73;
File::Glob v1.03;
File::Path v1.06;
File::Spec v3.01;
File::Spec::Unix v1.5;
File::Temp v0.14;
FileHandle v2.01;
HTML::Entities v1.29;
HTML::Mason v1.3101;
HTML::Mason::CGIHandler v1.00;
HTML::Mason::Exception v1.1;
HTML::Mason::Exception::Abort v1.1;
HTML::Mason::Exception::Compilation v1.1;
HTML::Mason::Exception::Compilation::IncompatibleCompiler v1.1;
HTML::Mason::Exception::Compiler v1.1;
HTML::Mason::Exception::Decline v1.1;
HTML::Mason::Exception::Params v1.1;
HTML::Mason::Exception::Syntax v1.1;
HTML::Mason::Exception::System v1.1;
HTML::Mason::Exception::TopLevelNotFound v1.1;
HTML::Mason::Exception::VirtualMethod v1.1;
HTML::Mason::Exceptions v1.43;
HTML::Parser v3.45;
HTML::Scrubber v0.08;
I18N::LangTags v0.35;
I18N::LangTags::Detect v1.03;
integer v1.00;
IO v1.21;
IO::File v1.10;
IO::Handle v1.24;
IO::InnerFile v2.110;
IO::Lines v2.110;
IO::Scalar v2.110;
IO::ScalarArray v2.110;
IO::Seekable v1.09;
IO::Wrap v2.110;
IO::WrapTie v2.110;
IPC::Open2 v1.01;
IPC::Open3 v1.0106;
lib v0.5565;
List::Util v1.14;
locale v1.00;
Locale::Maketext v1.09;
Locale::Maketext::Fuzzy v0.02;
Locale::Maketext::Lexicon v0.53;
Locale::Maketext::Lexicon::Gettext v0.14;
Log::Dispatch v2.11;
Log::Dispatch::Base v1.09;
Log::Dispatch::Output v1.26;
Log::Dispatch::Screen v1.17;
Log::Dispatch::Syslog v1.18;
Mail::Address v1.67;
Mail::Field v1.67;
Mail::Field::AddrList v1.67;
Mail::Field::Date v1.67;
Mail::Header v1.67;
Mail::Internet v1.67;
MIME::Base64 v3.05;
MIME::Body v5.417;
MIME::Decoder v5.417;
MIME::Entity v5.417;
MIME::Field::ContDisp v5.417;
MIME::Field::ConTraEnc v5.417;
MIME::Field::ContType v5.417;
MIME::Field::ParamVal v5.417;
MIME::Head v5.417;
MIME::Parser v5.417;
MIME::QuotedPrint v3.03;
MIME::Tools v5.417;
MIME::Words v5.417;
Module::Refresh v0.08;
Module::Versions::Report v1.02;
overload v1.02;
Params::Validate v0.78;
POSIX v1.08;
re v0.04;
Regexp::Common v2.120;
Regexp::Common::delimited v2.104;
RT v3.5.6;
RT::Interface::Email v1.02;
Scalar::Util v1.14;
SelectSaver v1.00;
Socket v1.77;
Storable v2.13;
strict v1.03;
Symbol v1.05;
Sys::Hostname v1.11;
Sys::Syslog v0.08;
Text::Autoformat v1.13;
Text::Quoted v1.8;
Text::Reform v1.11;
Text::Tabs v98.112801;
Text::Template v1.44;
Text::Wrapper v1.000;
Time::HiRes v1.65;
Time::JulianDay v2003.1125;
Time::Local v1.1;
Time::ParseDate v2003.1126;
Time::Timezone v2003.0211;
Time::Zone v2.22;
utf8 v1.04;
vars v1.01;
warnings v1.03;
warnings::register v1.00;
XSLoader v0.02;
Any Ideas or hints???
Thanks
Torsten
___
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 with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
We're hiring! Come hack Perl for Best Practical:
http://bestpractical.
[rt-users] scrip and transaction
I have a scrip which is supposed to run on a transaction. Does creating a ticket count as a transaction and therefore the scrip will get executed? Also, if in the scrip I am changing some ticket values, do they also count as transactions and therefore the scrip will execute as well ? Roman ___ 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 with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
