search

ubpb / semapp2

Seminarapparate @ University Library Paderborn, Germany
http://semapp.ub.uni-paderborn.de
MIT License
0 stars 0 forks source link

Filter nach Buchaufträgen + Titel oder Dozent für zu Fehler #31

Closed renspr closed 10 years ago

renspr commented 10 years ago

Eine Suche im Admin Bereich nach Buchaufträgen in Kombination mit einem Titel oder einem Dozenten führt zu einem SQL Fehler

PG::UndefinedTable: ERROR:  missing FROM-clause entry for table "books"
LINE 1: ...imple', ''' ' || 'Lück' || ' ''' || ':*')))) AND (books.stat...
                                                             ^
: SELECT  "sem_apps".*, ((ts_rank((to_tsvector('simple', coalesce("sem_apps"."tutors"::text, ''))), (to_tsquery('simple', ''' ' || 'Lück' || ' ''' || ':*')), 0))) AS pg_search_rank FROM "sem_apps" INNER JOIN "semesters" ON "semesters"."id" = "sem_apps"."semester_id" WHERE (((to_tsvector('simple', coalesce("sem_apps"."tutors"::text, ''))) @@ (to_tsquery('simple', ''' ' || 'Lück' || ' ''' || ':*')))) AND (books.state = 'ordered' OR books.state = 'rejected')  ORDER BY sem_apps.created_at desc LIMIT 10 OFFSET 0