Skip to content

Instantly share code, notes, and snippets.

@pauldacus
Created March 23, 2012 15:33
Show Gist options
  • Select an option

  • Save pauldacus/2171836 to your computer and use it in GitHub Desktop.

Select an option

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
Copy Markdown
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