[rt-users] Doing scrips in the background?
I have a custom workflow which uses a custom web interface. When the user clicks the Submit button, the interface creates a Master ticket, and then a bunch of sub-tickets, the number of which varies depending what services they are requesting. The users are complaining that the process of submitting is taking too long. If I were to move the sub-ticket creation into an On Create scrip to run in TransactionBatch, would that help the Master ticket creation return faster, or would the Ticket-Create not return until the scrip ran and finished? -- http://www.linkedin.com/in/paultomblin http://careers.stackoverflow.com/ptomblin We're hiring! http://bestpractical.com/jobs
Re: [rt-users] Spreadsheet-esq Web Input
still looking for any info on how to make the CKEditor pop with formatted text (for example on a quoted reply). any help is appreciated, thanks! We're hiring! http://bestpractical.com/jobs
[rt-users] Require Custom Field for Status Change?
Hello, Does anyone have a suggestion about how I might go about requiring some set of custom fields to be filled before a status change can happen? We have a queue that I have on a custom lifecycle. In order to allow a transition from one status user testing to resolved, I want to require that two custom fields are filled out. One way I think I can do this is to write a scrip that checks to see if these are filled out and then reverses the status change with an email to the person making the change. However, this isn't very user friendly. Preferably, there would be a friendly error message on the screen stating that the fields were required for this status change. A validation on the fields wouldn't make sense since they aren't actually required until later in the workflow and as far as I know. Thanks for your suggestions. Mike We're hiring! http://bestpractical.com/jobs
[rt-users] Error when upgrading database from 3.8.9 to 3.9.1
We're long time RT users and are in the process of upgrading from 3.6.3 to
4.0.8 and are following the instructions on
http://www.bestpractical.com/rt/docs/4.0/UPGRADING.mysql.html and
http://www.bestpractical.com/rt/docs/4.0/README.html. I upgraded to 3.7.87,
ran the extra queries and continued the upgrade however it failed at the
step of upgrading to 3.9.1.
make upgrade-database
/usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib sbin/rt-setup-database
--action upgrade --prompt-for-dba-password
In order to create or update your RT database, this script needs to connect
to your mysql instance on localhost as root
Please specify that user's database password below. If the user has no
database
password, just press return.
Password:
Working with:
Type: mysql
Host: localhost
Name: rt4
User: root
DBA:root
Enter RT version you're upgrading from: 3.8.9
Going to apply following upgrades:
* 3.9.1
* 3.9.2
* 3.9.3
* 3.9.5
* 3.9.6
* 3.9.7
* 3.9.8
* 4.0.0rc2
* 4.0.0rc4
* 4.0.0rc7
* 4.0.1
* 4.0.3
* 4.0.4
* 4.0.6
Enter RT version if you want to stop upgrade at some point, or leave it
blank if you want apply above upgrades: 3.9.1
[snip]
[Mon Nov 5 17:15:24 2012] [warning]: DBD::mysql::st execute failed: You
have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near 'AND (Groups.Type =
'AdminCc') AND ((Groups.Domain = 'RT::System-Role' AND Groups' at line 1 at
/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:587)
[Mon Nov 5 17:15:24 2012] [warning]: RT::Handle=HASH(0x23f02a8) couldn't
execute the query 'SELECT Groups.id FROM Groups, Principals,
CachedGroupMembers WHERE Principals.Disabled = 0 AND
CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND
Principals.PrincipalType = 'Group' AND Principals.id =
CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = AND
(Groups.Type = 'AdminCc') AND ((Groups.Domain = 'RT::System-Role' AND
Groups.Instance = '1') OR (Groups.Domain = 'RT::System-Role' AND
Groups.Instance = '1')) LIMIT 1' at
/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 600.
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x23f02a8)',
'SELECT Groups.id FROM Groups, Principals, CachedGroupMembers...') called
at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 632
DBIx::SearchBuilder::Handle::FetchResult('RT::Handle=HASH(0x23f02a8)',
'SELECT Groups.id FROM Groups, Principals, CachedGroupMembers...') called
at /usr/src/rt-4.0.8/sbin/../lib/RT/Principal.pm line 538
RT::Principal::_HasRoleRight('RT::Principal=HASH(0x3095198)',
'Right', 'ExecuteCode', 'EquivObjects', 'ARRAY(0x3095528)', 'Object',
'RT::System=HASH(0x2f062b0)') called at
/usr/src/rt-4.0.8/sbin/../lib/RT/Principal.pm line 447
RT::Principal::_HasRight('RT::Principal=HASH(0x3095198)', 'Right',
'ExecuteCode', 'EquivObjects', 'ARRAY(0x3095528)', 'Object',
'RT::System=HASH(0x2f062b0)') called at
/usr/src/rt-4.0.8/sbin/../lib/RT/Principal.pm line 330
RT::Principal::HasRight('RT::Principal=HASH(0x3095198)', 'Right',
'ExecuteCode', 'Object', 'RT::System=HASH(0x2f062b0)') called at
./etc/upgrade/3.9.1/content line 52
RT::Handle::__ANON__() called at
/usr/src/rt-4.0.8/sbin/../lib/RT/Handle.pm line 769
eval {...} called at /usr/src/rt-4.0.8/sbin/../lib/RT/Handle.pm line
769
RT::Handle::InsertData('RT::Handle=HASH(0x23f02a8)',
'./etc/upgrade/3.9.1/content', undef) called at sbin/rt-setup-database line
293
main::action_insert('prompt-for-dba-password', 1, 'datafile', undef,
'action', 'upgrade', 'datadir', './etc/upgrade/3.9.1', 'backcompat', ...)
called at sbin/rt-setup-database line 399
main::action_upgrade('prompt-for-dba-password', 1, 'action',
'upgrade', 'dba', 'root') called at sbin/rt-setup-database line 198
(/usr/local/share/perl5/Carp.pm:103)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in string
eq at /usr/src/rt-4.0.8/sbin/../lib/RT/Principal.pm line 704.
(/usr/src/rt-4.0.8/sbin/../lib/RT/Principal.pm:704)
[Mon Nov 5 17:15:24 2012] [critical]: at
/usr/src/rt-4.0.8/sbin/../lib/RT/ACE.pm line 231.
RT::ACE::Create('RT::ACE=HASH(0x3095528)', 'RightName',
'ExecuteCode', 'Object', 'RT::System=HASH(0x2f062b0)', 'PrincipalType',
undef, 'PrincipalId', undef, ...) called at
/usr/src/rt-4.0.8/sbin/../lib/RT/Principal.pm line 172
RT::Principal::GrantRight('RT::Principal=HASH(0x3095198)', 'Right',
'ExecuteCode', 'Object', 'RT::System=HASH(0x2f062b0)') called at
./etc/upgrade/3.9.1/content line 57
RT::Handle::__ANON__() called at
/usr/src/rt-4.0.8/sbin/../lib/RT/Handle.pm line 769
eval {...} called at /usr/src/rt-4.0.8/sbin/../lib/RT/Handle.pm line
769
RT::Handle::InsertData('RT::Handle=HASH(0x23f02a8)',
'./etc/upgrade/3.9.1/content', undef) called at sbin/rt-setup-database line
293
main::action_insert('prompt-for-dba-password', 1,
Re: [rt-users] Require Custom Field for Status Change?
On 11/05/2012 08:56 AM, Mike Kennedy wrote: Does anyone have a suggestion about how I might go about requiring some set of custom fields to be filled before a status change can happen? We have a queue that I have on a custom lifecycle. In order to allow a transition from one status user testing to resolved, I want to require that two custom fields are filled out. There's actually an extension we've written to do this (RT-Extension-MandatoryOnTransition), which is currently getting polished. It should be released soon, if you can wait. We're hiring! http://bestpractical.com/jobs
Re: [rt-users] Error when upgrading database from 3.8.9 to 3.9.1
On 11/05/2012 09:24 AM, CB wrote: We're long time RT users and are in the process of upgrading from 3.6.3 to 4.0.8 and are following the instructions on http://www.bestpractical.com/rt/docs/4.0/UPGRADING.mysql.html and http://www.bestpractical.com/rt/docs/4.0/README.html. I upgraded to 3.7.87, ran the extra queries and continued the upgrade however it failed at the step of upgrading to 3.9.1. Be sure to read the other UPGRADING documentation as well, for all versions between 3.6.3 and 4.0.8. Your database contains rows in the ACL table which point to Principals that no longer exist. Grep for the [error] lines ACE couldn't load it's principal object. This indicates that records were manually deleted from the database at some point, and done so incorrectly (as is almost always the case with manual deletes by folks not understanding the whole of the database). The code doesn't handle this error case and blows up. The ACL rows in question are: 21605 22605 22655 24605 24655 25655 25705 You may want to take a look and see what happened to the Principals referred to. To proceed with the upgrade, add the following line to etc/upgrade/3.9.1/content after the line reading my $principal = $ace-PrincipalObj;: next unless $principal-id; After you've upgraded to 4.0.8, you'll want to run rt-validator to check the integrity of your database and clean it up. Thomas We're hiring! http://bestpractical.com/jobs
[rt-users] Where are comments and correspondence held?
Running RT 4.0.6. Curious where the content of *comments* and/or * correspondence* resides in the database? Max -- Max McGrath Network Administrator Carthage College 262-552-5512 mmcgr...@carthage.edu We're hiring! http://bestpractical.com/jobs
Re: [rt-users] Where are comments and correspondence held?
On 11/5/2012 4:54 PM, Max McGrath wrote: Running RT 4.0.6. Curious where the content of *comments* and/or *correspondence* resides in the database? In the transactions table, as I recall. We're hiring! http://bestpractical.com/jobs
[rt-users] Spreadsheet esq
How about using rtfm and creating an article? I'm not sure if it's possible to put HTML into the template article however (have never tried). That might get you an HTML table with headings at least? We're hiring! http://bestpractical.com/jobs
Re: [rt-users] Where are comments and correspondence held?
Dnia 2012-11-05, pon o godzinie 17:16 -0500, Jeff Blaine pisze: On 11/5/2012 4:54 PM, Max McGrath wrote: Running RT 4.0.6. Curious where the content of *comments* and/or *correspondence* resides in the database? In the transactions table, as I recall. Actually in the attachments tabel. Regards, -- Robert Wysocki administrator systemów linuksowych Contium S.A., http://www.contium.pl We're hiring! http://bestpractical.com/jobs
