[rt-users] Upgraded from 3.8.7 to 4.0.5

Borngunners borngunners at aol.com
Wed Feb 15 12:38:11 EST 2012


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 <gleach at btisystems.com>
To: rt-users <rt-users at lists.bestpractical.com>
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: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] 
n Behalf Of Kevin Falcone
ent: Tuesday, February 07, 2012 3:44 PM
o: rt-users at lists.bestpractical.com
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: 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 
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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120215/2bf70fc2/attachment.htm>


More information about the rt-users mailing list