? Success

User tests: Successful: Unsuccessful:

avatar Humorlos
Humorlos
18 May 2015

Change to bring search plugin back to work in Postgres SQL as the last to terms are missing in the group by clause.

PostgreSQL. 9.0

avatar Humorlos Humorlos - open - 18 May 2015
avatar Bakual Bakual - change - 18 May 2015
Title
Update content.php
Fixing content search plugin in PostgreSQL
avatar Bakual
Bakual - comment - 18 May 2015

Renamed your PR so it better suites what you did.

Testing

Test the content search plugin (regular search). We need at least one test on PostgreSQL and on MySQLi (to make sure nothing broke).

avatar zero-24 zero-24 - change - 18 May 2015
Labels Added: ?
avatar zero-24 zero-24 - change - 18 May 2015
Title
Update content.php
Fixing content search plugin in PostgreSQL
Labels Added: ?
avatar zero-24 zero-24 - change - 18 May 2015
Category Postgresql SQL
avatar zero-24 zero-24 - change - 18 May 2015
Status New Pending
Easy No Yes
avatar alikon
alikon - comment - 23 May 2015

on postgresql 9.3.5 works as expected without this PR

avatar dgt41 dgt41 - test_item - 30 May 2015 - Tested successfully
avatar dgt41
dgt41 - comment - 30 May 2015

@test ok MySql here


This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/6972.

avatar alikon
alikon - comment - 30 May 2015

@test and works with this pr too on postgresql 9.3.5

avatar brianteeman
brianteeman - comment - 5 Jun 2015

I am confused. I tested content search on postgres 9.3.5.0 and like @alikon I had no issue so what is the problem that this PR is fixing


This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/6972.

avatar Humorlos
Humorlos - comment - 6 Jun 2015

Hello,

the difference is that with Postgresql 9.1 there was a change in regard to the group by of select Statements.

See https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.1 - at the end of the page under "SQL and PL/PgSQL features" there is an example with the changes to the need of group by columns or not.

Similar to that query change there are quite a few in the whole core, who suffer the same problem. I found some of them in the other search plugins and so on.

One way would be to adapt all the SQL queryies, or the raise the overall Joomla requierment from PostgreSQL 8.3.18+ (http://www.joomla.org/about-joomla/technical-requirements.html) up to 9.1.

avatar alikon
alikon - comment - 7 Jun 2015

i've suspected something like this, and i'm agree to raise the DB joomla requirements, something similar arise with old mssql too, but i'm afraid that for B/C reason this can be done only for the 4.x,
some feedback from PLT on this?

avatar brianteeman
brianteeman - comment - 26 Jun 2015

Setting to needs review


This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/6972.

avatar brianteeman brianteeman - change - 26 Jun 2015
Status Pending Needs Review
avatar roland-d roland-d - change - 7 May 2016
Status Needs Review Known Issue
Closed_Date 0000-00-00 00:00:00 2016-05-07 09:52:44
Closed_By roland-d
avatar roland-d roland-d - close - 7 May 2016
avatar roland-d roland-d - close - 7 May 2016
avatar roland-d
roland-d - comment - 7 May 2016

@Humorlos This is a known issue which cannot be resolved in this version of Joomla. As it is specifically related to using a very old release of the database software on your server the only remedy is to update that to the latest release. Thank you for your report.


This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/6972.

Add a Comment

Login with GitHub to post a comment