[rt-users] Upgraded from 3.8.7 to 4.0.5

Kevin Falcone falcone at bestpractical.com
Tue Feb 7 15:44:09 EST 2012 

On Tue, Feb 07, 2012 at 03:25:39PM -0500, Gerrard Leach wrote:
> [Tue Feb  7 20:22:49 2012] [warning]: DBD::mysql::st execute failed: Unknown column 'RenderType' in 'field list' at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587. (/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587) 

This implies you didn't run the database upgrades referred to in
README and docs/UPGRADING*

If you look back through your notes and logs, what happened when you
ran make upgrade-database?

If you missed that step, you may wish to review the rest of the
documentation to ensure that the other upgrade steps were completed.

-kevin

> [Tue Feb  7 20:22:49 2012] [warning]: RT::Handle=HASH(0x7fba542db0e0) couldn't execute the query 'INSERT INTO CustomFields (RenderType, Pattern, Creator, LastUpdatedBy, LookupType, Type, MaxValues, Repeated, Disabled, ValuesClass, BasedOn, Created, Description, Name, LastUpdated) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600
>         DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x7fba542db0e0)', 'INSERT INTO CustomFields (RenderType, Pattern, Creator, LastU...', undef, '', 9655, 9655, 'RT::Queue-RT::Ticket', 'Freeform', 1, ...) called at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 350
>         DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0x7fba542db0e0)', 'CustomFields', 'RenderType', undef, 'Pattern', '', 'Creator', 9655, 'LastUpdatedBy', ...) called at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle/mysql.pm line 36
>         DBIx::SearchBuilder::Handle::mysql::Insert('RT::Handle=HASH(0x7fba542db0e0)', 'CustomFields', 'RenderType', undef, 'Pattern', '', 'Creator', 9655, 'LastUpdatedBy', ...) called at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1292
>         DBIx::SearchBuilder::Record::Create('RT::CustomField=HASH(0x7fba5518e6c0)', 'RenderType', undef, 'Creator', 9655, 'Pattern', '', 'LastUpdatedBy', 9655, ...) called at /opt/rt4/sbin/../lib/RT/Record.pm line 316
>         RT::Record::Create('RT::CustomField=HASH(0x7fba5518e6c0)', 'Name', 'SLA', 'Type', 'Freeform', 'RenderType', undef, 'MaxValues', 1, ...) called at /opt/rt4/sbin/../lib/RT/CustomField.pm line 377
>         RT::CustomField::Create('RT::CustomField=HASH(0x7fba5518e6c0)', 'Name', 'SLA', 'TypeComposite', 'Freeform-1', 'LookupType', 'RT::Queue-RT::Ticket', 'Description', 'Is the SLA applicable to this ticket', ...) called at /opt/rt4/share/html/Admin/CustomFields/Modify.html line 167
>         HTML::Mason::Commands::__ANON__('IncludeContentForValue', '', 'SetEnabled', 1, 'Enabled', 1, 'LinkValueTo', '', 'Pattern', ...) called at /usr/local/share/perl/5.10.1/HTML/Mason/Component.pm line 135
>         HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fba54d4a9a0)', 'IncludeContentForValue', '', 'SetEnabled', 1, 'Enabled', 1, 'LinkValueTo', '', ...) called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1302
>         eval {...} called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1292
>         HTML::Mason::Request::comp(undef, undef, undef, 'IncludeContentForValue', '', 'SetEnabled', 1, 'Enabled', 1, ...) called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 955
>         HTML::Mason::Request::call_next('RT::Interface::Web::Request=HASH(0x7fba55219fc8)', 'Pattern', '', 'Update', 'Create', 'id', 'new', 'TypeComposite', 'Freeform-1', ...) called at /opt/rt4/share/html/Admin/autohandler line 49
>         HTML::Mason::Commands::__ANON__('IncludeContentForValue', '', 'SetEnabled', 1, 'Enabled', 1, 'LinkValueTo', '', 'Pattern', ...) called at /usr/local/share/perl/5.10.1/HTML/Mason/Component.pm line 135
>         HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fba54d33b18)', 'IncludeContentForValue', '', 'SetEnabled', 1, 'Enabled', 1, 'LinkValueTo', '', ...) called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1302
>         eval {...} called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1292
>         HTML::Mason::Request::comp(undef, undef, undef, 'IncludeContentForValue', '', 'SetEnabled', 1, 'Enabled', 1, ...) called at /opt/rt4/sbin/../lib/RT/Interface/Web.pm line 548
>         RT::Interface::Web::ShowRequestedPage('HASH(0x7fba5523be48)') called at /opt/rt4/sbin/../lib/RT/Interface/Web.pm line 295
>         RT::Interface::Web::HandleRequest('HASH(0x7fba5523be48)') called at /opt/rt4/share/html/autohandler line 53
>         HTML::Mason::Commands::__ANON__('Pattern', '', 'Update', 'Create', 'id', 'new', 'TypeComposite', 'Freeform-1', 'IncludeContentForValue', ...) called at /usr/local/share/perl/5.10.1/HTML/Mason/Component.pm line 135
>         HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fba54321118)', 'Pattern', '', 'Update', 'Create', 'id', 'new', 'TypeComposite', 'Freeform-1', ...) called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1297
>         eval {...} called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1292
>         HTML::Mason::Request::comp(undef, undef, undef, 'Pattern', '', 'Update', 'Create', 'id', 'new', ...) called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 481
>         eval {...} called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 481
>         eval {...} called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 433
>         HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x7fba55219fc8)') called at /usr/local/share/perl/5.10.1/HTML/Mason/PSGIHandler.pm line 85
>         eval {...} called at /usr/local/share/perl/5.10.1/HTML/Mason/PSGIHandler.pm line 85
>         HTML::Mason::Request::PSGI::exec('RT::Interface::Web::Request=HASH(0x7fba55219fc8)') called at /usr/local/share/perl/5.10.1/HTML/Mason/Interp.pm line 342
>         HTML::Mason::Interp::exec(undef, undef, 'Pattern', '', 'Update', 'Create', 'id', 'new', 'TypeComposite', ...) called at /usr/local/share/perl/5.10.1/HTML/Mason/PSGIHandler.pm line 48
>         eval {...} called at /usr/local/share/perl/5.10.1/HTML/Mason/PSGIHandler.pm line 48
>         HTML::Mason::PSGIHandler::invoke_mason('HTML::Mason::PSGIHandler::Streamy=HASH(0x7fba481aa990)', 'HTML::Mason::FakeApache=HASH(0x7fba551c7698)', 'HASH(0x7fba5522c6a0)') called at /usr/local/share/perl/5.10.1/HTML/Mason/PSGIHandler/Streamy.pm line 52
>         HTML::Mason::PSGIHandler::Streamy::__ANON__('CODE(0x7fba5507f2c0)') called at /opt/rt4/sbin/../lib/RT/Interface/Web/Handler.pm line 255
>         RT::Interface::Web::Handler::__ANON__('CODE(0x7fba5507f2c0)') called at /usr/local/share/perl/5.10.1/Plack/Util.pm line 324
>         Plack::Util::__ANON__('CODE(0x7fba551c2908)') called at /usr/local/share/perl/5.10.1/Plack/Handler/Apache2.pm line 68
>         Plack::Handler::Apache2::call_app('Plack::Handler::Apache2', 'Apache2::RequestRec=SCALAR(0x7fba55045a70)', 'CODE(0x7fba481aa768)') called at /usr/local/share/perl/5.10.1/Plack/Handler/Apache2.pm line 91
>         Plack::Handler::Apache2::handler('Apache2::RequestRec=SCALAR(0x7fba55045a70)') called at -e line 0
>         eval {...} called at -e line 0 (/usr/share/perl/5.10/Carp.pm:47)
> 
> -----Original Message-----
> From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Kevin Falcone
> Sent: Tuesday, February 07, 2012 3:04 PM
> To: rt-users at lists.bestpractical.com
> Subject: Re: [rt-users] Upgraded from 3.8.7 to 4.0.5
> 
> On Tue, Feb 07, 2012 at 02:59:45PM -0500, Gerrard Leach wrote:
> >    I am trying to get a simple checkbox setup as a custom field when a ticket is created.
> > 
> >    I have selected a type of Select One Value,
> > 
> >    But when I choose a Render Type of list and save, I get an error "RenderType could not be set
> >    to List."
> 
> What shows up in your apache error logs?
> 
> -kevin
> --------
> RT Training Sessions (http://bestpractical.com/services/training.html)
> * Boston  March 5 & 6, 2012
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120207/837f75b9/attachment.sig>

More information about the rt-users mailing list