<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Kevin,<br>
<br>
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.<br>
<br>
-Ron<br>
On 1/30/2012 3:18 PM, Kevin Falcone wrote:
<blockquote cite="mid:20120130201857.GS95897@jibsheet.com"
type="cite">
<pre wrap="">On Mon, Jan 30, 2012 at 03:06:05PM -0500, Ronald J. Yacketta wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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.
</pre>
</blockquote>
<pre wrap="">
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
</pre>
<blockquote type="cite">
<pre wrap="">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.
</pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">--------
RT Training Sessions (<a class="moz-txt-link-freetext" href="http://bestpractical.com/services/training.html">http://bestpractical.com/services/training.html</a>)
* Boston — March 5 & 6, 2012</pre>
</blockquote>
</blockquote>
<br>
</body>
</html>