Re: [rt-users] [Fwd: Message error /Upgrade from 3.6.1 to 3.8.8]
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 mailto:luciano%20silva%20%3cluci...@cpd.ufrgs.br%3e *Reply-to*: luci...@cpd.ufrgs.br *To*: RT Users rt-users@lists.bestpractical.com mailto:rt%20users%20%3crt-us...@lists.bestpractical.com%3e *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
Re: [rt-users] [Fwd: Message error /Upgrade from 3.6.1 to 3.8.8]
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
Re: [rt-users] [Fwd: Message error /Upgrade from 3.6.1 to 3.8.8]
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.comgerard%20fenelon%20%3cger...@eve-team.com%3e
*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.brluciano%20silva%20%3cluci...@cpd.ufrgs.br%3e
*Reply-to*: luci...@cpd.ufrgs.br
*To*: RT Users
rt-users@lists.bestpractical.comrt%20users%20%3crt-us...@lists.bestpractical.com%3e
*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.
Re: [rt-users] [Fwd: Message error /Upgrade from 3.6.1 to 3.8.8]
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
Re: [rt-users] [Fwd: Message error /Upgrade from 3.6.1 to 3.8.8]
On Wed, Mar 16, 2011 at 11:05:38AM -0300, Luciano Silva wrote: 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. Have you redefined @ActiveStatus in your config? You should have a clean /opt/rt3/etc/RT_Config.pm as installed by 3.8.8 and have local modifications in /opt/rt3/etc/RT_SiteConfig.pm If you copied anything form 3.6.1 you may have invalid settings there. -kevin pgptUC9mfzcp6.pgp Description: PGP signature
Re: [rt-users] [Fwd: Message error /Upgrade from 3.6.1 to 3.8.8]
I redefined @Activestatus in RT_SiteConfig.pm for: Set(@ActiveStatus, qw(new open stalled)); Set(@InactiveStatus, qw(resolved rejected deleted)); And that's OK.!! Thanks to Kevin, Ruslan and Gerard for your help. -- Luciano -Original Message- From: Kevin Falcone falc...@bestpractical.com Reply-to: rt-users@lists.bestpractical.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 12:23:10 -0400 On Wed, Mar 16, 2011 at 11:05:38AM -0300, Luciano Silva wrote: 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. Have you redefined @ActiveStatus in your config? You should have a clean /opt/rt3/etc/RT_Config.pm as installed by 3.8.8 and have local modifications in /opt/rt3/etc/RT_SiteConfig.pm If you copied anything form 3.6.1 you may have invalid settings there. -kevin
