[rt-users] rt-shredder madness
falcone at bestpractical.com
Fri Jun 20 11:32:41 EDT 2014
On Fri, Jun 20, 2014 at 10:26:38AM -0500, Lists wrote:
> I have been trying to run rt-shredder to clean up my database before
> upgrading and an unable to get it to work. I have been following the syntax
> either as presented by the ./rt-shredder --plugin help-Tickets as well as
> what is documented in the 4.2.5 section of the website and nothing seems to
One of your errors indicates this upgrade didn't go swimmingly, are
you sure it completed?
> As per the examples, here is the latest command I tried executing which
> errors out.
> ./rt-shredder --plugin 'Tickets=query,Status = "deleted" OR Status =
> "rejected" ) LastUpdated < '2006-11-29 20:34:26''
> SQL dump file is '/opt/rt4/sbin/20140620T152023-0001.sql'
>  [Fri Jun 20 15:20:23 2014] [error]: Couldn't parse query: Wrong
> query, expecting a AGGREGATOR in 'Status = "deleted" OR Status = "rejected"
> >)<--here LastUpdated < 2006-11-29' at /opt/rt4/sbin/../lib/RT/SQL.pm line
You have a closing paren, but no opening paren. This is invalid, it's
showing you the closing ) that lacks an opening (
> I have also tried other variations:
> ./rt-shredder --plugin 'Tickets=query,LastUpdated = "2007-01-10 22:31:10"'
> SQL dump file is '/opt/rt4/sbin/20140620T152132-0001.sql'
>  [Fri Jun 20 15:21:32 2014] [warning]: DBD::mysql::st execute failed:
> Unknown column 'main.IsMerged' in 'where clause' at
Tickets.IsMerged is a new column in RT 4.2, are you sure your upgrade
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Size: 235 bytes
Desc: not available
More information about the rt-users