?
avatar csthomas
csthomas
1 Feb 2017

Steps to reproduce the issue

After applied PR #12313 there appears new errors.

Click on index and wait until indexing complete.

  1. Then try to search some word in search field.
  • ERROR: operator does not exist: timestamp without time zone ~ unknown LINE 4: ...e%' OR "l"."url" LIKE '%lime%' OR "l"."indexdate" LIKE '%li... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts
  1. Click on Content Maps on the left panel. administrator/index.php?option=com_finder&view=maps
  • ERROR: column "s.count_published" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT a.,s.count_published,s.count_unpublished,COUNT(b.id)... ^ ERROR: column "s.count_published" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT a.,s.count_published,s.count_unpublished,COUNT(b.id)... ^ ERROR: column "s.count_published" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT a.*,s.count_published,s.count_unpublished,COUNT(b.id)... ^

Expected result

No errors.

Actual result

As above.

System information (as much as possible)

PHP 7.0.13-0ubuntu0.16.04.1
PostgreSQL 9.5.5

avatar csthomas csthomas - open - 1 Feb 2017
avatar joomla-cms-bot joomla-cms-bot - change - 1 Feb 2017
Labels Added: ?
avatar joomla-cms-bot joomla-cms-bot - labeled - 1 Feb 2017
avatar csthomas
csthomas - comment - 2 Feb 2017

I'm working on 2 point.

avatar alikon
alikon - comment - 2 Feb 2017

for let com_finder work on postgresql we need to fis some more issues i'm afraid
#12348 , #12417

avatar alikon
alikon - comment - 2 Feb 2017

@csthomas #12348 should solve point 1.

avatar csthomas
csthomas - comment - 6 Feb 2017

I have a ready PR #13854 to test.

avatar jeckodevelopment jeckodevelopment - change - 6 Feb 2017
Status New Closed
Closed_Date 0000-00-00 00:00:00 2017-02-06 19:20:35
Closed_By jeckodevelopment
avatar jeckodevelopment jeckodevelopment - close - 6 Feb 2017

Add a Comment

Login with GitHub to post a comment