<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>Hi guys,</div><div><br></div><div>I'm just testing an upgrade from 3.6.3 to 3.8.4. I ran the rt-setup-database fine:</div><div><br></div><blockquote class="webkit-indent-blockquote" style="margin: 0 0 0 40px; border: none; padding: 0px;">/opt/rt_support.openbet.com/sbin/rt-setup-database -dba rt_support --prompt-for-dba-password --action upgrade</blockquote><div><div><br></div><div>Then created the schema upgrade script:</div></div><div><br></div><blockquote class="webkit-indent-blockquote" style="margin: 0 0 0 40px; border: none; padding: 0px;">perl /opt/rt_support.openbet.com/etc/upgrade/upgrade-mysql-schema.pl *blah* *blah* *password* > upgrade.sql<br>Use of uninitialized value in join or string at /opt/rt_support.openbet.com/etc/upgrade/upgrade-mysql-schema.pl line 261.<br>.Tickets.status has type VARCHAR however mapping is missing.<br>Use of uninitialized value in join or string at /opt/rt_support.openbet.com/etc/upgrade/upgrade-mysql-schema.pl line 261.<br>.Users.BlockImg has type CHAR however mapping is missing.<br>-- ** NOTICE: No database changes have been made. **<br>-- Please review the generated SQL, ensure you have a full backup of your database <br>-- and apply it to your database using a command like:<br>-- mysql -u rt_support -p rt_support < queries.sql";<br><br>cat upgrade.sql <br>ALTER DATABASE rt_support DEFAULT CHARACTER SET utf8;<br>ALTER TABLE ACL<br> DEFAULT CHARACTER SET utf8,<br> MODIFY RightName VARBINARY(25) NOT NULL,<br> MODIFY PrincipalType VARBINARY(25) NOT NULL,<br> MODIFY ObjectType VARBINARY(25) NOT NULL;<br>ALTER TABLE ACL<br> MODIFY RightName VARCHAR(25) CHARACTER SET ascii NOT NULL,<br> MODIFY PrincipalType VARCHAR(25) CHARACTER SET ascii NOT NULL,<br> MODIFY ObjectType VARCHAR(25) CHARACTER SET ascii NOT NULL;<br>ALTER TABLE Attachments<br> DEFAULT CHARACTER SET utf8,<br> MODIFY Subject VARBINARY(255) NULL DEFAULT NULL,<br> MODIFY ContentType VARBINARY(80) NULL DEFAULT NULL,<br> MODIFY Filename VARBINARY(255) NULL DEFAULT NULL,<br> MODIFY Headers LONGBLOB NULL DEFAULT NULL,<br> MODIFY MessageId VARBINARY(160) NULL DEFAULT NULL,<br> MODIFY Content LONGBLOB NULL DEFAULT NULL,<br> MODIFY ContentEncoding VARBINARY(80) NULL DEFAULT NULL;<br>ALTER TABLE Attachments<br> MODIFY Subject VARCHAR(255) CHARACTER SET utf8 NULL DEFAULT NULL,<br> MODIFY ContentType VARCHAR(80) CHARACTER SET ascii NULL DEFAULT NULL,<br> MODIFY Filename VARCHAR(255) CHARACTER SET utf8 NULL DEFAULT NULL,<br> MODIFY Headers LONGTEXT CHARACTER SET utf8 NULL DEFAULT NULL,<br> MODIFY MessageId VARCHAR(160) CHARACTER SET ascii NULL DEFAULT NULL,<br> MODIFY ContentEncoding VARCHAR(80) CHARACTER SET ascii NULL DEFAULT NULL;</blockquote><blockquote class="webkit-indent-blockquote" style="margin: 0 0 0 40px; border: none; padding: 0px;">.</blockquote><blockquote class="webkit-indent-blockquote" style="margin: 0 0 0 40px; border: none; padding: 0px;">.</blockquote><blockquote class="webkit-indent-blockquote" style="margin: 0 0 0 40px; border: none; padding: 0px;">.</blockquote><blockquote class="webkit-indent-blockquote" style="margin: 0 0 0 40px; border: none; padding: 0px;"><br></blockquote><div><br></div><div>
<span class="Apple-style-span" style="font-size: 12px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>Now that looks a bit odd as there are 2 ALTERS per table and the second seems to reverse some bits of the first?</div><div><br></div><div>Anyway I ran that into my DB. Now when I go into a ticket with an image attached and click on it no image is returned, which is a bit worrying.</div><div><br></div><div>I'm wondering if it was a problem with the upgrade, or the original db dump provided by my IT systems guys. Perhaps the DB wasn't dumped using binary character set? How could I check that and how should the IT guys have dumped the DB to make sure it was in binary?</div><div><br></div><div>Any thoughts?</div><div><br></div><div>Justin</div><div><br></div><div>-------------------------------------------------</div><div>Justin Hayes</div><div>Orbis Support Manager</div><div><a href="mailto:justin.hayes@orbisuk.com">justin.hayes@orbisuk.com</a></div><div><br></div></div></span><br class="Apple-interchange-newline"><br class="Apple-interchange-newline">
</div>
<br></body></html>