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

[Kevin Falcone]

On Mon, Mar 05, 2012 at 11:03:56AM -0000, Alex Young wrote:
> 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

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.

Unfortunately, we don't maintain the extension, so you might want to
file a bug report for the author.

-kevin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120305/7e4ec889/attachment.sig>