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)