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: [email protected]
> [mailto:[email protected]] On Behalf Of Kevin Falcone
> Sent: Tuesday, February 07, 2012 3:04 PM
> To: [email protected]
> 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
pgpYqUSWs1ojb.pgp
Description: PGP signature
-------- RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
