Skip to content

Instantly share code, notes, and snippets.

@pauldacus
Created March 23, 2012 15:33
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pauldacus/2171836 to your computer and use it in GitHub Desktop.
Save pauldacus/2171836 to your computer and use it in GitHub Desktop.
Refinery search doesn't seem to "always" work
I am finding odd behavior in refinerycms search (2.0.2):
1) I have a page with title "tgt"
2) I search for "tgt", I get a blank search page (no pages match)
3) Checking the logs seems to indicate that refinery is at least finding my page, just not displaying it in the search results.
Re-create:
From rails dbconsole (it's page id=4):
sqlite> select * from refinery_pages;
1|||home|t|/|^/$|f|f|f|1|4|0|||2012-03-22 13:36:37.165301|2012-03-22 13:36:37.165301
2|1||page-not-found|f||^/404$|f|f|f|2|3|1|||2012-03-22 13:36:37.837686|2012-03-22 13:36:37.837686
3|||about|t|||t|f|f|5|10|0|||2012-03-22 13:36:38.534897|2012-03-22 13:42:58.970133
4|3||tgt|t|||t|f|f|6|9|1|||2012-03-23 03:04:30.160903|2012-03-23 03:04:30.160903
5|4||dfgdfg|t|||t|f|f|7|8|2|||2012-03-23 03:12:48.456508|2012-03-23 13:53:19.141344
6|||newpage|t|||t|f|f|11|12|0|||2012-03-23 13:51:40.601015|2012-03-23 13:51:40.601015
7|||xyz|t|||t|f|f|13|14|0|||2012-03-23 13:52:19.188794|2012-03-23 13:52:46.138338
From the rals log:
Started GET "/refinery/pages?search=tgt" for 127.0.0.1 at 2012-03-23 06:56:03 -0700
Processing by Refinery::Admin::PagesController#index as HTML
Parameters: {"search"=>"tgt", "locale"=>:en}
Refinery::Role Load (0.3ms) SELECT "refinery_roles".* FROM "refinery_roles" WHERE "refinery_roles"."title" = 'Refinery' LIMIT 1
Refinery::User Load (0.4ms) SELECT "refinery_users".* FROM "refinery_users" INNER JOIN "refinery_roles_users" ON "refinery_users"."id" = "refinery_roles_users"."user_id" WHERE "refinery_roles_users"."role_id" = 1
Refinery::User Load (0.3ms) SELECT "refinery_users".* FROM "refinery_users" WHERE "refinery_users"."id" = 1 LIMIT 1
Refinery::UserPlugin Load (0.4ms) SELECT "refinery_user_plugins".* FROM "refinery_user_plugins" WHERE "refinery_user_plugins"."user_id" = 1 ORDER BY position ASC
Refinery::Role Load (0.3ms) SELECT "refinery_roles".* FROM "refinery_roles" INNER JOIN "refinery_roles_users" ON "refinery_roles"."id" = "refinery_roles_users"."role_id" WHERE "refinery_roles_users"."user_id" = 1
(2.0ms) SELECT COUNT(*) FROM "refinery_pages" WHERE (refinery_pages.id IN (4))
Refinery::Page Load (0.4ms) SELECT "refinery_pages".* FROM "refinery_pages" WHERE (refinery_pages.id IN (4)) ORDER BY lft ASC
Refinery::Page::Translation Load (0.4ms) SELECT "refinery_page_translations".* FROM "refinery_page_translations" WHERE "refinery_page_translations"."refinery_page_id" IN (4)
Refinery::Page Load (0.4ms) SELECT "refinery_pages".* FROM "refinery_pages" WHERE "refinery_pages"."parent_id" IN (4) ORDER BY lft
Rendered /home/paul/.rvm/gems/ruby-1.9.2-p290/gems/refinerycms-pages-2.0.2/app/views/refinery/admin/pages/_page.html.erb (0.0ms)
Rendered /home/paul/.rvm/gems/ruby-1.9.2-p290/gems/refinerycms-core-2.0.2/app/views/refinery/admin/_sortable_list.html.erb (0.2ms)
Rendered /home/paul/.rvm/gems/ruby-1.9.2-p290/gems/refinerycms-pages-2.0.2/app/views/refinery/admin/pages/_sortable_list.html.erb (17.9ms)
Rendered /home/paul/.rvm/gems/ruby-1.9.2-p290/gems/refinerycms-pages-2.0.2/app/views/refinery/admin/pages/_records.html.erb (35.4ms)
Rendered /home/paul/.rvm/gems/ruby-1.9.2-p290/gems/refinerycms-core-2.0.2/app/views/refinery/admin/_search.html.erb (2.6ms)
Rendered /home/paul/.rvm/gems/ruby-1.9.2-p290/gems/refinerycms-pages-2.0.2/app/views/refinery/admin/pages/_actions.html.erb (9.2ms)
Rendered /home/paul/.rvm/gems/ruby-1.9.2-p290/gems/refinerycms-pages-2.0.2/app/views/refinery/admin/pages/index.html.erb within layouts/refinery/admin (49.1ms)
Rendered /home/paul/.rvm/gems/ruby-1.9.2-p290/gems/refinerycms-core-2.0.2/app/views/refinery/_html_tag.html.erb (0.2ms)
Rendered /home/paul/.rvm/gems/ruby-1.9.2-p290/gems/refinerycms-core-2.0.2/app/views/refinery/admin/_javascripts.html.erb (4.4ms)
Rendered /home/paul/.rvm/gems/ruby-1.9.2-p290/gems/refinerycms-core-2.0.2/app/views/refinery/admin/_head.html.erb (9.8ms)
Rendered /home/paul/.rvm/gems/ruby-1.9.2-p290/gems/refinerycms-core-2.0.2/app/views/refinery/_site_bar.html.erb (1.9ms)
Rendered /home/paul/.rvm/gems/ruby-1.9.2-p290/gems/refinerycms-core-2.0.2/app/views/refinery/admin/_menu.html.erb (17.8ms)
Rendered /home/paul/.rvm/gems/ruby-1.9.2-p290/gems/refinerycms-core-2.0.2/app/views/refinery/_no_script.html.erb (0.6ms)
Rendered /home/paul/.rvm/gems/ruby-1.9.2-p290/gems/refinerycms-core-2.0.2/app/views/refinery/_message.html.erb (0.1ms)
Completed 200 OK in 158ms (Views: 138.0ms | ActiveRecord: 4.9ms)
I have screenshots, but rest assured the search page simply lists nothing when searching "tgt". Search for "About" *does* work, including the mentioned "tgt" page, which is a child page of "About" in the search results. There are no leading/trailing spaces in "tgt", so I am not really sure what's going on.
Any suggestions on where to post screenshots?
@pauldacus
Copy link
Author

Here are the render stmts from the rails log (maybe the prob is there, since it finds the page (seems to), just doesn't render)

Refinery::Page Load (0.5ms) SELECT "refinery_pages".* FROM "refinery_pages" WHERE "refinery_pages"."parent_id" IN (4) ORDER BY lft
Rendered /home/paul/.rvm/gems/ruby-1.9.2-p290/gems/refinerycms-pages-2.0.2/app/views/refinery/admin/pages/_page.html.erb (0.0ms)
Rendered /home/paul/.rvm/gems/ruby-1.9.2-p290/gems/refinerycms-core-2.0.2/app/views/refinery/admin/_sortable_list.html.erb (0.2ms)
Rendered /home/paul/.rvm/gems/ruby-1.9.2-p290/gems/refinerycms-pages-2.0.2/app/views/refinery/admin/pages/_sortable_list.html.erb (28.9ms)
Rendered /home/paul/.rvm/gems/ruby-1.9.2-p290/gems/refinerycms-pages-2.0.2/app/views/refinery/admin/pages/_records.html.erb (34.9ms)
Rendered /home/paul/.rvm/gems/ruby-1.9.2-p290/gems/refinerycms-core-2.0.2/app/views/refinery/admin/_search.html.erb (0.6ms)
Rendered /home/paul/.rvm/gems/ruby-1.9.2-p290/gems/refinerycms-pages-2.0.2/app/views/refinery/admin/pages/_actions.html.erb (10.2ms)
Rendered /home/paul/.rvm/gems/ruby-1.9.2-p290/gems/refinerycms-pages-2.0.2/app/views/refinery/admin/pages/index.html.erb within layouts/refinery/admin (53.1ms)
Rendered /home/paul/.rvm/gems/ruby-1.9.2-p290/gems/refinerycms-core-2.0.2/app/views/refinery/_html_tag.html.erb (0.2ms)
Rendered /home/paul/.rvm/gems/ruby-1.9.2-p290/gems/refinerycms-core-2.0.2/app/views/refinery/admin/_javascripts.html.erb (5.0ms)
Rendered /home/paul/.rvm/gems/ruby-1.9.2-p290/gems/refinerycms-core-2.0.2/app/views/refinery/admin/_head.html.erb (13.1ms)
Rendered /home/paul/.rvm/gems/ruby-1.9.2-p290/gems/refinerycms-core-2.0.2/app/views/refinery/_site_bar.html.erb (2.6ms)
Rendered /home/paul/.rvm/gems/ruby-1.9.2-p290/gems/refinerycms-core-2.0.2/app/views/refinery/admin/_menu.html.erb (4.8ms)
Rendered /home/paul/.rvm/gems/ruby-1.9.2-p290/gems/refinerycms-core-2.0.2/app/views/refinery/_no_script.html.erb (0.6ms)
Rendered /home/paul/.rvm/gems/ruby-1.9.2-p290/gems/refinerycms-core-2.0.2/app/views/refinery/_message.html.erb (0.1ms)
Completed 200 OK in 149ms (Views: 130.2ms | ActiveRecord: 5.2ms)
cache: [GET /assets/refinery/refinery.css] stale, valid, store
cache: [GET /assets/refinery/refinery.css] stale, valid, store
...
A whole bunch of caching stmts re assets after this...

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment