[rt-users] errors on 3.6.5
Marco Avvisano
marco.avvisano at regione.toscana.it
Fri Oct 5 04:17:45 EDT 2007
These are only some errors from my http error log:
[[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: DBD::mysql::st execute failed: You
have an error in your SQL syntax near 'ON ( ObjectCustomFields_1.CustomField
= main.id ) WHERE (main.Disabled = '0') A' at line 1 at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line
505., referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: RT::Handle=HASH(0xad562ec)
couldn't execute the query 'SELECT DISTINCT main.* FROM CustomFields main
JOIN ObjectCustomFields ObjectCustomFields_1 ON (
ObjectCustomFields_1.CustomField = main.id ) WHERE (main.Disabled = '0')
AND (ObjectCustomFields_1.ObjectId = '3' OR ObjectCustomFields_1.ObjectId =
'0') AND (main.LookupType = 'RT::Queue-RT::Ticket') ORDER BY
ObjectCustomFields_1.ObjectId ASC, ObjectCustomFields_1.SortOrder ASC ' at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line
518, referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xad562ec)',
'SELECT DISTINCT main.* FROM CustomFields main JOIN ObjectCust...') called
at /usr/local/perl-5.8.5/lib/site_perl/5.8.5/DBIx/SearchBuilder.pm line 238,
referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!DBIx::SearchBuilder::_DoSearch('RT::CustomFields=HASH(0xb0b47c0)') called
at /opt/rt3/lib/RT/CustomFields_Overlay.pm line 172, referer:
http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!RT::CustomFields::_DoSearch('RT::CustomFields=HASH(0xb0b47c0)') called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/DBIx/SearchBuilder.pm line 498,
referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!DBIx::SearchBuilder::Next('RT::CustomFields=HASH(0xb0b47c0)') called at
/opt/rt3/lib/RT/CustomFields_Overlay.pm line 190, referer:
http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!RT::CustomFields::Next('RT::CustomFields=HASH(0xb0b47c0)') called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/DBIx/SearchBuilder.pm line 555,
referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!DBIx::SearchBuilder::First('RT::CustomFields=HASH(0xb0b47c0)') called at
/opt/rt3/share/html/Ticket/Elements/ShowSummary line 57, referer:
http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!HTML::Mason::Commands::__ANON__('Ticket', 'RT::Ticket=HASH(0x9d5bcc0)',
'Attachments', 'RT::Attachments=HASH(0xad45010)') called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Component.pm line 135,
referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xb0b47e4)',
'Ticket', 'RT::Ticket=HASH(0x9d5bcc0)', 'Attachments',
'RT::Attachments=HASH(0xad45010)') called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1262,
referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: !eval {...} called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1252,
referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!HTML::Mason::Request::comp('undef', 'undef', 'Ticket',
'RT::Ticket=HASH(0x9d5bcc0)', 'Attachments',
'RT::Attachments=HASH(0xad45010)') called at
/opt/rt3/share/html/Ticket/Display.html line 58, referer:
http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: !HTML::Mason::Commands::__ANON__()
called at /usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm
line 1335, referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: !eval {...} called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1335,
referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!HTML::Mason::Request::content('HTML::Mason::Request::CGI=HASH(0xb079b8c)')
called at /opt/rt3/share/html/Widgets/TitleBox line 51, referer:
http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!HTML::Mason::Commands::__ANON__('title', 'Metadati del ticket') called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Component.pm line 135,
referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xafe99c0)',
'title', 'Metadati del ticket') called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1262,
referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xad562ec)',
'SELECT DISTINCT main.* FROM Users main JOIN Principals Princi...') called
at /usr/local/perl-5.8.5/lib/site_perl/5.8.5/DBIx/SearchBuilder.pm line 238,
referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!DBIx::SearchBuilder::_DoSearch('RT::Users=HASH(0xb0c4474)') called at
/opt/rt3/lib/RT/Users_Overlay.pm line 137, referer:
http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!RT::Users::_DoSearch('RT::Users=HASH(0xb0c4474)') called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/DBIx/SearchBuilder.pm line 498,
referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!DBIx::SearchBuilder::Next('RT::Users=HASH(0xb0c4474)') called at
/opt/rt3/share/html/Ticket/Elements/ShowGroupMembers line 51, referer:
http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!HTML::Mason::Commands::__ANON__('Group', 'RT::Group=HASH(0xb0c02e8)',
'Ticket', 'RT::Ticket=HASH(0x9d5bcc0)') called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Component.pm line 135,
referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xb0dcb4c)',
'Group', 'RT::Group=HASH(0xb0c02e8)', 'Ticket',
'RT::Ticket=HASH(0x9d5bcc0)') called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1262,
referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: !eval {...} called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1252,
referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!HTML::Mason::Request::comp('undef', 'undef', 'Group',
'RT::Group=HASH(0xb0c02e8)', 'Ticket', 'RT::Ticket=HASH(0x9d5bcc0)') called
at /opt/rt3/share/html/Ticket/Elements/ShowPeople line 55, referer:
http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!HTML::Mason::Commands::__ANON__('Ticket', 'RT::Ticket=HASH(0x9d5bcc0)')
called at /usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Component.pm
line 135, referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xb0cef1c)',
'Ticket', 'RT::Ticket=HASH(0x9d5bcc0)') called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1262,
referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: !eval {...} called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1252,
referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!HTML::Mason::Request::comp('undef', 'undef', 'Ticket',
'RT::Ticket=HASH(0x9d5bcc0)') called at
/opt/rt3/share/html/Ticket/Elements/ShowSummary line 67, referer:
http://monit.regione.toscana.it/index.html
M.
>
>
>
> On Wed, Oct 03, 2007 at 01:22:47PM +0200, Marco Avvisano wrote:
>> I have installed Rt 3.6.5 ( Red Hat Enterprise Linux ES release 3),
>> and i see a lot of error in my http errors log:
>>
>> FastCGI: server "/opt/rt3/bin/mason_handler.fcgi" stderr:
>>
>
> Did you miss the actual error?
>
>> I used these http configuration:
>>
>> ### NameVirtualHost *:80
>> ### <VirtualHost *:80>
>> ### ServerAdmin root
>> ### ServerName your.host.name
>> ### DocumentRoot /opt/rt3/share/html/
>> ### AddDefaultCharset UTF-8
>> ### # Adding the following for RT (the ticket tracker)
>> ### AddHandler fastcgi-script .fcgi
>> ### <Directory "/opt/rt3/share/html">
>> ### Options FollowSymLinks ExecCGI
>> ### AllowOverride None
>> ### </Directory>
>> ### # Pass through requests to for noauth
>> ### Alias /NoAuth/images /opt/rt3/share/html/NoAuth/images
>> ### ScriptAlias / /opt/rt3/bin/mason_handler.fcgi/
>> ### </VirtualHost>
>> ### FastCgiIpcDir /tmp
>> ### FastCgiServer /opt/rt3/bin/mason_handler.fcgi -idle-timeout
>> 120 -processes 4
>>
>> Any ideas?
>>
>> I also have problems, from the web, to see group/users created, and
>> change
>> the person to assign
>> ticket (from root login, only nobody user)
>>
>> thanks for suggestions
>>
>> Marco
>>
>> _______________________________________________
>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>
>> Community help: http://wiki.bestpractical.com
>> Commercial support: sales at bestpractical.com
>>
>>
>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>> Buy a copy at http://rtbook.bestpractical.com
>>
>
> --
More information about the rt-users
mailing list