Can you please share your configuration with me as I am unable to create ticket. Anytime I try to create a ticket, it spit out an error message "Ticket could not be created due to an internal error" I have version 4.0.5 as well
Thanks, -----Original Message----- From: Gerrard Leach <[email protected]> To: rt-users <[email protected]> Sent: Tue, Feb 7, 2012 3:49 pm Subject: Re: [rt-users] Upgraded from 3.8.7 to 4.0.5 I reran this script and noticed that it complained about access to the remote ySQL database. ooked into MySQL, and root isn't accessible from remote users. Updated root's access from remote machines and reran the script. estarted Apache and it is now working Changed root's access back to local only. Thanks Kevin errard -----Original Message----- rom: [email protected] [mailto:[email protected]] n Behalf Of Kevin Falcone ent: Tuesday, February 07, 2012 3:44 PM o: [email protected] ubject: 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 ocs/UPGRADING* If you look back through your notes and logs, what happened when you ran make pgrade-database? If you missed that step, you may wish to review the rest of the documentation to nsure that the other upgrade steps were completed. -kevin > [Tue Feb 7 20:22:49 2012] [warning]: RT::Handle=HASH(0x7fba542db0e0) > couldn't xecute the query 'INSERT INTO CustomFields (RenderType, Pattern, Creator, astUpdatedBy, LookupType, Type, MaxValues, Repeated, Disabled, ValuesClass, asedOn, Created, Description, Name, LastUpdated) VALUES (?, ?, ?, ?, ?, ?, ?, , ?, ?, ?, ?, ?, ?, ?)' at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm ine 600 DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x7fba542db0e0)', INSERT INTO CustomFields (RenderType, Pattern, Creator, LastU...', undef, '', 655, 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 ine 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 ine 1292 DBIx::SearchBuilder::Record::Create('RT::CustomField=HASH(0x7fba5518e6c0)', RenderType', undef, 'Creator', 9655, 'Pattern', '', 'LastUpdatedBy', 9655, ...) alled 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 ine 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 ine 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 ine 1292 HTML::Mason::Request::comp(undef, undef, undef, 'IncludeContentForValue', ', 'SetEnabled', 1, 'Enabled', 1, ...) called at /opt/rt4/sbin/../lib/RT/Interface/Web.pm ine 548 RT::Interface::Web::ShowRequestedPage('HASH(0x7fba5523be48)') called t /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', ...) alled 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 ine 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 ine 481 eval {...} called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm ine 481 eval {...} called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm ine 433 HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x7fba55219fc8)') alled 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 ine 85 HTML::Mason::Request::PSGI::exec('RT::Interface::Web::Request=HASH(0x7fba55219fc8)') alled 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 ine 48 eval {...} called at /usr/local/share/perl/5.10.1/HTML/Mason/PSGIHandler.pm ine 48 HTML::Mason::PSGIHandler::invoke_mason('HTML::Mason::PSGIHandler::Streamy=HASH(0x7fba481aa990)', HTML::Mason::FakeApache=HASH(0x7fba551c7698)', 'HASH(0x7fba5522c6a0)') called t /usr/local/share/perl/5.10.1/HTML/Mason/PSGIHandler/Streamy.pm line 52 HTML::Mason::PSGIHandler::Streamy::__ANON__('CODE(0x7fba5507f2c0)') alled at /opt/rt4/sbin/../lib/RT/Interface/Web/Handler.pm line 255 RT::Interface::Web::Handler::__ANON__('CODE(0x7fba5507f2c0)') called t /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)') alled 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 icket 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 ------- T 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
