Thanks for the information Kevin,
Yes, the upgrade completed with no problems. I had RT 4.2.5 running with
the default configs and default rt4 database. Long story short, I have
been having problems getting the database upgrade to complete so I was
attempting to trim the database before attempting to run the upgrade
script again.
The database I am attempting to run the RT 4.2.5 version of rt-shredder
is actually a renamed copy of my rt3 database before attempting to run
the database upgrade script, so it makes sense that a column would be
missing, etc.
I had begun to suspect that was the case but it was after 1:30 AM so I
wasn't motivated to run the 3.8.1 version of shredder against my rt3
database first.
I will try to trim my rt3 database using that version of rt-shredder
before importing into rt4 and if that doesn't work, I will report back.
Thankfully this is a test server so if I break something it's not critical.
Thanks,
Dave
On 6/20/2014 10:32 AM, Kevin Falcone wrote:
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
--
RT Training - Boston, September 9-10
http://bestpractical.com/training