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