[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