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 where Name =

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(*) |

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

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

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] prefix to

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]

[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

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 li...@lolling.org 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

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 while