Pistos/diaspora — Issue #41: Search Own Posts gives error on mysql
Author: axavio
Created: 2012-01-19 06:11:30+00:00
State: open

Using the "search own posts and comments" feature introduced in diaspora-pistos-1.0.6, gives a 500 internal error on pod using mysql due to problems with ILIKE statement in app/controllers/posts_controller.rb

Details and proposed solution found at https://gist.github.com/1638290

Hint: using LOWER() around query string, posts, and comments.

I don't know if this works in pg.