On Thu, Feb 28, 2008 at 9:14 PM, Kenneth Crocker <[EMAIL PROTECTED]> wrote:
> Shannon,
>
>
> Your code doesn't make any sense to me. You use "A" for the
> Attachments
> table and "T" for the Transactions table. But when you refer to the
> field in your code you wrote "T.Ticket". There is
Shannon,
Your code doesn't make any sense to me. You use "A" for the Attachments
table and "T" for the Transactions table. But when you refer to the
field in your code you wrote "T.Ticket". There is no "Ticket" field on
the Transaction table. That's probably why you got the error.
Update on this. I found some old posts and I am trying to use the following
command to display tickets by size:
mysql -u root -p -hlocalhost rt3 -e'select length(A.Content), A.id,
T.Ticket fromAttachments A, Transactions T where A.TransactionId = T.id order
by 1'
it returns:
"ERROR 1054 (42S
Once in a while, I use rtx-shredder to purge tickets older than a month that
are marked as deleted.
rtx-shredder --plugin "Tickets=limit,5000;status,deleted;updated_before,`date
-I -d '1 month ago'`" --force
We have some very old tickets that contain attachments that I would like to
purge. Fi