[rt-users] errors on 3.6.5
Jesse Vincent
jesse at bestpractical.com
Fri Oct 5 15:51:20 EDT 2007
That looks like you somehow might not have initialized the database
correctly.
On Oct 5, 2007, at 4:17 AM, Marco Avvisano wrote:
>
> 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
>>>
>>
>> --
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 186 bytes
Desc: This is a digitally signed message part
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20071005/40c6c470/attachment.sig>
More information about the rt-users
mailing list