Hi,
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.
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 130.
(/opt/rt4/sbin/../lib/RT/Tickets.pm:3030)
Couldn't load plugin
Error: Bad query argument, error: 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 130.
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
/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 589.
(/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:589)
[25298] [Fri Jun 20 15:21:32 2014] [warning]: RT::Handle=HASH(0x1190db8)
couldn't execute the query 'SELECT main.* FROM Tickets main WHERE
(main.IsMerged IS NULL) AND (main.Type = 'ticket') AND ( (
main.LastUpdated >= '2007-01-10 06:00:00' AND main.LastUpdated <
'2007-01-11 06:00:00' ) ) ORDER BY main.id ASC LIMIT 10' at
/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 602.
DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x1190db8),
"SELECT main.* FROM Tickets main WHERE (main.IsMerged IS NULL"...)
called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 239
DBIx::SearchBuilder::_DoSearch(RT::Tickets=HASH(0x591c288))
called at /opt/rt4/sbin/../lib/RT/SearchBuilder.pm line 983
RT::SearchBuilder::_DoSearch(RT::Tickets=HASH(0x591c288))
called at /opt/rt4/sbin/../lib/RT/Tickets.pm line 2377
RT::Tickets::_DoSearch(RT::Tickets=HASH(0x591c288)) called at
/usr/local/share/perl5/DBIx/SearchBuilder.pm line 507
DBIx::SearchBuilder::Next(RT::Tickets=HASH(0x591c288)) called
at /opt/rt4/sbin/../lib/RT/Tickets.pm line 2349
RT::Tickets::Next(RT::Tickets=HASH(0x591c288)) called at
/opt/rt4/sbin/../lib/RT/Shredder.pm line 354
RT::Shredder::CastObjectsToRecords("RT::Shredder", "Objects",
RT::Tickets=HASH(0x591c288)) called at
/opt/rt4/sbin/../lib/RT/Shredder.pm line 363
RT::Shredder::CastObjectsToRecords("RT::Shredder", "Objects",
ARRAY(0x357c608)) called at ./rt-shredder line 268
main::process_plugins(RT::Shredder=HASH(0x10af448)) called at
./rt-shredder line 164 (/usr/local/share/perl5/Carp.pm:169)
Objects list is empty, try refine search options
The two errors I keep encountering are
Error: Bad query argument, error: Wrong query, expecting a AGGREGATOR ....
or
Objects list is empty, try refine search options
Like I said, I have tried many variations.
Can anyone see what I am doing wrong?
Thanks,
Dave
--
RT Training - Boston, September 9-10
http://bestpractical.com/training
