[rt-users] Tracking the currently assigned worker

2013-11-20 Thread kjcsb
We would like to track who is currently assigned to work on the ticket. This is neither the owner nor the requestor. My solution was to add another type of watcher, something like "Worker". Is this a sensible solution and if so how do I achieve that?

Re: [rt-users] FW: Issue upgrading to 4.2.x

2013-11-20 Thread Adam Hutchins
That worked! Thank you very much for your help! Adam Hutchins, Systems Administrator Town of Kernersville, NC, USA o-336.992.5456 m-336.529.7164 -Original Message- From: Alex Vandiver [mailto:ale...@bestpractical.com] Sent: Wednesday, November 20, 2013 3:05 PM To: rt-users@lists.bestprac

Re: [rt-users] FW: Issue upgrading to 4.2.x

2013-11-20 Thread Alex Vandiver
On Wed, 2013-11-20 at 14:46 -0500, Adam Hutchins wrote: > On Wed, 2013-11-20 at 14:34 -0500, Adam Hutchins wrote: > > > Did you attempt the 4.0 -> 4.2 upgrade at some earlier point? > > Not that I'm aware of. > > That's extremely odd. Can you show the output of: > mysqldump -u root rt4 -p --no-d

Re: [rt-users] FW: Issue upgrading to 4.2.x

2013-11-20 Thread Adam Hutchins
-- MySQL dump 10.13 Distrib 5.5.34, for debian-linux-gnu (x86_64) -- -- Host: localhostDatabase: rt4 -- -- -- Server version 5.5.34-0ubuntu0.12.04.1 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CH

Re: [rt-users] FW: Issue upgrading to 4.2.x

2013-11-20 Thread Alex Vandiver
On Wed, 2013-11-20 at 14:34 -0500, Adam Hutchins wrote: > > Did you attempt the 4.0 -> 4.2 upgrade at some earlier point? > Not that I'm aware of. That's extremely odd. Can you show the output of: mysqldump -u root rt4 -p --no-data - Alex

Re: [rt-users] What’s the correct SQL syntax for a date/time custom field that’s not set?

2013-11-20 Thread Landon Stewart
On 20 November 2013 11:29, Alex Vandiver wrote: > On Wed, 2013-11-20 at 11:13 -0800, Landon Stewart wrote: > > > Is using > "1970-01-01 00:00:00” the only way? > > Currently, yes. > Ok thank you. > > Seems like that definite value might be begging for bugs or something > > if somehow the unset

Re: [rt-users] FW: Issue upgrading to 4.2.x

2013-11-20 Thread Adam Hutchins
Please see my replies below. Adam Hutchins, Systems Administrator Town of Kernersville, NC, USA o-336.992.5456 m-336.529.7164 -Original Message- From: Alex Vandiver [mailto:ale...@bestpractical.com] Sent: Wednesday, November 20, 2013 2:28 PM To: rt-users@lists.bestpractical.com Subject:

Re: [rt-users] What’s the correct SQL syntax for a date/time custom field that’s not set?

2013-11-20 Thread Alex Vandiver
On Wed, 2013-11-20 at 11:13 -0800, Landon Stewart wrote: > Is using > "1970-01-01 00:00:00” the only way? Currently, yes. > Seems like that definite value might be begging for bugs or something > if somehow the unset date equals "1970-01-01 05:00:00” for some reason > down the road. I just want

Re: [rt-users] FW: Issue upgrading to 4.2.x

2013-11-20 Thread Alex Vandiver
Please keep all replies on-list. On Wed, 2013-11-20 at 14:10 -0500, Adam Hutchins wrote: > I have upgraded it in the past from 3.x to 4.0.7. And I was successful > with 4.0.7 to 4.0.18 today. It's the jump to 4.2.x that's giving me > errors. Did you attempt the 4.0 -> 4.2 upgrade at some earlier

[rt-users] What’s the correct SQL syntax for a date/time custom field that’s not set?

2013-11-20 Thread Landon Stewart
Hello, Basically I want to find tickets with rt-crontool that match the following: Queue = 'Blocks’ AND Status != ‘removed’ AND CF.{ServerClosed} < ’now' The problemI’m encountering, although minor, is that it lists tickets that match that as well as tickets that have no date set whatsoever. The

Re: [rt-users] FW: Issue upgrading to 4.2.x

2013-11-20 Thread Alex Vandiver
On Wed, 2013-11-20 at 13:56 -0500, Adam Hutchins wrote: > [18504] [Wed Nov 20 17:27:58 2013] [critical]: DBD::mysql::st execute > failed: Table 'ObjectScrips' already exists > at /tmp/rt-4.2.0/sbin/../lib/RT/Handle.pm line 526. > (/tmp/rt-4.2.0/sbin/../lib/RT.pm:391) > > DBD::mysql::st execute fai

[rt-users] FW: Issue upgrading to 4.2.x

2013-11-20 Thread Adam Hutchins
I'm getting an error when doing upgrade-database on a 4.2 installation. I am coming from 4.0.7 and I am able to successfully upgrade to 4.0.18 without error. This is the message I'm getting after doing 'make upgrade-database' (highlighted below): /usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/l

[rt-users] "Mandatory" custom field

2013-11-20 Thread Jeff Blaine
Hi all, I am little confused about RT's interpretation of "Mandatory" as it relates to Custom Fields. I have a CF's validation set to the canned regexp (?#Mandatory) The CF in my test ticket has pointedly been left with no value. Aside from a meager red warning on the page indicating it's not s