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
[rt-users] [Fwd: Message error /Upgrade from 3.6.1 to 3.8.8]
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