search

MrDys / blacklight

Blacklight Plugin
http://projectblacklight.org/
Other
1 stars 1 forks source link

BlacklightController broken on Postgres #467

Open MrDys opened 12 years ago

MrDys commented 12 years ago

CODEBASE-282: I'm working on getting Blacklight deployed to Heroku, which uses Postgres as it's database backend. When logged in and trying to get to the list of bookmarks, I get a 500 error (logs at https://gist.github.com/771043#file_gistfile1.txt ).

The bug seems to come from the strictness of Postgres in complying with the SQL standard (see http://archives.postgresql.org/pgsql-general/2004-02/msg01199.php for more info). jrochkind speculated that this was being caused by a bug in acts_as_taggable. Some basic research I did on this issue seems to suggest that it's more likely an issue in the Blacklight code that ties in with will_paginate - see http://sod.lighthouseapp.com/projects/17958/tickets/205-problem-with-distinct-table_name

This is a hacky workaround that I've come up in the meantime: https://gist.github.com/802055 - it removes the order/group by clauses. This workaround is not an ideal fix.

MrDys commented 12 years ago

Original reporter: anarchivist

MrDys commented 12 years ago

jrochkind: bullk change, pushing past 3.1 in preperation for 3.0.