Re: [rt-users] Delete large attachment

2007-06-15 Thread Tim Hill
14, 2007 1:23 PM To: Jeff Stark; 'Gene LeDuc'; 'Tim Hill' Cc: rt-users@lists.bestpractical.com Subject: RE: [rt-users] Delete large attachment Hey you guys might want to try the RTx::Shredder extension. You can find it on cpan: http://search.cpan.org/~ruz/RTx-Shredder-0.06/lib/RT

Re: [rt-users] Delete large attachment

2007-06-14 Thread Stephen Turner
At Thursday 6/14/2007 07:42 AM, Tim Hill wrote: Hi, I have a member of staff who has decided to attach docuements to his tickets in bitmap format, unfortunately these bitmap images are between 4 and 8 MB in size and they have taken up more space in a day of doing this than the rest of the RT

RE: [rt-users] Delete large attachment

2007-06-14 Thread Jeff Stark
: Gene LeDuc; Tim Hill Cc: rt-users@lists.bestpractical.com Subject: RE: [rt-users] Delete large attachment Hi Gene, What would you recommend for Custom Field Attachments? They are stored in the ObjectCustomFieldValues in the LargeContent field, correct? Would you do the same for that table? Thanks, - Stark

RE: [rt-users] Delete large attachment

2007-06-14 Thread Gene LeDuc
Sorry, I've never used the CF types "Upload one file" or "Upload multiple files". There aren't enough disclaimers to cover any advice I might give about CF Attachments! Gene At 10:11 AM 6/14/2007, Jeff Stark wrote: Hi Gene, What would you recommend for Custom Field Attachments? They are st

RE: [rt-users] Delete large attachment

2007-06-14 Thread Jeff Platter
ctical.com Subject: RE: [rt-users] Delete large attachment Hi Gene, What would you recommend for Custom Field Attachments? They are stored in the ObjectCustomFieldValues in the LargeContent field, correct? Would you do the same for that table? Thanks, - Stark The contents of this communi

RE: [rt-users] Delete large attachment

2007-06-14 Thread Jeff Stark
@lists.bestpractical.com Subject: Re: [rt-users] Delete large attachment Hi Tim, Best to try this on something harmless before assaulting your production database. Disclaimer - I don't know anything about PostgreSQL other than it's a database. I use MySQL, so my answer probably needs to be

Re: [rt-users] Delete large attachment

2007-06-14 Thread Gene LeDuc
Hi Tim, Best to try this on something harmless before assaulting your production database. Disclaimer - I don't know anything about PostgreSQL other than it's a database. I use MySQL, so my answer probably needs to be translated from MySQL to PostgreSQL. I also use RT 3.6.3, so there might

[rt-users] Delete large attachment

2007-06-14 Thread Tim Hill
Hi, I have a member of staff who has decided to attach docuements to his tickets in bitmap format, unfortunately these bitmap images are between 4 and 8 MB in size and they have taken up more space in a day of doing this than the rest of the RT system has taken up in almost a year of operation.