[rt-users] RTx-Tags 0.25 on RT 4.0.5

Mon Mar 5 06:03:56 EST 2012

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. Anyone have it working on 4.x?

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)