sfu-dhil / wphp

Women's Print History Project database front end.
https://womensprinthistoryproject.com/
GNU General Public License v2.0
1 stars 8 forks source link

Advanced title search limited by genre not working #263

Closed kkatemoffatt closed 3 years ago

kkatemoffatt commented 3 years ago

Describe the bug When we try to limit by genre in the advanced title search, we receive an error message.

To Reproduce Steps to reproduce the behavior:

  1. Go to "Database"
  2. Click on "Search Titles"
  3. Click on "Advanced Search"
  4. Scroll down to genre, and click "travel/tourism/topography"
  5. Click search. We receive an error message here instead of results.

Expected behavior All titles in the travel/tourism/topography genre should come up as the search results.

Screenshots Genre Bug

Additional context Here's the error message:

2021-07-30T10:15:40-07:00 23.17.72.182 GET https://womensprinthistoryproject.com/title/search?title_search%5Btitle%5D=&title_search%5Border%5D=&title_search%5Bid%5D=&title_search%5Bperson_filter%5D%5Bid%5D=&title_search%5Bperson_filter%5D%5Bname%5D=&title_search%5Bperson_filter%5D%5Bgender%5D%5B0%5D=F&title_search%5Bperson_filter%5D%5Bperson_role%5D%5B0%5D=1&title_search%5Bsigned_author%5D=&title_search%5Bpseudonym%5D=&title_search%5Bfirm_filter%5D%5Bfirm_id%5D=&title_search%5Bfirm_filter%5D%5Bfirm_name%5D=&title_search%5Bfirm_filter%5D%5Bfirm_address%5D=&title_search%5Bself_published%5D=&title_search%5Bvolumes%5D=&title_search%5Bpubdate%5D=&title_search%5Bdate_of_first_publication%5D=&title_search%5BeditionNumber%5D=&title_search%5BeditionStatement%5D=&title_search%5Bimprint%5D=&title_search%5Bcolophon%5D=&title_search%5Bcopyright%5D=&title_search%5Blocation%5D=&title_search%5BsizeL%5D=&title_search%5BsizeW%5D=&title_search%5Bprice_filter%5D%5Bprice_pound%5D=&title_search%5Bprice_filter%5D%5Bprice_shilling%5D=&title_search%5Bprice_filter%5D%5Bprice_pence%5D=&title_search%5Bprice_filter%5D%5Bprice_comparison%5D=eq&title_search%5Bgenre%5D%5B0%5D=14&title_search%5Bshelfmark%5D=&title_search%5Btitlesource_filter%5D%5Bsource%5D=&title_search%5Btitlesource_filter%5D%5Bidentifier%5D=&title_search%5Bnotes%5D=&title_search%5Bchecked%5D=&title_search%5Bfinalcheck%5D=&title_search%5Bfinalattempt%5D=&title_search%5B_token%5D=Qpvfs0JgC0RgvQ8QlaP-8sqtDwItfXaTu-b_iOdB7nc https://womensprinthistoryproject.com/title/ 500 - Doctrine\ORM\Query\QueryException [Semantical Error] line 0, col 100 near 'genre IN (:genre)': Error: Class App\Entity\Title has no field or association named genre Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36