Hi Ramon I've just added a HABTM join to my test suite for TS, and it works fine. Which is doubly confusing, because it sounds like you've not changed your indexing setup while upgrading TS, and I've not updated the indexing code in a good while too. But, just to be absolutely sure - there is a name column in the people table, yes? As opposed to first_name and last_name or something like that...
-- Pat On 04/08/2009, at 6:09 AM, Ramon Tayag wrote: > > Thanks James! > > Ramon Tayag > > On Tue, Aug 4, 2009 at 1:04 PM, James Healy<[email protected]> wrote: >> >> Ramon Tayag wrote: >>> Thanks for your quick reply, James! >>> >>> http://pastie.org/570699 >>> >>> Seeing the problem would probably be there, I tried looking at it.. >>> but I get dizzy trying haha. >> >> I can see the invalid SQL TS is generating. In the following >> GROUP_CONCAT() call, there should be a column name between DISTINCT >> and >> SEPARATOR. >> >> CAST(GROUP_CONCAT(DISTINCT SEPARATOR ' ') AS CHAR) AS >> `composer_names` >> >> As to why it's happening, I'm not sure. Hopefully Pat can shed some >> light on the situation. > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en -~----------~----~----~----~------~----~------~--~---
