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
pgpQSVBjJBg3b.pgp
Description: PGP signature
-- RT Training - Boston, September 9-10 http://bestpractical.com/training
