[rt-users] Creating a hyperlink from _two_ custom fields?
Hi all, is it possible to access information from CF foo from the 'Link values to' field of CF bar? If yes, what would the syntax be? The normal one used in Scrips? Thanks, Richard ___ 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
Re: [rt-users] Moving large attachments outside of MySQL?
On Sat, Oct 11, 2008 at 19:27, Kelly Jones [EMAIL PROTECTED] wrote: This helps, but is there a better solution? No idea about better, but you could use a custom field and then use its Field Links To functionality to create a link and/or embed the original resource. Richard ___ 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
Re: [rt-users] Approval workflow problem
Hi Andro The steps you showed seems ok. I suggest you check the following: 1. check /Admin/Queues/Scrips.html?id=2 to see if the scrip (If an approval is rejected, reject the original and delete pending approvals ) is in the current scrips. 2. check the log to see if something weird happened. Log is always the best friend of debugging. On Oct 13, 2008, at 4:55 PM, Andro wrote: Hi sunnavy I show you my practice as below(some image files): Step 1. I create an ticket Step 2. Result of creating ticket (including the Links) Step3. Ticket in the queue(pending approval) Step4. Rejecting the approval Step5. Approval's status change from 'new' to 'rejected' Step6. The original ticket still in the queue My problem is Step 6 , why the original ticket didn't be rejected ? Best regards, Andro Hi Andro Just after you create the original ticket, does the ticket depend on the approval ticket? If the header stuff is correct, the original ticket should depend on the approval ticket, and won't be changed because of the reject thing. All things are fine to me. View this message in context: Re: Approval workflow problem Sent from the Request Tracker - User mailing list archive at Nabble.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 best wishes sunnavy ___ 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
Re: [rt-users] RT 3.8: Script - Notify requestors and other recipients
http://wiki.bestpractical.com/view/ScripAction section Managing notification actions On Tue, Oct 14, 2008 at 1:55 PM, Filipe José Silva Clemente [EMAIL PROTECTED] wrote: Hi, When i reply/resolve a problem and include an email address on the cc: field, RT fires two differente messages, one for the requestor and another for the other email address. This is a problem because i want both requestor and the other recipient (in cc: field) gets only one message knowing that the message was sent to both. How can i have a script that notify users and other recipients just using one email message? (FROM: RT3.8 - TO: [EMAIL PROTECTED] and CC: [EMAIL PROTECTED]) TIA, Filipe Portugal ___ 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 -- 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
Re: [rt-users] cannot attach files to tickets via web interface
PS these are the only error I can see in the logs: RT: Encode::Guess failed: decoder is undefined; fallback to iso-8859-1 (/usr/local/rt3/lib/RT/I18N.pm:436) RT: CGI open of tmpfile: Permission denied (/usr/local/rt3/bin/webmux.pl:127) I dont know where tmpfile might be tho... andys writes: Hi, Im using the FreeBSD port RT version 3.6.7 and I cannot get it to attach files to replies etc to tickets. I also had the problem with versoin 3.6.6. Apparently this was working previously, the only thing that I can think that has changed is that we now use SSL (but Im not aware this has broken anything else). What Im seeing is: If Im viewing a ticket and click reply Then I click browse for attaching a file Select a file on my local PC now click update for the ticket, it breaks, it shows as the URL: https://www.myserver.com/Ticket/Update.html and a blank page. Any ideas?? thanks for any help, Andy. ___ 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
Re: [rt-users] RT interface not working
Look at the file which is downloaded. My first was hunch that it's a perl script, and somehow your mod_perl is not getting invoked. Read the apache error-log --- perhaps something got updated relating to that package and broke your configuration. You say, however that it is of type httpd/unix-directory. That suggests that you are missing a DirectoryIndex option somewhere. Maybe an apache package upgrade removed the default DirectoryIndex line. -- Michael Richardson [EMAIL PROTECTED] Director -- Consumer Desktop Development, Simtone Corporation, Ottawa, Canada Personal: http://www.sandelman.ca/mcr/ SIMtone Corporation fundamentally transforms computing into simple, secure, and very low-cost network-provisioned services pervasively accessible by everyone. Learn more at www.simtone.net and www.SIMtoneVDU.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
[rt-users] Commands by email
Hi all, I thought RT 3.8.x had email commands incorporated and does not need CommandByMail, any more. Yet, I can't see anything in the docs/wiki about it. I don't want to enable the plugin without checking if that is the right way to go. So, does RT 3.8.x come with CommandByMail or not? Thanks, Richard ___ 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
[rt-users] RT 3.8: Include an attachment on a template
Hi, I need to include a.pdf file in my resolved ticket template message sent to the requestor, so that i can send a client satisfaction inquiry, when the ticket is closed. How can i do this? How can i define a template with an attachment? Any ohter way to do this? TIA, Filipe Portugal ___ 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
[rt-users] rt-crontool changes ticket modification time
Hi there, I use rt-3.8.1 on a FreeBSD6.2 box. Here's my cronjob: 0 * * * * /usr/local/bin/rt-crontool --search RT::Search::FromSQL -- search-arg (Status='new' OR Status='open' OR Status = 'stalled') -- action-arg RecordTransaction: 0 --action RT::Action::EscalatePriority /dev/null 2/dev/null it's only there to escalate my ticket priorities. My problem: the modification time (last access) of all my tickets is altered as well, so every ticket appears to have been worked upon within max 60 minutes (since my job runs every single hour). So I have no clue, which tickets are worked upon by my workmates. (apart from checking the history). Is there any fix for that ? best regards, Bernd Kuhlen ___ 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
Re: [rt-users] cannot attach files to tickets via web interface
andys wrote: Hi, Im using the FreeBSD port RT version 3.6.7 and I cannot get it to attach files to replies etc to tickets. I also had the problem with versoin 3.6.6. Apparently this was working previously, the only thing that I can think that has changed is that we now use SSL (but Im not aware this has broken anything else). What Im seeing is: If Im viewing a ticket and click reply Then I click browse for attaching a file Select a file on my local PC now click update for the ticket, it breaks, it shows as the URL: https://www.myserver.com/Ticket/Update.html and a blank page. Any ideas?? thanks for any help, Andy. Yes. this is because the home directory of www, the UID the web server runs under has /nonexistent as a home directory (for security reasons). Simply modify the www account so it has a real home directory. I can't remember off hand if the www user needs any special privileges over the home dir -- I don't think it does, in which case, /var/empty is a good choice and still preserves at least of modicum of security: # pw user mod -n www -d /var/empty If that doesn't work then try creating /home/www and see what the minimum privileges are. Leave the shell as /usr/sbin/nologin. Cheers, Matthew -- Dr Matthew Seaman The Bunker, Ash Radar Station PGP: 0x60AE908C on serversMarshborough Rd Tel: +44 1304 814890 Sandwich Fax: +44 1304 814899 Kent, CT13 0PL, UK signature.asc Description: OpenPGP digital signature ___ 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
Re: [rt-users] Using Scrips to call an external command
Ben Robson wrote: Is there a way to have a Scrip call an external (command-line) perl script? [...] something needs attention. Is there a way I can implement an OnCreate Scrip to call the perl script, sending input to it via stdin? I'm basically using system(echo \$HE did $WHAT to $TICKET\ | /path/to/script.py); within the custom action cleanup code (after some other conditions are met), with $HE, $WHAT and $TICKET set before the system() call. Regards, kai -- Kai 'wusel' Siering eMail @ home: [EMAIL PROTECTED] Traveller on the Information Highway doing full-time administration. I didn't believe in reincarnation the last time either. ___ 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
Re: [rt-users] Missing Links in 10 highest priority tickets I own
On Fri, 30 Nov 2007 14:01:08 +0100, [EMAIL PROTECTED] said: First, the Links in the list 10 highest priority tickets I own disappeared for all users, then i tried some other configurations, and (at least i thougt) the links worked again for all users. Now i remarked, that i am the own user who can still use the list with links. See the attached mails from August 2006. -- Keith Edmunds +-+ |Tiger Computing Ltd| Helping businesses make the most of Linux | | The Linux Specialists | http://www.tiger-computing.co.uk | +-+ ---BeginMessage--- On 8/14/06 5:48 PM, Will Maier [EMAIL PROTECTED] wrote: On Mon, Aug 14, 2006 at 02:48:54PM -0600, Josh Barron wrote: All they see is plain text for the list of tickets. I have verified this behavior from my workstation for all of their accounts. We just spent half of today trying to hunt this bug down at our site. It's not necessarily a bug, per se, but it sure is annoying. I also spent a while with this one today... Thought it was me, but looks like it's something about modifying the System Saved Search. If you log in as superuser and edit the At-A-Glance N newest unowned tickets or N highest priority tickets I own, you should be able to edit the predefined search itself. I found the problem by choosing the advanced view of the query. It showed: 'a__id__/a/TITLE:#', 'a__Subject__/a/TITLE:Subject', Etc. In the second (Format) textarea... I was able to get the correct format by changing these to: 'a href=/Ticket/Display.html?id=__idid__/a/TITLE:#', 'a href=/Ticket/Display.html?id=__idSubject__/a/TITLE:Subject', And (this was the important part!) Apply the changes and then Click on the Save button for the [_1] highest priority tickets I own in the Saved Searches section of the page. Then anyone who hasn't modified their own At-A-Glance should show the correct information. It's a problem that once you've put the column linked to Display in the GUI Format area, you can't tell which of the columns are links and which aren't and what they're linked to... Not exactly a solution, but at least a little more information. Hope it helps, Erik Peterson ___ 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 ---End Message--- ---BeginMessage--- Thanks Erik That fixed the problem!! -Original Message- From: Peterson, Erik [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 11:50 AM To: Josh Barron Subject: Re: [rt-users] 10 Highest Priority Tickets I own link problems Josh, You may need to remove the Attributes entry for those two users. If you customize (even if you don't change anything) the At-A-Glance pieces, they're saved as an entry in the Attributes table. I believe that they're something like: Pref-RT::Attribute-27 but that may vary... If you know the id for those users (say 28 for example), you can find it with the following SQL: select id, Name, Description, ObjectType, ContentType from Attributes where ObjectId=28 and ObjectType='RT::User'; You can delete the individual Attribute with no other adverse effects. Delete from Attributes where id=30; (Use whatever the id really is!) Then they should show the correct listing. Hope that helps, _Erik On 8/15/06 1:36 PM, Josh Barron [EMAIL PROTECTED] wrote: Hi everyone. I've tried to follow some of the basic solutions listed here with no resolution. Just to give some more testing information... I created a new user called RTest, gave the user SU priv's and assigned a ticket to him. On his RT at a Glance page, the ticket showed up successfully and everything worked. I copied exactly what was listed below by Erik into my RT Advanced search criteria for the search in question, but the links still do not show up correctly? I'm not exactly sure how to start to follow Wills' suggestions. Restarting the webserver doesn't fix the problem either. To make it clear, ONLY 2 of the users are having this problem, and they have the same permissions as users that are NOT having problems. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peterson, Erik Sent: Monday, August 14, 2006 5:27 PM To: Will Maier; rt-users@lists.bestpractical.com Subject: Re: [rt-users] 10 Highest Priority Tickets I own link problems On 8/14/06 5:48 PM, Will Maier [EMAIL PROTECTED] wrote: On Mon, Aug 14, 2006 at 02:48:54PM -0600, Josh Barron wrote: All they see is plain text for the list of tickets. I have verified this behavior from my workstation for all of their accounts. We just spent half
[rt-users] RT 3.8: Script - Notify requestors and other recipients
Hi, When i reply/resolve a problem and include an email address on the cc: field, RT fires two differente messages, one for the requestor and another for the other email address. This is a problem because i want both requestor and the other recipient (in cc: field) gets only one message knowing that the message was sent to both. How can i have a script that notify users and other recipients just using one email message? (FROM: RT3.8 - TO: [EMAIL PROTECTED] and CC: [EMAIL PROTECTED]) TIA, Filipe Portugal ___ 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
Re: [rt-users] cannot attach files to tickets via web interface
Hi Matthew, thanks for the mail. I have tried changing the home dir of www (and checked this is actually the user that apache is running as) and set the priveledges etc, restarted apache, logged out of and back into RT but I still see exactly the same problem :S thanks Andy. Matthew Seaman writes: Yes. this is because the home directory of www, the UID the web server runs under has /nonexistent as a home directory (for security reasons). Simply modify the www account so it has a real home directory. I can't remember off hand if the www user needs any special privileges over the home dir -- I don't think it does, in which case, /var/empty is a good choice and still preserves at least of modicum of security: # pw user mod -n www -d /var/empty If that doesn't work then try creating /home/www and see what the minimum privileges are. Leave the shell as /usr/sbin/nologin. Cheers, Matthew -- Dr Matthew Seaman The Bunker, Ash Radar Station PGP: 0x60AE908C on serversMarshborough Rd Tel: +44 1304 814890 Sandwich Fax: +44 1304 814899 Kent, CT13 0PL, UK ___ 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
[rt-users] cannot attach files to tickets via web interface
Hi, Im using the FreeBSD port RT version 3.6.7 and I cannot get it to attach files to replies etc to tickets. I also had the problem with versoin 3.6.6. Apparently this was working previously, the only thing that I can think that has changed is that we now use SSL (but Im not aware this has broken anything else). What Im seeing is: If Im viewing a ticket and click reply Then I click browse for attaching a file Select a file on my local PC now click update for the ticket, it breaks, it shows as the URL: https://www.myserver.com/Ticket/Update.html and a blank page. Any ideas?? thanks for any help, Andy. ___ 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
Re: [rt-users] Commands by email
On Tue 14.Oct'08 at 13:00:10 +0200, Richard Hartmann wrote: Hi all, I thought RT 3.8.x had email commands incorporated and does not need CommandByMail, any more. Yet, I can't see anything in the docs/wiki about it. I don't want to enable the plugin without checking if that is the right way to go. So, does RT 3.8.x come with CommandByMail or not? No, it's not built in to 3.8 Thanks, Richard ___ 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 -- pgpVjilpWxD3n.pgp Description: PGP signature ___ 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
Re: [rt-users] Modify the Create Ticket screen
mind sharing how exactly you fixed it so all can benefit (and by all i mean me.. lol)? :) -gabe -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kenneth Crocker Sent: Friday, October 10, 2008 6:09 PM To: rt Users Subject: [rt-users] Modify the Create Ticket screen DUH! I'm such an idiot. I found it and fixed it on my own. I HATE it when I do that. Sorry folks. Kenn LBNL ___ 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 ___ 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
Re: [rt-users] Modify the Create Ticket screen
Gabriel, Sure. However, a warning. To modify RT screens and such, you have to get into code that can be real hard to follow, at least for me as I'm a beginner perl guy. First, copy /share/html/Ticket/Create.html to /local/html/Ticket/Create.html. MAke your changes to your local copy. I'm not sure what you want to change. I wanted to remove the Describe the Issue portion as we use a Global/mandatory description field for problem descriptions and having two description fields on the create screen was disconcerting. So, since my CF was Global AND Mandatory, and I couldn't figure out how to keep it off the create screen, I dropped the Describe the Issue portion from the bottom of the screen. Hope this helps. Kenn LBNL On 10/14/2008 5:27 AM, Gabriel Cadieux wrote: mind sharing how exactly you fixed it so all can benefit (and by all i mean me.. lol)? :) -gabe -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kenneth Crocker Sent: Friday, October 10, 2008 6:09 PM To: rt Users Subject: [rt-users] Modify the Create Ticket screen DUH! I'm such an idiot. I found it and fixed it on my own. I HATE it when I do that. Sorry folks. Kenn LBNL ___ 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 ___ 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
Re: [rt-users] cannot attach files to tickets via web interface
Hi, Ok I resolved that issue, for some reason it wasnt using the temp dir of the www user, even when I put a dir called tmp in there. But I had a read through the CGI.pm file and found that after the home dir the first place it tries is /usr/tmp which did exist but wasnt writeable by www, after changing the permissions on this dir I can attach files :). But now strangely the attachements arent sent to the ticket requester :S although you can see the attachement (and download it) via the web interface by looking at the call history. Is this the expected functionality? :S thanks Andy. ___ 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
Re: [rt-users] RT Upgrade 3.2.2 - 3.8.1: HTML::Mason goes intoinfinite loop.
Did I ask the question the wrong way? At this point, any ideas are appreciated. Has anyone successfully upgraded their database from =3.2.2 to 3.8.1? --Buck -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Golemon, Buck Sent: Monday, October 13, 2008 6:38 PM To: RT Users List Cc: Descamps, Gilles-Eric; Lee, Mark (SV) Subject: [rt-users] RT Upgrade 3.2.2 - 3.8.1: HTML::Mason goes intoinfinite loop. The installation works just find with a pristine database, but when I copy over my old database and follow the instructions at UPGRADING.mysql, I get this error: (see attached). This went on for two million lines before I stopped the server. It finally gets into a three-line loop like this: (again, see attached). I got some errors from schema.mysql-4.0-4.1.pl like this: # perl etc/upgrade/schema.mysql-4.0-4.1.pl rt3 rt_user rt_pass sql.queries Use of uninitialized value in numeric gt () at etc/upgrade/schema.mysql-4.0-4.1.pl line 310. Use of uninitialized value in numeric gt () at etc/upgrade/schema.mysql-4.0-4.1.pl line 310. Use of uninitialized value in numeric gt () at etc/upgrade/schema.mysql-4.0-4.1.pl line 310. Use of uninitialized value in numeric gt () at etc/upgrade/schema.mysql-4.0-4.1.pl line 310. I had to replace all the occurrences (three total) of 'BLOB CHARACTER SET utf8' with just 'BLOB', since BLOB doesn't have a character set, and this is a syntax error in mysql. I also dropped and recreated the sessions table because it was corrupted. I did it like this: drop table sessions; CREATE TABLE `sessions` ( `id` varchar(32) NOT NULL default '', `a_session` longblob NOT NULL, `LastUpdated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 Thanks in advance, --Buck ___ 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
[rt-users] RT Attachment issue from 3.6.3 to 3.8.1
Hi All, I've upgraded my RT system from 3.6.3 to 3.8.1 successfully (Both versions are running with MYSQL 5). However I can't get the 3.8.1 to work with attachments. All Word,Excel,Jpg and other documents display as garbage. Then as a test I've installed a fresh RT 3.8.1 onto a another system. But the result is the same with fresh install with fresh database. What am I doing wrong? Any help much appriciated. Cheers, CP Here is my SHOW CREATE TABLE Attachments; output. | Attachments | CREATE TABLE `Attachments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `TransactionId` int(11) NOT NULL DEFAULT '0', `Parent` int(11) NOT NULL DEFAULT '0', `MessageId` varchar(160) DEFAULT NULL, `Subject` varchar(255) DEFAULT NULL, `Filename` varchar(255) DEFAULT NULL, `ContentType` varchar(80) DEFAULT NULL, `ContentEncoding` varchar(80) DEFAULT NULL, `Content` longtext, `Headers` longtext, `Creator` int(11) NOT NULL DEFAULT '0', `Created` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `Attachments1` (`Parent`), KEY `Attachments2` (`TransactionId`), KEY `Attachments3` (`Parent`,`TransactionId`) ) ENGINE=InnoDB AUTO_INCREMENT=31223 DEFAULT CHARSET=latin1 | ___ 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
Re: [rt-users] Approval workflow problem
Hi sunnavy
1 I checked the scrip, my RT seems to have it. Some info are below:
(1) my RT view
http://www.nabble.com/file/p19986078/10.png
(2) Custom action preparation code(copy from RT web interface):
# --- #
return(0) unless ( lc($self-TransactionObj-NewValue) eq rejected or
lc($self-TransactionObj-NewValue) eq deleted );
my $rejected = 0;
my $links = $self-TicketObj-DependedOnBy;
foreach my $link (@{ $links-ItemsArrayRef }) {
my $obj = $link-BaseObj;
if ($obj-QueueObj-IsActiveStatus($obj-Status)) {
if ($obj-Type eq 'ticket') {
$obj-Comment(
Content = $self-loc(Your request was rejected.),
);
$obj-SetStatus(
Status = 'rejected',
Force = 1,
);
$T::Approval = $self-TicketObj; # so we can access it inside
templates
$self-{TicketObj} = $obj; # we want the original id in the token
line
$rejected = 1;
}
else {
$obj-SetStatus(
Status = 'deleted',
Force = 1,
);
}
}
}
$links = $self-TicketObj-DependsOn;
foreach my $link (@{ $links-ItemsArrayRef }) {
my $obj = $link-TargetObj;
if ($obj-QueueObj-IsActiveStatus($obj-Status)) {
$obj-SetStatus(
Status = 'deleted',
Force = 1,
);
}
}
# Now magically turn myself into a Requestor Notify object...
require RT::Action::Notify; bless($self, 'RT::Action::Notify');
$self-{Argument} = 'Requestor'; $self-Prepare;
return $rejected;
# --- #
2 I had checking the log, but I don't know how to read it.
I post it is below:
(1) when I created ticket, the log is below:
Oct 15 10:49:01 darkmoon RT: About to think about scrips for
transaction #452
Oct 15 10:49:01 darkmoon RT: About to think about scrips for transaction
#453
Oct 15 10:49:02 darkmoon RT: About to think about scrips for transaction
#454
Oct 15 10:49:02 darkmoon RT: About to think about scrips for transaction
#455
Oct 15 10:49:02 darkmoon RT: About to think about scrips for transaction
#456
Oct 15 10:49:02 darkmoon RT: About to prepare scrips for transaction #456
Oct 15 10:49:03 darkmoon RT: Found 5 scrips for TransactionCreate stage with
applicable type(s) Create
Oct 15 10:49:03 darkmoon RT: Line: ===
Oct 15 10:49:03 darkmoon RT: Line: ===Create-Ticket: poreq
Oct 15 10:49:03 darkmoon RT: Create ticket: create-poreq
Oct 15 10:49:04 darkmoon RT: Line: Subject: Approve purchase order for
{$Tickets{'TOP'}-Subject}
Oct 15 10:49:04 darkmoon RT: Line: Depended-On-By: TOP
Oct 15 10:49:04 darkmoon RT: Line: Queue: General
Oct 15 10:49:04 darkmoon RT: Line: Type: approval
Oct 15 10:49:05 darkmoon RT: Line: Owner: andro
Oct 15 10:49:05 darkmoon RT: Line: Content: Someone has created a purchase
requisition. Please review and approve it, so they can spend some money.
Oct 15 10:49:05 darkmoon RT: Line: ENDOFCONTENT
Oct 15 10:49:06 darkmoon RT: About to commit scrips for transaction #456
Oct 15 10:49:06 darkmoon RT: Committing scrip #16 on txn #456 of ticket #69
Oct 15 10:49:06 darkmoon RT: In CreateByTemplate
Oct 15 10:49:06 darkmoon RT: Workflow: processing create-poreq of
RT::Ticket=HASH(0x4f0ebc0)
Oct 15 10:49:07 darkmoon RT: Workflow: evaluating Subject: Approve purchase
order for {$Tickets{'TOP'}-Subject} Depended-On-By: TOP Queue: General
Type: approval Owner: andro Content: Someone has created a purchase
requisition. Please review and approve it, so they can spend some money.
ENDOFCONTENT
Oct 15 10:49:07 darkmoon RT: Workflow: yielding Subject: Approve purchase
order for A10 Depended-On-By: TOP Queue: General Type: approval Owner: andro
Content: Someone has created a purchase requisition. Please review
andapprove it, so they can spend some money. ENDOFCONTENT
Oct 15 10:49:07 darkmoon RT: About to think about scrips for transaction
#457
Oct 15 10:49:07 darkmoon RT: About to think about scrips for transaction
#458
Oct 15 10:49:08 darkmoon RT: About to think about scrips for transaction
#459
Oct 15 10:49:08 darkmoon RT: About to think about scrips for transaction
#460
Oct 15 10:49:08 darkmoon RT: About to think about scrips for transaction
#461
Oct 15 10:49:08 darkmoon RT: About to prepare scrips for transaction #461
Oct 15 10:49:09 darkmoon RT: Found 5 scrips for TransactionCreate stage with
applicable type(s) Create
Oct 15 10:49:09 darkmoon RT: Line: ===
Oct 15 10:49:09 darkmoon RT: Line: ===Create-Ticket: poreq
Oct 15 10:49:09 darkmoon RT: Create ticket: create-poreq
Oct 15 10:49:10 darkmoon RT: Line: Subject: Approve purchase order for
{$Tickets{'TOP'}-Subject}
Oct 15 10:49:10 darkmoon RT: Line: Depended-On-By: TOP
Oct 15 10:49:10 darkmoon RT: Line: Queue: General
Oct 15 10:49:10 darkmoon RT: Line: Type: approval
Oct 15 10:49:11 darkmoon RT:
[rt-users] themes?
Hi I upgraded my RT installation to 3.8.1 and have now completely lost all of the themes. Can someone point out where I might be able to change the setting( or configuration) to allow the use of themes? In the preferences, I have set it to web2, but at the moment, it only shows a non-graphical RT interface. I'm running Apache 2.0.54 with PHP 5.4.4. Any help appreciated. Edmund ___ 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
