?
avatar jsubri
jsubri
3 Apr 2017

Steps to reproduce the issue

staging or 3.7b4
http://localhost/staging-3.7/index.php/search?searchword=fruit&ordering=newest&searchphrase=all

Expected result

search to return results without error

Actual result

Unknown column 'fv.context' in 'where clause'

System information (as much as possible)

context is from the #__fields table and not from #__fields_values
https://github.com/joomla/joomla-cms/blob/staging/plugins/search/content/content.php

Additional comments

avatar jsubri jsubri - open - 3 Apr 2017
avatar joomla-cms-bot joomla-cms-bot - change - 3 Apr 2017
Labels Added: ?
avatar joomla-cms-bot joomla-cms-bot - labeled - 3 Apr 2017
avatar jsubri jsubri - edited - 3 Apr 2017
avatar joomla-cms-bot joomla-cms-bot - change - 3 Apr 2017
Title
[3.7] com_search: Unknown column 'fv.context' in 'where clause'
[3.7b4] com_search: Unknown column 'fv.context' in 'where clause'
avatar joomla-cms-bot joomla-cms-bot - edited - 3 Apr 2017
avatar franz-wohlkoenig franz-wohlkoenig - change - 4 Apr 2017
Category com_search Search SQL
avatar franz-wohlkoenig franz-wohlkoenig - change - 4 Apr 2017
Title
[3.7b4] com_search: Unknown column 'fv.context' in 'where clause'
[3.7] com_search: Unknown column 'fv.context' in 'where clause'
avatar joomla-cms-bot joomla-cms-bot - change - 4 Apr 2017
The description was changed
avatar joomla-cms-bot joomla-cms-bot - edited - 4 Apr 2017
avatar joomla-cms-bot joomla-cms-bot - change - 4 Apr 2017
The description was changed
avatar joomla-cms-bot joomla-cms-bot - edited - 4 Apr 2017
avatar franz-wohlkoenig franz-wohlkoenig - change - 4 Apr 2017
Title
[3.7b4] com_search: Unknown column 'fv.context' in 'where clause'
[3.7] com_search: Unknown column 'fv.context' in 'where clause'
avatar Bakual Bakual - change - 4 Apr 2017
The description was changed
Status New Closed
Closed_Date 0000-00-00 00:00:00 2017-04-04 07:07:38
Closed_By Bakual
avatar Bakual Bakual - close - 4 Apr 2017
avatar Bakual
Bakual - comment - 4 Apr 2017

Please test #15086

I'm closing this issue since we have a PR.

Add a Comment

Login with GitHub to post a comment