<font color='black' size='2' face='Arial, Helvetica, sans-serif'>
<div>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</div>
<div> </div>
<div>Thanks,<br>
<br>
<br>
</div>
<div style="FONT-FAMILY: arial,helvetica; COLOR: black; FONT-SIZE: 10pt">-----Original Message-----<br>
From: Gerrard Leach <gleach@btisystems.com><br>
To: rt-users <rt-users@lists.bestpractical.com><br>
Sent: Tue, Feb 7, 2012 3:49 pm<br>
Subject: Re: [rt-users] Upgraded from 3.8.7 to 4.0.5<br>
<br>
<div style="BACKGROUND-COLOR: #fff; MARGIN: 0px; FONT-FAMILY: Tahoma, Verdana, Arial, Sans-Serif; COLOR: #000; FONT-SIZE: 12px" id=AOLMsgPart_0_a86c8e52-26b8-4ca3-b850-eb98fe5de3d1><PRE style="FONT-SIZE: 9pt"><TT>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: <A __removedLink__66789389__href="mailto:rt-users-bounces@lists.bestpractical.com">rt-users-bounces@lists.bestpractical.com</A> [<A __removedLink__66789389__href="mailto:rt-users-bounces@lists.bestpractical.com?">mailto:rt-users-bounces@lists.bestpractical.com</A>]
On Behalf Of Kevin Falcone
Sent: Tuesday, February 07, 2012 3:44 PM
To: <A __removedLink__66789389__href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</A>
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: <A __removedLink__66789389__href="mailto:rt-users-bounces@lists.bestpractical.com">rt-users-bounces@lists.bestpractical.com</A>
> [<A __removedLink__66789389__href="mailto:rt-users-bounces@lists.bestpractical.com?">mailto:rt-users-bounces@lists.bestpractical.com</A>] On Behalf Of Kevin
> Falcone
> Sent: Tuesday, February 07, 2012 3:04 PM
> To: <A __removedLink__66789389__href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</A>
> 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 (<A target=_blank __removedLink__66789389__href="http://bestpractical.com/services/training.html">http://bestpractical.com/services/training.html</A>)
> * Boston March 5 & 6, 2012
--------
RT Training Sessions (<A target=_blank __removedLink__66789389__href="http://bestpractical.com/services/training.html">http://bestpractical.com/services/training.html</A>)
* Boston March 5 & 6, 2012
</TT></PRE></div>
<!-- end of AOLMsgPart_0_a86c8e52-26b8-4ca3-b850-eb98fe5de3d1 --></div>
</font>