[rt-users] RT 3.8.8 -> RT 4.0.4 schema.mysql error

[Kevin Falcone]

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.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120130/e915c93c/attachment.sig>