Hi Pat,
I'm trying to see the generated SQL, but development.log isn't showing
the query Thinking Sphinx is sending to Sphinx.
Here's a sample from the log:
Parameters: {"status"=>"", "search"=>"", "commit"=>"Search",
"action"=>"find_a_partner", "controller"=>"imap", "region_id"=>"",
"program_components"=>["early_childhood_development_required",
"afterschool_literacy_program_required"], "state"=>""}
Sphinx:
Sphinx Result:
[462, 463]
Plan Load (1.0ms) SELECT * FROM `plans` WHERE (`plans`.`id` IN
(462,463))
Should the query be listed after "Sphinx:"? Have I mis-configured
something?
For the record: config.gem 'freelancing-god-thinking-sphinx', :lib =>
'thinking_sphinx', :version => '1.1.24'
Is there another way to see the generated SQL?
Thanks,
/g
--
George Anderson
BenevolentCode LLC
[email protected]
On May 25, 1:16 pm, Pat Allan <[email protected]> wrote:
> If you look at development.log (or whichever is appropriate for your
> environment), it will show you the query Thinking Sphinx sends to
> Sphinx. It doesn't output filters though.
>
> --
> Pat
>
> On 25/05/2009, at 6:59 AM, joren wrote:
>
>
>
>
>
> > is there a way to see the real sqlqueriesgeneratedfrom sphinx? so I
> > can try to solve my problem via there?
>
> > On May 25, 2:30 pm, joren <[email protected]> wrote:
> >> Hi,
>
> >> Is there any reason why I only can search for the first 3 characters
> >> of an id?
>
> >> I have a record with id 123456, when I search for ‘123’ I get a
> >> result, but when I search for ‘1234’ or the complete id, My result is
> >> empty, without any error output in any logs.
>
> >> Is this a setting or an option I can adjust in my config?
> >> thanks
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
