[rt-users] rt-shredder madness

[Kevin Falcone]

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
> work.

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'
> [25293] [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'
> [25298] [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
completed?

-kevin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 235 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140620/0c51cabe/attachment.sig>