[rt-users] Upgraded from 3.8.7 to 4.0.5

Gerrard Leach gleach at btisystems.com
Tue Feb 7 15:48:48 EST 2012


I reran this script and noticed that it complained about access to the remote MySQL database.
Looked into MySQL, and root isn't accessible from remote users.

Updated root's access from remote machines and reran the script.
Restarted Apache and it is now working

Changed root's access back to local only.

Thanks Kevin
Gerrard

-----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:44 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 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



More information about the rt-users mailing list