That's what I get...
mysql> SELECT * FROM image_core WHERE MATCH('sphinx
@sphinx_internal_class_name (Image)');
+------+--------+--------------------+----------------+--------------+--------------+--------+------------+-------------+-----------+---------+--------------+------------+------------+-----------------------+
| id | weight | sphinx_internal_id | sphinx_deleted | aspect_ratio |
chromaticity | origin | image_type | licencetype | client_id | user_id |
image_status | created_at | updated_at | sphinx_internal_class |
+------+--------+--------------------+----------------+--------------+--------------+--------+------------+-------------+-----------+---------+--------------+------------+------------+-----------------------+
| 3390 | 2482 | 1695 | 0 | 2410462618 |
3828862733 | 3 | 151 | 0 | 24 | 114367 |
1 | 1354014113 | 1358164002 | Image |
| 3392 | 2440 | 1696 | 0 | 67325096 |
3828862733 | 3 | 146 | 0 | 24 | 114367 |
1 | 1354014121 | 1358164220 | Image |
| 3394 | 2440 | 1697 | 0 | 67325096 |
3828862733 | 3 | 140 | 0 | 24 | 114367 |
1 | 1354014126 | 1358164297 | Image |
+------+--------+--------------------+----------------+--------------+--------------+--------+------------+-------------+-----------+---------+--------------+------------+------------+-----------------------+
3 rows in set (0.01 sec)
Am Mittwoch, 16. Januar 2013 00:00:44 UTC+1 schrieb Pat Allan:
>
> Can you try the following query directly with Sphinx:
>
> SELECT * FROM image_core WHERE MATCH('sphinx @sphinx_internal_class_name
> (Image)');
>
> That's closer to what Thinking Sphinx will be sending through.
>
> On 16/01/2013, at 1:02 AM, [email protected] <javascript:> wrote:
>
> > OK. Now we are nearly there... the index generation worked without
> errors.
> >
> > But searching is still not working...
> >
> > In a Rails console I did:
> > pry(main)> Image.search "sphinx"
> > []
> > pry(main)> ThinkingSphinx.search 'sphinx'
> > []
> >
> > But when I connect with mysql directly to Sphinx I get three results:
> > mysql> select * from image_core where match('sphinx');
> >
> +------+--------+--------------------+----------------+--------------+--------------+--------+------------+-------------+-----------+---------+------------+------------+-----------------------+
> > | id | weight | sphinx_internal_id | sphinx_deleted | aspect_ratio |
> chromaticity | origin | image_type | licencetype | client_id | user_id |
> created_at | updated_at | sphinx_internal_class |
> >
> +------+--------+--------------------+----------------+--------------+--------------+--------+------------+-------------+-----------+---------+------------+------------+-----------------------+
> > | 3390 | 1692 | 1695 | 0 | 2410462618 |
> 3828862733 | 3 | 151 | 0 | 24 | 114367 |
> 1354014113 | 1358164002 | Image |
> > | 3392 | 1692 | 1696 | 0 | 67325096 |
> 3828862733 | 3 | 146 | 0 | 24 | 114367 |
> 1354014121 | 1358164220 | Image |
> > | 3394 | 1692 | 1697 | 0 | 67325096 |
> 3828862733 | 3 | 140 | 0 | 24 | 114367 |
> 1354014126 | 1358164297 | Image |
> >
> +------+--------+--------------------+----------------+--------------+--------------+--------+------------+-------------+-----------+---------+------------+------------+-----------------------+
> > 3 rows in set (0.01 sec)
> >
> > I get the expected results...
> > I do not have any entries in Rails development.log concerning sphinx...
> > In development.searchd.query.log I have one entry:
> > Tue Jan 15 14:53:18.559 2013] 0.004 sec [ext2/0/ext 3 (0,20)]
> [image_core] sphinx
> >
> > What do you think?
> >
> > Govinda
> >
> >
> >
> > Am Dienstag, 15. Januar 2013 14:23:04 UTC+1 schrieb Pat Allan:
> > It's actually complaining that it can't connect to Sphinx - you need to
> run ts:start after ts:configure, and *then* ts:generate, as Thinking Sphinx
> talks to the daemon to load up the data.
> > And sorry, I wasn't clear with that comment about the logs. I meant the
> Rails logs.
> >
> > Cheers
> >
> > --
> > Pat
> >
> > On 16/01/2013, at 12:20 AM, [email protected] wrote:
> >
> > > What do you mean by logs... the rails logs, sphinx logs or mysql
> logs... ?
> > >
> > > After adjusting my index definition according to your recent replies
> ... I did a
> > >
> > > rake ts:configure
> > >
> > > which went fine
> > >
> > > and then a
> > >
> > > rake ts:generate --trace
> [8s]
> > > ** Invoke ts:generate (first_time)
> > > ** Invoke environment (first_time)
> > > ** Execute environment
> > > ** Execute ts:generate
> > > Generating index files for image_core
> > > rake aborted!
> > > Can't connect to MySQL server on '127.0.0.1' (61)
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/mysql2-0.3.11/lib/mysql2/client.rb:44:in
>
> `connect'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/mysql2-0.3.11/lib/mysql2/client.rb:44:in
>
> `initialize'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/bundler/gems/thinking-sphinx-0098973687d0/lib/thinking_sphinx/connection.rb:35:in
>
> `new'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/bundler/gems/thinking-sphinx-0098973687d0/lib/thinking_sphinx/connection.rb:35:in
>
> `initialize'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/bundler/gems/thinking-sphinx-0098973687d0/lib/thinking_sphinx/connection.rb:14:in
>
> `new'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/bundler/gems/thinking-sphinx-0098973687d0/lib/thinking_sphinx/connection.rb:14:in
>
> `new'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/bundler/gems/thinking-sphinx-0098973687d0/lib/thinking_sphinx/connection.rb:26:in
>
> `block in pool'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/innertube-1.0.2/lib/innertube.rb:120:in
>
> `call'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/innertube-1.0.2/lib/innertube.rb:120:in
>
> `block in take'
> > > <internal:prelude>:10:in `synchronize'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/innertube-1.0.2/lib/innertube.rb:116:in
>
> `take'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/bundler/gems/thinking-sphinx-0098973687d0/lib/thinking_sphinx/real_time/transcriber.rb:16:in
>
> `copy'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/bundler/gems/thinking-sphinx-0098973687d0/lib/thinking_sphinx/rake_interface.rb:21:in
>
> `block (2 levels) in generate'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/global/gems/activerecord-3.2.9/lib/active_record/relation/batches.rb:21:in
>
> `block (2 levels) in find_each'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/global/gems/activerecord-3.2.9/lib/active_record/relation/batches.rb:21:in
>
> `each'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/global/gems/activerecord-3.2.9/lib/active_record/relation/batches.rb:21:in
>
> `block in find_each'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/global/gems/activerecord-3.2.9/lib/active_record/relation/batches.rb:72:in
>
> `find_in_batches'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/global/gems/activerecord-3.2.9/lib/active_record/relation/batches.rb:20:in
>
> `find_each'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/global/gems/activerecord-3.2.9/lib/active_record/querying.rb:8:in
>
> `find_each'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/bundler/gems/thinking-sphinx-0098973687d0/lib/thinking_sphinx/rake_interface.rb:20:in
>
> `block in generate'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/bundler/gems/thinking-sphinx-0098973687d0/lib/thinking_sphinx/rake_interface.rb:13:in
>
> `each'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/bundler/gems/thinking-sphinx-0098973687d0/lib/thinking_sphinx/rake_interface.rb:13:in
>
> `generate'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/bundler/gems/thinking-sphinx-0098973687d0/lib/thinking_sphinx/tasks.rb:14:in
>
> `block (2 levels) in <top (required)>'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/rake-10.0.3/lib/rake/task.rb:228:in
>
> `call'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/rake-10.0.3/lib/rake/task.rb:228:in
>
> `block in execute'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/rake-10.0.3/lib/rake/task.rb:223:in
>
> `each'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/rake-10.0.3/lib/rake/task.rb:223:in
>
> `execute'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/rake-10.0.3/lib/rake/task.rb:166:in
>
> `block in invoke_with_call_chain'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/lib/ruby/1.9.1/monitor.rb:211:in
>
> `mon_synchronize'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/rake-10.0.3/lib/rake/task.rb:159:in
>
> `invoke_with_call_chain'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/rake-10.0.3/lib/rake/task.rb:152:in
>
> `invoke'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/rake-10.0.3/lib/rake/application.rb:143:in
>
> `invoke_task'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/rake-10.0.3/lib/rake/application.rb:101:in
>
> `block (2 levels) in top_level'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/rake-10.0.3/lib/rake/application.rb:101:in
>
> `each'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/rake-10.0.3/lib/rake/application.rb:101:in
>
> `block in top_level'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/rake-10.0.3/lib/rake/application.rb:110:in
>
> `run_with_threads'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/rake-10.0.3/lib/rake/application.rb:95:in
>
> `top_level'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/rake-10.0.3/lib/rake/application.rb:73:in
>
> `block in run'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/rake-10.0.3/lib/rake/application.rb:160:in
>
> `standard_exception_handling'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/rake-10.0.3/lib/rake/application.rb:70:in
>
> `run'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/rake-10.0.3/bin/rake:33:in
>
> `<top (required)>'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/bin/rake:23:in
>
> `load'
> > >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/bin/rake:23:in
>
> `<main>'
> > > Tasks: TOP => ts:generate
> > >
> > >
> > > This is a little weird because I can connect to the database with
> rails and also with the mysql command line just fine...
> > >
> > > Govinda
> > >
> > >
> > >
> > > Am Dienstag, 15. Januar 2013 00:40:52 UTC+1 schrieb Pat Allan:
> > > This one's a little more surprising… you should see the full SphinxQL
> command in your logs when Image.search is called - can you confirm what
> that is, and whether you see results using it directly via mysql?
> > > --
> > > Pat
> > >
> > > On 15/01/2013, at 12:15 AM, [email protected] wrote:
> > >
> > > > OK. And the next problem I have when I generate a realtime index
> with only the attributes that I got working until now is
> > > > that searching seems not work at all for me:
> > > >
> > > > [13] pry(main)> Image.search('sphinx')
> > > > []
> > > >
> > > > But when I am connecting directly to sphinx via mysql:
> > > >
> > > > mysql> select * from image_core where match('sphinx');
> > > >
> +------+--------+--------------------+----------------+--------+-----------------------+
> > > > | id | weight | sphinx_internal_id | sphinx_deleted | origin |
> sphinx_internal_class |
> > > >
> +------+--------+--------------------+----------------+--------+-----------------------+
> > > > | 3390 | 1692 | 1695 | 0 | 3 |
> Image |
> > > > | 3392 | 1692 | 1696 | 0 | 3 |
> Image |
> > > > | 3394 | 1692 | 1697 | 0 | 3 |
> Image |
> > > >
> +------+--------+--------------------+----------------+--------+-----------------------+
> > > > 3 rows in set (0.00 sec)
> > > >
> > > > I am a little lost what I might be doing wrong...
> > > >
> > > > Govinda
> > > >
> > > >
> > > >
> > > > Am Montag, 14. Januar 2013 12:15:52 UTC+1 schrieb
> [email protected]:
> > > > Hello guys,
> > > >
> > > > after the announcement here
> https://github.com/pat/thinking-sphinx/issues/186 that there is some
> support for realtime indexes I gave it shot and tried to port my existing
> (and working) thinking_sphinx v2 indexes and tried to port them to the new
> v3 syntax...
> > > >
> > > > ThinkingSphinx::Index.define :image, :with => :real_time do
> > > > # indexes assoc(:file)
> > > > indexes file_width
> > > > indexes file_height
> > > > indexes file_colorspace
> > > > indexes file_content_type, :as => :file_type
> > > > indexes file_resolution
> > > > indexes file_depth
> > > > indexes description
> > > > indexes category
> > > > indexes tags
> > > > indexes campaigns
> > > > indexes image_type.name, :as => :image_type_name
> > > > # has "CRC32(file_chromaticity)", :as => :chromaticity, :type =>
> :integer
> > > > # has "CRC32(file_aspect_ratio)", :as => :aspect_ratio, :type =>
> :integer
> > > > has image_origin_id, :as => :origin
> > > > # has image_licencetype_id, :as => :licencetype
> > > > # has image_type_id, :as => :image_type
> > > > # has client_id
> > > > # has user_id
> > > > # has created_at
> > > > # has updated_at
> > > > # has status
> > > > end
> > > >
> > > > When I do a "rake ts:generate" I get the following error:
> > > >
> > > > rake aborted!
> > > > Unknown attribute type ''
> > > >
> > > > Does anybody know how I have to change my indexes to get them to
> play nicely with sphinx3?
> > > > I am using the edge branch with Rails 3.2.9, Ruby 1.9.3 and sphinx
> 2.0.6.
> > > >
> > > > Cheers, Govinda
> > > >
> > > > --
> > > > You received this message because you are subscribed to the Google
> Groups "Thinking Sphinx" group.
> > > > To view this discussion on the web visit
> https://groups.google.com/d/msg/thinking-sphinx/-/EK7lcZXrOMIJ.
> > > > 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.
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > --
> > > You received this message because you are subscribed to the Google
> Groups "Thinking Sphinx" group.
> > > To view this discussion on the web visit
> https://groups.google.com/d/msg/thinking-sphinx/-/7-gJ17EdG-gJ.
> > > 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.
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > --
> > You received this message because you are subscribed to the Google
> Groups "Thinking Sphinx" group.
> > To view this discussion on the web visit
> https://groups.google.com/d/msg/thinking-sphinx/-/h_lZ9cIn7J8J.
> > To post to this group, send email to
> > [email protected]<javascript:>
> .
> > To unsubscribe from this group, send email to
> [email protected] <javascript:>.
> > For more options, visit this group at
> http://groups.google.com/group/thinking-sphinx?hl=en.
>
>
>
--
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/thinking-sphinx/-/XKg2UjGKYmQJ.
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.
