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 <[email protected]>
To: [email protected]
Cc: Gerard FENELON <[email protected]>,
[email protected]
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 <[email protected]>
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 <[email protected]>
To: [email protected]
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 <[email protected]>
> Reply-to: [email protected]
> To: RT Users <[email protected]>
> 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
