[#14783] - Fix smart search indexer for mysql - part only for J4
- Fixed in Code Base
- 11 Apr 2017
- Medium
- Build: 4.0-dev
- # 14783
- Diff
- csthomas:ssearch_index
User tests: Successful: Unsuccessful:
Summary of Changes
- Fix smart search indexer for mysql, related to #14811 for J3
- Fix a few lines in front end template for smart search, take a look at code.
Testing Instructions
Go to backend - Smart Search extension.
Click on button "Index"
Test front end search form at index.php?option=com_finder&view=search
(type 'red' or 'green') - before patch there is error page, after patch joomla finds an item.
Expected result
All works, front end search form too.
Actual result
Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 't1.stem' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Documentation Changes Required
No
| Status | New | ⇒ | Pending |
joomla-cms-bot
- | Category | ⇒ | Administration com_finder |
| Labels |
Added:
?
|
||
@wilsonge why does it need rebasing this is for J4 and github reports no conflicts ?
@marcodings this is for J4 but you have tested on J3?
I have tested this item
This fixes the term_id issue but I cannot index fully still. On running index with sample data I now get the error:
Field 'map_suffix' doesn't have a default value
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/14783.
| Category | Administration com_finder | ⇒ | Administration com_finder Front End |
Please do not merge it for now. I'm working on version for J3
I have tested this item
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/14783.
| Status | Pending | ⇒ | Fixed in Code Base |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2017-04-11 19:05:52 |
| Closed_By | ⇒ | wilsonge |
I have tested this item✅ successfully on d807fdb
Tested successfully aga8nst J37b3
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/14783.