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

Ronald J. Yacketta yacketrj at potsdam.edu
Mon Jan 30 15:21:53 EST 2012


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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120130/35b1c580/attachment.htm>


More information about the rt-users mailing list