Skip Menu |
 

This queue is for tickets about the RTx-Tags CPAN distribution.

Report information
The Basics
Id: 75647
Status: open
Priority: 0/
Queue: RTx-Tags

People
Owner: Nobody in particular
Requestors: AlexYoung [...] HousingPartners.co.uk
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



Subject: RTx-Tags-0.25 on RT4.x
Date: Fri, 9 Mar 2012 13:28:06 -0000
To: <bug-RTx-Tags [...] rt.cpan.org>
From: "Alex Young" <AlexYoung [...] HousingPartners.co.uk>
Download (untitled) / with headers
text/plain 6.8k
Just starting to test out RT 4.0.5 to see what works and what doesn't from our current setup and I have come across problems with RTx-Tags 0.25. I see the following in /var/log/apache/error.log [Mon Mar 5 10:50:20 2012] [warning]: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND ObjectCustomFieldValues.ObjectType IN('RT::Ticket') GROUP BY ObjectCustom' at line 1 at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587. (/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587) [Mon Mar 5 10:50:20 2012] [warning]: RT::Handle=HASH(0x7f7f3808b230) couldn't execute the query 'SELECT COUNT(ObjectCustomFieldValues.Content), ObjectCustomFieldValues.Content FROM ObjectCustomFieldValues JOIN CustomFields ON CustomFields.Id=ObjectCustomFieldValues.CustomField JOIN Tickets ON ObjectCustomFieldValues.ObjectId=Tickets.id WHERE CustomFields.Name='Tags' AND ObjectCustomFieldValues.Disabled=0 AND Tickets.Status IN() AND ObjectCustomFieldValues.ObjectType IN('RT::Ticket') GROUP BY ObjectCustomFieldValues.Content' at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600. DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x7f7f3808b230 )', 'SELECT COUNT(ObjectCustomFieldValues.Content), ObjectCustomFi...') called at /opt/rt4/local/plugins/RTx-Tags/lib/RTx/Tags.pm line 10 RTx::Tags::cloud('tagsTypes', undef, 'tagsLinkType', 1) called at /opt/rt4/local/plugins/RTx-Tags/html/Elements/TagCloud line 19 HTML::Mason::Commands::__ANON__() called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1380 eval {...} called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1380 HTML::Mason::Request::content('RT::Interface::Web::Request=HASH(0x7f7f5d 545b68)') called at /opt/rt4/share/html/Widgets/TitleBox line 56 HTML::Mason::Commands::__ANON__('title', 'Tag Cloud', 'title_href', '/rt/Search/TagCloud.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(0x7f 7f6e222958)', 'title', 'Tag Cloud', 'title_href', '/rt/Search/TagCloud.html') called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1302 eval {...} called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1292 HTML::Mason::Request::comp(undef, undef, undef, 'title', 'Tag Cloud', 'title_href', '/rt/Search/TagCloud.html') called at /opt/rt4/local/plugins/RTx-Tags/html/Elements/TagCloud line 22 HTML::Mason::Commands::__ANON__() called at /usr/local/share/perl/5.10.1/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f 7f6e1d4b38)') called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1302 eval {...} called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1292 HTML::Mason::Request::comp(undef, undef) called at /opt/rt4/local/plugins/RTx-Tags/html/Callbacks/RTx-Tags/Search/Simple.ht ml/PreForm line 8 HTML::Mason::Commands::__ANON__() called at /usr/local/share/perl/5.10.1/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f 7f6e1f0970)') called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1297 eval {...} called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1292 HTML::Mason::Request::comp(undef, undef) called at /opt/rt4/sbin/../lib/RT/Interface/Web/Request.pm line 141 RT::Interface::Web::Request::callback('RT::Interface::Web::Request=HASH( 0x7f7f5d545b68)', 'CallbackName', 'PreForm') called at /opt/rt4/share/html/Search/Simple.html line 52 HTML::Mason::Commands::__ANON__() called at /usr/local/share/perl/5.10.1/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f 7f3814bca0)') called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1302 eval {...} called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1292 HTML::Mason::Request::comp(undef, undef, undef) called at /opt/rt4/sbin/../lib/RT/Interface/Web.pm line 548 RT::Interface::Web::ShowRequestedPage('HASH(0x7f7f6ddbf380)') called at /opt/rt4/sbin/../lib/RT/Interface/Web.pm line 295 RT::Interface::Web::HandleRequest('HASH(0x7f7f6ddbf380)') called at /opt/rt4/share/html/autohandler line 53 HTML::Mason::Commands::__ANON__() called at /usr/local/share/perl/5.10.1/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f 7f380d2790)') called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1297 eval {...} called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1292 HTML::Mason::Request::comp(undef, undef, undef) called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 481 eval {...} called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 481 eval {...} called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 433 HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x7f7f5d545 b68)') called at /usr/local/share/perl/5.10.1/HTML/Mason/PSGIHandler.pm line 85 eval {...} called at /usr/local/share/perl/5.10.1/HTML/Mason/PSGIHandler.pm line 85 HTML::Mason::Request::PSGI::exec('RT::Interface::Web::Request=HASH(0x7f7 f5d545b68)') called at /usr/local/share/perl/5.10.1/HTML/Mason/Interp.pm line 342 HTML::Mason::Interp::exec(undef, undef) called at /usr/local/share/perl/5.10.1/HTML/Mason/PSGIHandler.pm line 48 eval {...} called at /usr/local/share/perl/5.10.1/HTML/Mason/PSGIHandler.pm line 48 HTML::Mason::PSGIHandler::invoke_mason('HTML::Mason::PSGIHandler::Stream y=HASH(0x7f7f5b97ca78)', 'HTML::Mason::FakeApache=HASH(0x7f7f6db261b0)', 'HASH(0x7f7f6db26228)') called at /usr/local/share/perl/5.10.1/HTML/Mason/PSGIHandler/Streamy.pm line 52 HTML::Mason::PSGIHandler::Streamy::__ANON__('CODE(0x7f7f6ddd5e30)') called at /opt/rt4/sbin/../lib/RT/Interface/Web/Handler.pm line 255 RT::Interface::Web::Handler::__ANON__('CODE(0x7f7f6ddd5e30)') called at /usr/local/share/perl/5.10.1/Plack/Util.pm line 324 Plack::Util::__ANON__('CODE(0x7f7f6dde1138)') called at /usr/local/share/perl/5.10.1/Plack/Handler/Apache2.pm line 68 Plack::Handler::Apache2::call_app('Plack::Handler::Apache2', 'Apache2::RequestRec=SCALAR(0x7f7f5d546198)', 'CODE(0x7f7f5b97c850)') called at /usr/local/share/perl/5.10.1/Plack/Handler/Apache2.pm line 91 Plack::Handler::Apache2::handler('Apache2::RequestRec=SCALAR(0x7f7f5d546 198)') called at -e line 0 eval {...} called at -e line 0 (/usr/local/share/perl/5.10.1/Carp.pm:103) Kevin Falcone made the following comment about it: I'm betting it's building the status list in the old 3.8 way rather than using the RT::Queue->ActiveStatusArray method which works in 3.8 and 4.0.
Subject: Re: [rt.cpan.org #75647] RTx-Tags-0.25 on RT4.x
Date: Fri, 09 Mar 2012 09:42:47 -0500
To: bug-RTx-Tags [...] rt.cpan.org
From: Jerrad Pierce <belg4mit [...] pthbb.org>
Download (untitled) / with headers
text/plain 295b
Hello, Unfortunately I no longer use RT or have access to a development installation to play with. The heart of the module is in the Googleish search overlay, and not terribly complex if you want to have a crack at it. It's probably a matter of RT4 using completely new database underpinnings.


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.