?
avatar GarryMoveOut
GarryMoveOut
16 May 2018

Steps to reproduce the issue

Make sure that plugin Smart Search - Content is enabled.
Install official Polish Language Pack (3.8.7v2) from joomla.org
Create new article or edit existing, write something and click "Save".

Expected result

Saved article without errors.

Actual result

Oryginal error message:
"Error
Save failed with the following error: BŁĄD: kolumna "t" relacji "i5c7v_finder_terms" nie istnieje LINE 2: SET t.links = t.links - 1 ^
"
translated:
Error
Save failed with the following error: ERROR: column "t" relation"i5c7v_finder_terms" do not exist LINE 2: SET t.links = t.links - 1 ^

Original log from pgsql:
BŁĄD: kolumna "t" relacji "i5c7v_finder_terms" nie istnieje przy znaku 40
WYRAŻENIE: UPDATE "i5c7v_finder_terms" AS "t"
SET t.links = t.links - 1
FROM "i5c7v_finder_links_terms0" AS "m"
WHERE "m"."link_id" = 7 AND m.term_id = t.term_id
translated:
ERROR: column "t" relation "i5c7v_finder_terms" do not exist near sign 40
STATEMENT: UPDATE "i5c7v_finder_terms" AS "t"
SET t.links = t.links - 1
FROM "i5c7v_finder_links_terms0" AS "m"
WHERE "m"."link_id" = 7 AND m.term_id = t.term_id

System information (as much as possible)

Platform
CentOS 7 + Apache2 + PostgreSQL 9.2 + PHP 5.14.6 + Joomla 3.8.7 (3.8.6 also)

Additional comments

When I disable Smart Search - Content plugin all works fine. Also SQL statement is wrong.

avatar GarryMoveOut GarryMoveOut - open - 16 May 2018
avatar joomla-cms-bot joomla-cms-bot - labeled - 16 May 2018
avatar GarryMoveOut GarryMoveOut - change - 16 May 2018
The description was changed
avatar GarryMoveOut GarryMoveOut - edited - 16 May 2018
avatar GarryMoveOut GarryMoveOut - change - 16 May 2018
The description was changed
avatar GarryMoveOut GarryMoveOut - edited - 16 May 2018
avatar brianteeman
brianteeman - comment - 16 May 2018

If i recall correctly the key issue here is that it is using postgres

avatar franz-wohlkoenig franz-wohlkoenig - change - 16 May 2018
Status New Discussion
avatar csthomas
csthomas - comment - 16 May 2018

The patch is at #19964

avatar franz-wohlkoenig franz-wohlkoenig - change - 16 May 2018
Status Discussion Known Issue
Closed_Date 0000-00-00 00:00:00 2018-05-16 14:32:14
Closed_By franz-wohlkoenig
avatar joomla-cms-bot joomla-cms-bot - change - 16 May 2018
Status Known Issue Closed
Closed_Date 2018-05-16 14:32:14 2018-05-16 14:32:16
Closed_By franz-wohlkoenig joomla-cms-bot
avatar joomla-cms-bot joomla-cms-bot - close - 16 May 2018
avatar joomla-cms-bot
joomla-cms-bot - comment - 16 May 2018
avatar franz-wohlkoenig
franz-wohlkoenig - comment - 16 May 2018

closed as known issue. @csthomas thanks for searching for Pull Request.

@GarryMoveOut can you please test #19964?


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/20423.
avatar GarryMoveOut
GarryMoveOut - comment - 17 May 2018

@franz-wohlkoenig yes of course.
I tested and it works great. No errors.

Add a Comment

Login with GitHub to post a comment