0002995: Searching within quizzes errors - Composr CMS feature tracker

ID	Project	Category	View Status	Date Submitted	Last Update

0002995	Composr	search	public	2016-12-21 05:04	2016-12-21 05:04

Reporter	Patrick Schmalstig	Assigned To
Severity	Major-bug
Status	resolved	Resolution	fixed
Product Version
Fixed in Version

Summary	0002995: Searching within quizzes errors
Description	Unfortunately a query has failed [SELECT r.,r.q_start_text__source_user,r.q_start_text__text_parsed,r.q_name__source_user,r.q_name__text_parsed FROM 43SO_quizzes r WHERE ((MATCH (r.q_start_text,r.q_name) AGAINST ('nsfw')))/ aa071461770b2 */ LIMIT 10] [Unknown column 'r.q_name__source_user' in 'field list'] (version: 10 RC27, PHP version: 7.0.14, URL: /search/results.htm?all_defaults=0&content=nsfw&author=&days=-1&sort=relevance&direction=DESC&search_calendar=1&search_catalogue_categories=1&search_catalogue_entries=1&search_cns_clubs=1&search_download_categories=1&search_downloads=1&search_filedump=1&search_galleries=1&search_images=1&search_cns_members=1&search_news=1&search_comcode_pages=1&search_polls=1&search_cns_posts=1&search_cns_own_pt=1&search_quiz=1&search_videos=1&search_wiki_pages=1&keep_gallery_root=root)
Steps To Reproduce	Searched in all locations for 'nsfw' with no cutoff date and sorted by relevance descending.
Tags	No tags attached.

Time estimation (hours)
Sponsorship open

admin 2016-12-21 12:46 administrator ~0004650	Automated response: Quiz search fails Quiz search fails on sites without multi-lang-content.

admin 2016-12-21 12:46 administrator ~0004651	Fixed in git commit 36c31c3 (https://github.com/ocproducts/composr/commit/36c31c3 - link will become active once code pushed to github) A hotfix (a TAR of files to upload) have been uploaded to this issue. These files are made to the latest intra-version state (i.e. may roll in earlier fixes too if made to the same files) - so only upload files newer than what you have already. Always take backups of files you are replacing or keep a copy of the manual installer for your version, and only apply fixes you need. These hotfixes are not necessarily reliable or well supported. Not sure how to extract TAR files to your Windows computer? Try 7-zip (http://www.7-zip.org/). hotfix-2995, 2016-12-21 12pm.tar (7,680 bytes)