?
avatar ralain
ralain
19 Dec 2016

Steps to reproduce the issue

In Joomla running on PostgreSQL, search for a word that you know is present in an article, using the old search (not smart search.)

Expected result

At least one article hit in search results and no error.

Actual result

Zero article hits in search results.
Error message: An error has occurred.

System information (as much as possible)

Latest Staging.
PHP 7.1
PostgreSQL 9.6.1

Additional comments

The issue appears to arise because the GROUP_CONCAT() function is not available in PostgreSQL.

screen shot 2016-12-19 at 14 58 42

avatar ralain ralain - open - 19 Dec 2016
avatar joomla-cms-bot joomla-cms-bot - change - 19 Dec 2016
Labels Added: ?
avatar joomla-cms-bot joomla-cms-bot - labeled - 19 Dec 2016
avatar ralain ralain - change - 20 Dec 2016
Status New Closed
Closed_Date 0000-00-00 00:00:00 2016-12-20 06:48:49
Closed_By ralain
avatar ralain ralain - close - 20 Dec 2016
avatar ralain
ralain - comment - 20 Dec 2016

Closing as we have a PR: #13291

avatar ralain ralain - close - 20 Dec 2016
avatar alikon
alikon - comment - 20 Dec 2016

@ralain please reopen cause #13291 is not enough it fix the GROUP_CONCAT() issue,
but, there is another issue to solve with search plugin we are joining on different field type....

avatar ralain
ralain - comment - 20 Dec 2016

Yep, I noticed that and was just about to post a new issue.

avatar ralain
ralain - comment - 20 Dec 2016

Add a Comment

Login with GitHub to post a comment