Hello Ruslan, I followed instructions upgrading DB until 3.7.87, applied the queries.sql, upgraded from 3.7.87 to end.
The error log is attached. -- Luciano Silva -----Original Message----- From: Ruslan Zakirov <r...@bestpractical.com> To: luci...@cpd.ufrgs.br Cc: Gerard FENELON <ger...@eve-team.com>, rt-users@lists.bestpractical.com Subject: Re: [rt-users] [Fwd: Message error /Upgrade from 3.6.1 to 3.8.8] Date: Wed, 16 Mar 2011 15:55:41 +0300 Enable stack traces and show us error with trace. Have upgraded DB further after applying schema changes? On Wed, Mar 16, 2011 at 3:24 PM, Luciano Silva <luci...@cpd.ufrgs.br> wrote: Gerard, I followed all your instructions. The messagems from rt_log: 192.168.x.x - - [16/Mar/2011:09:09:07 -0300] "GET /index.html HTTP/1.1" 200 6443 192.168.x.x - - [16/Mar/2011:09:09:10 -0300] "GET /Search/Results.html?Query=Queue%20%3D%20%27CATALOGO%27% 20AND%20() HTTP/1.1" 200 3584 192.168.x.x - - [16/Mar/2011:09:09:16 -0300] "GET /Search/Results.html?Query=Queue%20%3D%20%27DRS-Restrita% 27%20AND%20() HTTP/1.1" 200 4374 192.168.x.x - - [16/Mar/2011:09:09:24 -0300] "GET /index.html HTTP/1.1" 200 6443 The problem stills the same. Luciano Silva -----Original Message----- From: Gerard FENELON <ger...@eve-team.com> To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] [Fwd: Message error /Upgrade from 3.6.1 to 3.8.8] Date: Wed, 16 Mar 2011 11:16:51 +0100 I seem to remember having had this message. From memory, it was solved either by 1) restarting apache, 2) clearing the mason cache, 3) or updating a local version of ./share/html/Search/Build.html (you will need to find the equivalent for QuickSearch) I make no warranties on the accuracy of my memory ;-) Otherwise, you might have more messages in var/log/rt.log Gerard On 2011-03-15 19:34, Luciano Silva wrote: > Please, > Do you have any idea how solve this problem? > Tks > > -- > Luciano Silva > -------- Forwarded Message -------- > From: Luciano Silva <luci...@cpd.ufrgs.br> > Reply-to: luci...@cpd.ufrgs.br > To: RT Users <rt-users@lists.bestpractical.com> > Subject: [rt-users] Message error /Upgrade from 3.6.1 to 3.8.8 > Date: Fri, 11 Feb 2011 13:23:39 -0200 > > Hello, > > I made an upgrade from 3.6.1 to 3.8.8. I'm Using a Ubuntu > Server 10.04. > Everything was ok, applied upgrades from UPGRADING, > UPGRAND.mysql and README. On interface, I got this error, > when click on Queue/Quick Search: > > "Can't use string ("AND") as a HASH ref while "strict refs" in > use > at /usr/local/rt/bin/../lib/RT/Interface/Web/QueryBuilder/Tree.pm line 114." > > I googled and searched an answer, but I didn't find anything > about this error. > Please, can you tel-me how fix this error? > Tks > -- > Luciano Silva -- Best regards, Ruslan.
[Wed Mar 16 13:49:23 2011] [error]: Wrong query, expecting a OPEN_PAREN or KEYWORD in 'Queue = 'DRS' AND (>)<--here' at /usr/local/rt/bin/../lib/RT/SQL.pm line 133, <GEN33> line 139. Stack: [/usr/local/rt/bin/../lib/RT/SQL.pm:133] [/usr/local/rt/bin/../lib/RT/Tickets_Overlay_SQL.pm:239] [/usr/local/rt/bin/../lib/RT/Tickets_Overlay_SQL.pm:295] [/usr/local/rt/share/html/Search/Results.html:127] [/usr/local/rt/bin/../lib/RT/Interface/Web.pm:448] [/usr/local/rt/bin/../lib/RT/Interface/Web.pm:243] [/usr/local/rt/share/html/autohandler:53] (/usr/local/rt/bin/../lib/RT/Tickets_Overlay_SQL.pm:297) Trace begun at /usr/local/rt/bin/../lib/RT.pm line 291 Log::Dispatch::__ANON__('Log::Dispatch=HASH(0x7fe6352bf768)', '') called at /usr/local/rt/bin/../lib/RT/Tickets_Overlay_SQL.pm line 297 RT::Tickets::FromSQL('RT::Tickets=HASH(0x7fe632d39b40)', 'Queue = \'DRS\' AND ()') called at /usr/local/rt/share/html/Search/Results.html line 127 HTML::Mason::Commands::__ANON__('Query', 'Queue = \'DRS\' AND ()') called at /usr/local/share/perl/5.10.1/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fe632d50e18)', 'Query', 'Queue = \'DRS\' AND ()') called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1302 eval {...} at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1292 HTML::Mason::Request::comp(undef, undef, undef, 'Query', 'Queue = \'DRS\' AND ()') called at /usr/local/rt/bin/../lib/RT/Interface/Web.pm line 448 RT::Interface::Web::ShowRequestedPage('HASH(0x7fe636186460)') called at /usr/local/rt/bin/../lib/RT/Interface/Web.pm line 243 RT::Interface::Web::HandleRequest('HASH(0x7fe636186460)') called at /usr/local/rt/share/html/autohandler line 53 HTML::Mason::Commands::__ANON__('Query', 'Queue = \'DRS\' AND ()') called at /usr/local/share/perl/5.10.1/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fe63608a4c0)', 'Query', 'Queue = \'DRS\' AND ()') called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1297 eval {...} at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1292 HTML::Mason::Request::comp(undef, undef, undef, 'Query', 'Queue = \'DRS\' AND ()') called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 481 eval {...} at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 481 eval {...} at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 433 HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x7fe6360905c0)') called at /usr/local/share/perl/5.10.1/HTML/Mason/ApacheHandler.pm line 168 HTML::Mason::Request::ApacheHandler::exec('RT::Interface::Web::Request=HASH(0x7fe6360905c0)') called at /usr/local/share/perl/5.10.1/HTML/Mason/ApacheHandler.pm line 825 HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x7fe635dd1278)', 'Apache2::RequestRec=SCALAR(0x7fe6360dc658)') called at /usr/local/rt/bin/webmux.pl line 99 eval {...} at /usr/local/rt/bin/webmux.pl line 99 RT::Mason::handler('Apache2::RequestRec=SCALAR(0x7fe6360dc658)') called at -e line 0 eval {...} at -e line 0 [Wed Mar 16 13:49:23 2011] [error]: Wrong query, expecting a OPEN_PAREN or KEYWORD in 'Queue = 'DRS' AND (>)<--here' at /usr/local/rt/bin/../lib/RT/SQL.pm line 133. Stack: [/usr/local/rt/bin/../lib/RT/SQL.pm:133] [/usr/local/rt/bin/../lib/RT/Tickets_Overlay_SQL.pm:239] [/usr/local/rt/bin/../lib/RT/Tickets_Overlay_SQL.pm:295] [/usr/local/rt/share/html/Elements/CollectionList:51] [/usr/local/rt/share/html/Search/Results.html:63] [/usr/local/rt/bin/../lib/RT/Interface/Web.pm:448] [/usr/local/rt/bin/../lib/RT/Interface/Web.pm:243] [/usr/local/rt/share/html/autohandler:53] (/usr/local/rt/bin/../lib/RT/Tickets_Overlay_SQL.pm:297) Trace begun at /usr/local/rt/bin/../lib/RT.pm line 291 Log::Dispatch::__ANON__('Log::Dispatch=HASH(0x7fe6352bf768)', '') called at /usr/local/rt/bin/../lib/RT/Tickets_Overlay_SQL.pm line 297 RT::Tickets::FromSQL('RT::Tickets=HASH(0x7fe632d708d8)', 'Queue = \'DRS\' AND ()') called at /usr/local/rt/share/html/Elements/CollectionList line 51 HTML::Mason::Commands::__ANON__('Query', 'Queue = \'DRS\' AND ()', 'AllowSorting', 1, 'OrderBy', 'id', 'Order', 'ASC', 'Rows', 50, 'Page', 1, 'Format', '^J \'<B><A HREF="/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#\',^J \'<B><A HREF="/Ticket/Display.html?id=__id__">__Subject__</a></B>/TITLE:Subject\',^J Status,^J QueueName, ^J OwnerName, ^J Priority, ^J \'__NEWLINE__\',^J \'\', ^J \'<small>__Requestors__</small>\',^J \'<small>__CreatedRelative__</small>\',^J \'<small>__ToldRelative__</small>\',^J \'<small>__LastUpdatedRelative__</small>\',^J \'<small>__TimeLeft__</small>\'', 'Class', 'RT::Tickets', 'BaseURL', '/Search/Results.html?') called at /usr/local/share/perl/5.10.1/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fe6361c2848)', 'Query', 'Queue = \'DRS\' AND ()', 'AllowSorting', 1, 'OrderBy', 'id', 'Order', 'ASC', 'Rows', 50, 'Page', 1, 'Format', '^J \'<B><A HREF="/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#\',^J \'<B><A HREF="/Ticket/Display.html?id=__id__">__Subject__</a></B>/TITLE:Subject\',^J Status,^J QueueName, ^J OwnerName, ^J Priority, ^J \'__NEWLINE__\',^J \'\', ^J \'<small>__Requestors__</small>\',^J \'<small>__CreatedRelative__</small>\',^J \'<small>__ToldRelative__</small>\',^J \'<small>__LastUpdatedRelative__</small>\',^J \'<small>__TimeLeft__</small>\'', 'Class', 'RT::Tickets', 'BaseURL', '/Search/Results.html?') called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1302 eval {...} at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1292 HTML::Mason::Request::comp(undef, undef, 'Query', 'Queue = \'DRS\' AND ()', 'AllowSorting', 1, 'OrderBy', 'id', 'Order', 'ASC', 'Rows', 50, 'Page', 1, 'Format', '^J \'<B><A HREF="/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#\',^J \'<B><A HREF="/Ticket/Display.html?id=__id__">__Subject__</a></B>/TITLE:Subject\',^J Status,^J QueueName, ^J OwnerName, ^J Priority, ^J \'__NEWLINE__\',^J \'\', ^J \'<small>__Requestors__</small>\',^J \'<small>__CreatedRelative__</small>\',^J \'<small>__ToldRelative__</small>\',^J \'<small>__LastUpdatedRelative__</small>\',^J \'<small>__TimeLeft__</small>\'', 'Class', 'RT::Tickets', 'BaseURL', '/Search/Results.html?') called at /usr/local/rt/share/html/Search/Results.html line 63 HTML::Mason::Commands::__ANON__('Query', 'Queue = \'DRS\' AND ()') called at /usr/local/share/perl/5.10.1/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fe632d50e18)', 'Query', 'Queue = \'DRS\' AND ()') called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1302 eval {...} at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1292 HTML::Mason::Request::comp(undef, undef, undef, 'Query', 'Queue = \'DRS\' AND ()') called at /usr/local/rt/bin/../lib/RT/Interface/Web.pm line 448 RT::Interface::Web::ShowRequestedPage('HASH(0x7fe636186460)') called at /usr/local/rt/bin/../lib/RT/Interface/Web.pm line 243 RT::Interface::Web::HandleRequest('HASH(0x7fe636186460)') called at /usr/local/rt/share/html/autohandler line 53 HTML::Mason::Commands::__ANON__('Query', 'Queue = \'DRS\' AND ()') called at /usr/local/share/perl/5.10.1/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fe63608a4c0)', 'Query', 'Queue = \'DRS\' AND ()') called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1297 eval {...} at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1292 HTML::Mason::Request::comp(undef, undef, undef, 'Query', 'Queue = \'DRS\' AND ()') called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 481 eval {...} at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 481 eval {...} at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 433 HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x7fe6360905c0)') called at /usr/local/share/perl/5.10.1/HTML/Mason/ApacheHandler.pm line 168 HTML::Mason::Request::ApacheHandler::exec('RT::Interface::Web::Request=HASH(0x7fe6360905c0)') called at /usr/local/share/perl/5.10.1/HTML/Mason/ApacheHandler.pm line 825 HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x7fe635dd1278)', 'Apache2::RequestRec=SCALAR(0x7fe6360dc658)') called at /usr/local/rt/bin/webmux.pl line 99 eval {...} at /usr/local/rt/bin/webmux.pl line 99 RT::Mason::handler('Apache2::RequestRec=SCALAR(0x7fe6360dc658)') called at -e line 0 eval {...} at -e line 0