<div dir="ltr">Ok. So I have done some additional investigation and here is what I have found. The new Queues table has two new fields named Lifecycle and SubjectTag. Lifecycle field is accessed in the RT::Init which is called at the top of action_insert before it can do the insert portion of the first upgrade step... I think. It is looking like the code is assuming stuff about the database structure which isn't true just in trying to set up to do the upgrade steps.<div><br></div><div>I suppose this means I am trying to jump too many versions at once and I need to do an intermediate upgrade at an intermediate step. Probably at the version which introduces these columns. If that version couldn't have upgraded everyone would have gotten stuck.</div><div><br></div><div style>Sound plausible?</div><div style>~Joshua</div><div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Feb 6, 2015 at 7:05 AM, Joshua Lansford <span dir="ltr"><<a href="mailto:joshua.lansford@laserlinc.com" target="_blank">joshua.lansford@laserlinc.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hello.<div> I am trying to upgrade from 3.8.11 to stable and make upgrade-database is bombing. The error message is </div><div>=====</div><div><div>9449] [Thu Feb 5 19:23:36 2015] [critical]: DBD::mysql::db selectcol_arrayref failed: Unknown column 'main.Lifecycle' in 'field list' at /usr/local/share/perl/5.18.2/DBIx/SearchBuilder.pm line 635. (/home/user/temp/rt/sbin/../lib/RT.pm:388)</div><div>DBD::mysql::db selectcol_arrayref failed: Unknown column 'main.Lifecycle' in 'field list' at /usr/local/share/perl/5.18.2/DBIx/SearchBuilder.pm line 635.</div><div>make: *** [upgrade-database] Error 255</div><div>=====</div><div><br></div><div>I setup a fresh vm for this job to test. I was able to set up RT from stable just fine without an upgrade. So then I dropped that rt4 database, deleted the /opt/rt4 install folder, dumped the rtdb old database to a sql file. Copied the sql dump over to the vm. Imported it as rt4. Did make upgrade to recreate the rt4 folder. Configured the database user and password in RT_SiteConfig.pm. Granted permissions to the rt4 user with that password to the rt4 folder and hit make upgrade-database. After giving the root mysql password the above error is presented.</div><div><br></div><div>Assistance at this point would be appreciated. Let me know what additional information I can provide.</div><div>Thank you,</div><div>~Joshua</div></div></div>
</blockquote></div><br></div></div></div>