2995: Searching within quizzes errors - Composr CMS feature tracker

ID	Project	Category	View Status	Date Submitted	Last Update

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

Reporter	PDStig	Assigned To
Priority	normal	Severity	major
Status	new	Resolution	fixed

Summary	2995: 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.
Attach Tags	(Separate by ",")
Attached Files

Time estimation (hours)
Sponsorship open

Date Added	Member	Amount Sponsored

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

admin 2016-12-21 12:46 administrator ~4651	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)

View Status	Private (for security issues or disclosing of private information; if you submit as a guest, you will not be able to see your submission)
Note
Upload Files Maximum size: 32,768 KiB	Attach files by dragging & dropping, selecting or pasting them.
You are not logged in	You are not logged in. This means you will not get any e-mail notifications. And if you reply, we will not know for sure you are the original poster of the issue.

Date Modified	Username	Field	Change
2016-12-21 05:04	PDStig	New Issue