[rt-users] make upgrade-database error
I am going from 3.8.8 to 4.0.4 and am running into an issue during the upgrade-database part. When it goes from 3.8.8 to 3.8.9 there is an error that shows: [Thu Mar 8 12:09:37 2012] [warning]: Use of uninitialized value in string eq at /usr/local/src/rt-4.0.4/sbin/../lib/RT/Template.pm line 627, line 1. (/usr/local/src/rt-4.0.4/sbin/../lib/RT/Template.pm:627) It looks like it gets past that and moves on through till it gets to 3.9.5 where it dumps me out: Processing 3.9.5 Now populating database schema. [Thu Mar 8 12:09:50 2012] [crit]: DBD::Pg::st execute failed: ERROR: more than one row returned by a subquery used as an expression (/usr/local/src/rt-4.0.4/sbin/../lib/RT.pm:341) DBD::Pg::st execute failed: ERROR: more than one row returned by a subquery used as an expression make: *** [upgrade-database] Error 255 This is our second upgrade as we have 2 RT systems. The other upgrade (3.8.7 to 4.0.4) went flawless. This upgrade is from an RT installation that has more custom fields and maybe a few more templates/scrips, but essentially it is very similar to the original one. Any ideas? Thanks in advance! Joe
Re: [rt-users] make upgrade-database error
Hi, Probably the following select returns more than one row per custom field. You should delete incorrect records and re-run upgrade: SELECT ObjectId, Content FROM Attributes WHERE Name = 'Category' AND ObjectType = 'RT::CustomFieldValue'; On Thu, Mar 8, 2012 at 16:28, Joe Harris drey...@gmail.com wrote: I am going from 3.8.8 to 4.0.4 and am running into an issue during the upgrade-database part. When it goes from 3.8.8 to 3.8.9 there is an error that shows: [Thu Mar 8 12:09:37 2012] [warning]: Use of uninitialized value in string eq at /usr/local/src/rt-4.0.4/sbin/../lib/RT/Template.pm line 627, line 1. (/usr/local/src/rt-4.0.4/sbin/../lib/RT/Template.pm:627) It looks like it gets past that and moves on through till it gets to 3.9.5 where it dumps me out: Processing 3.9.5 Now populating database schema. [Thu Mar 8 12:09:50 2012] [crit]: DBD::Pg::st execute failed: ERROR: more than one row returned by a subquery used as an expression (/usr/local/src/rt-4.0.4/sbin/../lib/RT.pm:341) DBD::Pg::st execute failed: ERROR: more than one row returned by a subquery used as an expression make: *** [upgrade-database] Error 255 This is our second upgrade as we have 2 RT systems. The other upgrade (3.8.7 to 4.0.4) went flawless. This upgrade is from an RT installation that has more custom fields and maybe a few more templates/scrips, but essentially it is very similar to the original one. Any ideas? Thanks in advance! Joe -- Best regards, Ruslan.
Re: [rt-users] problems installing rt4 on Ubuntu 11.11
On Wed, Mar 7, 2012 at 5:24 PM, Kevin Falcone falc...@bestpractical.comwrote: rt-setup-database --help OK this is bizarre - when I run that program it mores the source code. Does not make any sense at all to me. Permissions are fine -rwxr-xr-x 1 root root 17698 2011-06-28 06:45 /usr/sbin/rt-setup-database-4 But when I type /usr/sbin/rt-setup-database-4 it more's the source code of the program instead of running it.
Re: [rt-users] problems installing rt4 on Ubuntu 11.11
On Thu, Mar 8, 2012 at 9:02 AM, Alan McKay alan.mckay...@gmail.com wrote: But when I type /usr/sbin/rt-setup-database-4 it more's the source code of the program instead of running it. OK, that seems to be because I was missing perl-doc. Got that installed and was able to use this program to help me figure things out. The basic problem seems to be this : when you GRANT ALL in MySQL, it does not actually grant all!!! You get all privs except for the GRANT priv - I had to then manually give the root@RT_HOST user the GRANT priv and then the database creation went smoothly and I now seem to be running.
[rt-users] Send a mail to a customer
Hello, Is it possible to send a mail to a customer ? How ? By creating a ticket with the customer as requestor ? as CC ? What would you do ?
[rt-users] VB: reminders?
Does anyone know, please? Med Vänliga Hälsningar/Best Regards Martin Petersson *: Office +46 (0)522 98028 *: Fax +46 (0)70 25 79 453 *: www.uanet.sehttp://www.uanet.se/ Gustaf Mattssons Väg 2 451 50 Uddevalla Orgnr: 556702-4095 Styrelsens säte: Uddevalla P Please consider the environment before printing this e-mail. Från: Martin Petersson Skickat: den 7 mars 2012 12:05 Till: rt-users@lists.bestpractical.com Ämne: reminders? Hello, I´m following this guide http://requesttracker.wikia.com/wiki/Reminders I don't understand where to paste the code? 0 6 * * * root /opt/rt4/bin/rt-crontool \ --search RT::Search::FromSQL \ --search-arg 'Type = reminder and (Status = open or Status = new)' \ --condition RT::Condition::BeforeDue \ --condition-arg 2d \ --action RT::Action::SendEmail \ --action-arg Owner \ --transaction first \ --template 'Reminder due soon' It´s not in my ordinary crontab, right? Is it in /opt/rt4/bin/rt-crontool? In that case, where? I found this in the file =head1 NAME rt-crontool - a tool to act on tickets from an external scheduling tool =head1 SYNOPSIS # find all active tickets in the queue 'general' and set their priority to 99 if they are overdue: rt-crontool \ --search RT::Search::ActiveTicketsInQueue --search-arg general \ --condition RT::Condition::Overdue \ --action RT::Action::SetPriority --action-arg 99 \ --verbose # Escalate tickets rt-crontool \ --search RT::Search::ActiveTicketsInQueue --search-arg general \ --action RT::Action::EscalatePriority =head1 DESCRIPTION This script is a tool to act on tickets from an external scheduling tool, such as cron. Med Vänliga Hälsningar/Best Regards Martin Petersson *: Office +46 (0)522 98028 *: Fax +46 (0)70 25 79 453 *: www.uanet.sehttp://www.uanet.se/ Gustaf Mattssons Väg 2 451 50 Uddevalla Orgnr: 556702-4095 Styrelsens säte: Uddevalla P Please consider the environment before printing this e-mail.
Re: [rt-users] Send a mail to a customer
On Thu, Mar 8, 2012 at 19:24, Arthur Rance arthur_ra...@hotmail.com wrote: Hello, Is it possible to send a mail to a customer ? How ? By creating a ticket with the customer as requestor ? as CC ? What would you do ? By creating a ticket with the customer as requestor. -- Best regards, Ruslan.
Re: [rt-users] VB: reminders?
On 03/08/2012 10:29 AM, Martin Petersson wrote: Does anyone know, please? I answered your question yesterday: http://lists.bestpractical.com/pipermail/rt-users/2012-March/075478.html Please read the mailing list if you're posting to it. Replies stay on the mailing list so that future readers and searchers can find common answers later. If all replies went to individuals then the community would need to do a lot more work answering repeat questions. Thomas
Re: [rt-users] VB: reminders?
Ok thank you, my spam filter must have taken it. I´ll try this. thanks Med Vänliga Hälsningar/Best Regards Martin Petersson M: Office +46 (0)522 98028 : Fax +46 (0)70 25 79 453 F: www.uanet.se Gustaf Mattssons Väg 2 451 50 Uddevalla Orgnr: 556702-4095 Styrelsens säte: Uddevalla Please consider the environment before printing this e-mail. -Ursprungligt meddelande- Från: Thomas Sibley [mailto:t...@bestpractical.com] Skickat: den 8 mars 2012 16:59 Till: rt-users@lists.bestpractical.com Kopia: Martin Petersson Ämne: Re: [rt-users] VB: reminders? On 03/08/2012 10:29 AM, Martin Petersson wrote: Does anyone know, please? I answered your question yesterday: http://lists.bestpractical.com/pipermail/rt-users/2012-March/075478.html Please read the mailing list if you're posting to it. Replies stay on the mailing list so that future readers and searchers can find common answers later. If all replies went to individuals then the community would need to do a lot more work answering repeat questions. Thomas
[rt-users] Approvals customisation
Hi Folks, I have a couple of questions around customising Approvals. Firstly, I was wondering if there is a way to customise the My Approvals page? To be more specific one of the things I would like to do is collapse each waiting approval down so that they display as single line entries as we have a queue that generates a fair amount of traffic. Secondly, is there a way to give the requester a choice about who the approval goes to? For example our Change Request queue has quite a few approvers but some issues can only be approved by certain people so it would be nice to target them and not spam everyone else? Thanks in advance for your time. Cheers, Glyn
[rt-users] users with multiple email addresses using mergeusers
Hello, Some of my users have two or more email addresses they can use to submit requests to RT. To allow for this, I currently allow RT to create accounts for unknown email addresses, and have installed MergeUsers. I'd like to add the email addresses to the accounts prior to requests coming from them, so that I could restrict usage, and avoid spam ticket requests. I did a little searching to see if I could find where the merged email addresses are stored, then decided maybe a kind knowledgeable member of the list would help me out. Is this stored in the database? I did a little digging, but didn't see anything promising. Any help would be appreciated. Regards, Sandra
Re: [rt-users] VB: reminders?
Sorry to bother again but Can i have it like this /etc/crontab? # /etc/crontab: system-wide crontab # Unlike any other crontab you don't have to run the `crontab' # command to install the new version when you edit this file # and files in /etc/cron.d. These files also have username fields, # that none of the other crontabs do. SHELL=/bin/sh PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin # m h dom mon dow user command 17 ** * * rootcd / run-parts --report /etc/cron.hourly 25 6* * * roottest -x /usr/sbin/anacron || ( cd / run-parts --report /etc/cron.daily ) 47 6* * 7 roottest -x /usr/sbin/anacron || ( cd / run-parts --report /etc/cron.weekly ) 52 61 * * roottest -x /usr/sbin/anacron || ( cd / run-parts --report /etc/cron.monthly ) 0 6 * * * root /opt/rt4/bin/rt-crontool \ --search RT::Search::FromSQL \ --search-arg 'Type = reminder and (Status = open or Status = new)' \ --condition RT::Condition::BeforeDue \ --condition-arg 2d \ --action RT::Action::SendEmail \ --action-arg Owner \ --transaction first \ --template 'Reminder due soon' # Med Vänliga Hälsningar/Best Regards Martin Petersson M: Office +46 (0)522 98028 : Direct +46 (0)73 84 00 450 r: Fax +46 (0)70 25 79 453 F: www.uanet.se Gustaf Mattssons Väg 2 451 50 Uddevalla Orgnr: 556702-4095 Styrelsens säte: Uddevalla Please consider the environment before printing this e-mail. -Ursprungligt meddelande- Från: Thomas Sibley [mailto:t...@bestpractical.com] Skickat: den 8 mars 2012 16:59 Till: rt-users@lists.bestpractical.com Kopia: Martin Petersson Ämne: Re: [rt-users] VB: reminders? On 03/08/2012 10:29 AM, Martin Petersson wrote: Does anyone know, please? I answered your question yesterday: http://lists.bestpractical.com/pipermail/rt-users/2012-March/075478.html Please read the mailing list if you're posting to it. Replies stay on the mailing list so that future readers and searchers can find common answers later. If all replies went to individuals then the community would need to do a lot more work answering repeat questions. Thomas
[rt-users] How to see another users tickets?
Is there a way to see a colleagues tickets except watching in the users queues? I want to know that he´s doing his job properly. Med Vänliga Hälsningar/Best Regards Martin Petersson *: Office +46 (0)522 98028 *: Direct +46 (0)73 84 00 450 *: Fax +46 (0)70 25 79 453 *: www.uanet.sehttp://www.uanet.se/ [Beskrivning: Beskrivning: Beskrivning: sign] Gustaf Mattssons Väg 2 451 50 Uddevalla Orgnr: 556702-4095 Styrelsens säte: Uddevalla P Please consider the environment before printing this e-mail. inline: image001.gif