RE: [rt-users] due date in business hours

of problems are you having? -- Mark Roedel Senior Programmer / Analyst LeTourneau University Longview, Texas USA -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED]','','','')[EMAIL PROTECTED] On Behalf Of Judson Main Sent: Friday, October 20, 2006 1:19 PM To: rt-users

[rt-users] due date in business hours

Is anyone using this under 3.6.1? I've been noddling with it for a week and can't get it to work. TIA, Jud. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support:

Re: [rt-users] due date in business hours

puzzling. Thanks much, Jud. On Fri Oct 20 15:51 , Rick Russell [EMAIL PROTECTED] sent: Judson Main wrote: Is anyone using this under 3.6.1? I've been noddling with it for a week and can't get it to work. I've got custom scrips in RT 3.4 that use Jesse Vincent's Business::Hours module

[rt-users] DueDateinBusinessHours

Greetings - Turned out I installed this one incorrectly, and it hasn't been updating the Due data in the Tickets. Without having to do each Ticket by hand, is there a way to apply this script to all previous tickets still open? Thanks folks, Jud.

Re: [rt-users] MySQL Query from PHP

RT's database is heavily normalized. You'll need to use left join in your mysql statements. Here's an example: select t.id,q.Name,t.Subject,t.FinalPriority,t.Status,t.Created,t.LastUpdated,t.Resolved,u.Name,u.Name from Tickets t left join Users u on u.id = t.Owner and u.id = t.LastUpdatedBy

RE: [rt-users] Found a true cause and a possible resolution to the

Greetings - FWIW, .02, etc. In your /etc/my.cnf file there can be timeout settings for sessions, in addition to others (max connections, etc.). my.cnf examples are included in the latest distributions in the support-files directory. Maybe setting the timeout to 10-15 minutes, say, would

Re: [rt-users] Db errors

Hmm. Have you repaired and optimized the tables after the recovery? my mysql, in the rt3 database use this command: show table status; Jud. On Fri Sep 29 8:19 , 'Geert Theys' [EMAIL PROTECTED] sent: Hello, I have googled and looked around what the error means but I can’t find a answer.

[rt-users] setting starting ticket number - the answer

I thought this newbie would post something useful. I dug around the archives and found that a couple people on this list had asked this question before with no answer forthcoming. From the commandline, get into mysql: % mysql -u username rt3 mysqlalter table tickets auto_increment=1000;

[rt-users] different status' in 3.6.1

folks! Judson Main ___ 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

Re: [rt-users] different status' in 3.6.1

rejected deleted) unless @InactiveStatus; Copy whatever the appropriate for you to RT_SiteConfig.pm and add your custom status: ie @ActiveStatus = qw(new open stalled newstatus) unless @ActiveStatus; Regards; Roy Judson Main wrote: I dug through old e-mails around here over the last couple of days

Re: [rt-users] greetings, newbie here and a question

:21 , Wagener, Harald sent: Am 21.09.2006 19:11 Uhr schrieb Judson Main [EMAIL PROTECTED]: However, I'm thikning that a queue, called Peer Review, can be populated automagically upon resolution via a custom scrip, which dumps all resolved tickets into the queue, and if the peer determines