Kevin,
Interesting, I'll go back through my notes etc. IIRC the DB was a
restored fron our rt3 prod DB and then the upgrade procedures applied.
-Ron
On 1/30/2012 3:18 PM, Kevin Falcone wrote:
On Mon, Jan 30, 2012 at 03:06:05PM -0500, Ronald J. Yacketta wrote:
We ran into the following schema.mysql error during our upgrade from
3.8.8 to 4.0.04, after some investigation it appears that it stems
from using RTFM in 3.8.8.
RTFM used the table FM_Classes, not Classes.
If you already had a Classes table, then you did some part of your
upgrade wrong.
I suspect that you ran make initialize-database from 4.0 and then
restored your 3.8.8 database into the rt4 database, which is wrong and
leaves new RT4 tables around.
-kevin
Processing 3.9.8
Now populating database schema.
[Mon Jan 30 20:00:30 2012] [crit]: DBD::mysql::st execute failed:
Table 'Classes' already exists at
/root/src/rt-4.0.4/sbin/../lib/RT/Handle.pm line 517.
(/root/src/rt-4.0.4/sbin/../lib/RT.pm:341)
DBD::mysql::st execute failed: Table 'Classes' already exists at
/root/src/rt-4.0.4/sbin/../lib/RT/Handle.pm line 517.
Our solution was to re-ran 'make upgrade-database' using 3.9.9 as
the version upgrading from.
--------
RT Training Sessions (http://bestpractical.com/services/training.html)
* Boston --- March 5& 6, 2012
--------
RT Training Sessions (http://bestpractical.com/services/training.html)
* Boston March 5 & 6, 2012
