[rt-users] Help with mySQL query to prune RT3 database before upgrading to RT 4.2.5

2014-06-19 Thread Lists
Hi, As I have posted recently, I am working on upgrading our current production RT 3.8.1 to RT 4.2.5 I have a working copy of RT 3.8.1 on my test server including a copy of our current production database which is over 18 gig of old data. I have imported this database into RT 4 and when I r

Re: [rt-users] Help with mySQL query to prune RT3 database before upgrading to RT 4.2.5

2014-06-19 Thread Darin Perusich
http://requesttracker.wikia.com/wiki/Shredder -- Later, Darin On Thu, Jun 19, 2014 at 12:56 PM, Lists wrote: > Hi, > > As I have posted recently, I am working on upgrading our current production > RT 3.8.1 to RT 4.2.5 > > I have a working copy of RT 3.8.1 on my test server including a copy of ou

Re: [rt-users] Help with mySQL query to prune RT3 database before upgrading to RT 4.2.5

2014-06-19 Thread Alex Vandiver
On 06/19/2014 12:56 PM, Lists wrote: > I have a working copy of RT 3.8.1 on my test server including a copy of > our current production database which is over 18 gig of old data. I > have imported this database into RT 4 and when I run make > upgrade-database against the RT4 database, it runs a wh

Re: [rt-users] Help with mySQL query to prune RT3 database before upgrading to RT 4.2.5

2014-06-20 Thread Alex Vandiver
On 06/19/2014 03:24 PM, Lists wrote: > [snip] Please keep all replies on-list. > I will try the upgrade-database again. The script did not report any > additional information other than it was killed. The precise error is important, as is the location in the upgrade process where it was reporte

Re: [rt-users] Help with mySQL query to prune RT3 database before upgrading to RT 4.2.5

2014-06-20 Thread Lists
The make upgrade-database process runs for a short while and this is what I get from the command line. Proceed [y/N]:y Processing 3.8.2 Now inserting data. [25360] [Fri Jun 20 15:49:26 2014] [warning]: Going to add [OLD] prefix to all templates in approvals queue. If you have never used appro

Re: [rt-users] Help with mySQL query to prune RT3 database before upgrading to RT 4.2.5

2014-06-20 Thread Kevin Falcone
On Fri, Jun 20, 2014 at 12:26:11PM -0500, Lists wrote: > > The make upgrade-database process runs for a short while and this is what I > get from the command line. > > Proceed [y/N]:y > Processing 3.8.2 > Now inserting data. > [25360] [Fri Jun 20 15:49:26 2014] [warning]: Going to add [OLD] prefi

Re: [rt-users] Help with mySQL query to prune RT3 database before upgrading to RT 4.2.5

2014-06-20 Thread Lists
On 6/20/2014 2:39 PM, Kevin Falcone wrote: On Fri, Jun 20, 2014 at 12:26:11PM -0500, Lists wrote: The make upgrade-database process runs for a short while and this is what I get from the command line. Proceed [y/N]:y Processing 3.8.2 Now inserting data. [25360] [Fri Jun 20 15:49:26 2014] [warn

Re: [rt-users] Help with mySQL query to prune RT3 database before upgrading to RT 4.2.5

2014-06-23 Thread Alex Vandiver
On 06/20/2014 07:16 PM, Lists wrote: > When I run this against the database I am trying to upgrade, I get: > > mysql> select count(*) from Attributes; > +--+ > | count(*) | > +--+ > | 1831962 | > +--+ > 1 row in set (2.50 sec) > > mysql> select count(*) from Attributes wh

Re: [rt-users] Help with mySQL query to prune RT3 database before upgrading to RT 4.2.5

2014-06-23 Thread Lists
Thanks for the info Alex, I appreciate it and will give it a try. Dave On 6/23/2014 11:29 AM, Alex Vandiver wrote: On 06/20/2014 07:16 PM, Lists wrote: When I run this against the database I am trying to upgrade, I get: mysql> select count(*) from Attributes; +--+ | count(*) | +--