<div dir="ltr"><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Aug 2, 2013 at 10:48 AM, Kevin Falcone <span dir="ltr"><<a href="mailto:falcone@bestpractical.com" target="_blank">falcone@bestpractical.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div id=":4t" style="overflow:hidden">You can look at 'show create table sessions' which should be innodb<br>
not myisam and look at your Attributes table, which should have a<br>
LONGBLOB for Content.</div></blockquote></div><br>I just did my test upgrade from rt 3.8.2 / mysql 5.0.75 to rt 4.0.16 / mysql 5.5.32 </div><div class="gmail_extra">but session table still showing myisam.</div><div class="gmail_extra">
<br></div><div class="gmail_extra">$ mysql -e 'use rt4; show create table sessions'<br></div><div class="gmail_extra"><div class="gmail_extra">| sessions | CREATE TABLE `sessions` (</div><div class="gmail_extra">
`id` varbinary(32) NOT NULL DEFAULT '',</div>
<div class="gmail_extra"> `a_session` longblob,</div><div class="gmail_extra"> `LastUpdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,</div><div class="gmail_extra"> PRIMARY KEY (`id`)</div>
<div class="gmail_extra">) ENGINE=MyISAM DEFAULT CHARSET=utf8 |</div><div><br></div><div>I guess I can just ALTER the session table now? </div><div><br></div><div><br></div></div><div class="gmail_extra"><br><br clear="all">
<div><br></div>-- <br>Asif Iqbal<br>PGP Key: 0xE62693C5 KeyServer: <a href="http://pgp.mit.edu">pgp.mit.edu</a><br>A: Because it messes up the order in which people normally read text.<br>Q: Why is top-posting such a bad thing?<br>
<br>
</div></div>