Joomla Extensions Club 20,483 posts

[balithisweek Friend balithisweekJoin date: February 2014Posts: 4Downloads:0Uploads:0]

#194991

I just installed JA K2 Search, it working good and showing the correct search result by the keyword, category etc
BUT the problem is my item is showing 3 times in the search result,

example : i have a k2 item “Sample” i search with keyword “Sam” it showing on the result but with 2 duplicate so there are 3 same item in the result

[Thanh Nguyen Viet Friend Thanh Nguyen VietJoin date: September 2014Posts: 1461Downloads:0Uploads:44 Thanked: 258 times in 217 posts]

#523597

@balithisweek

To resolve this issue, please open the file
components/com_jak2filter/models/itemlist.php

Replace the following code snippet

$query = "SELECT i.*, CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams";

With:

$query = "SELECT DISTINCT i.*, CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams";

[balithisweek Friend balithisweekJoin date: February 2014Posts: 4Downloads:0Uploads:0]

#523668

Hi, Thanks for your answer,

i already have that script in the website but it still showing the same problem

[balithisweek Friend balithisweekJoin date: February 2014Posts: 4Downloads:0Uploads:0]

#523670

<em>@Dead Code 412418 wrote:</em><blockquote>@balithisweek

To resolve this issue, please open the file
components/com_jak2filter/models/itemlist.php

Replace the following code snippet

$query = "SELECT i.*, CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams";

With:

$query = "SELECT DISTINCT i.*, CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams";
</blockquote>
Hi, Thanks for your answer,

i already have that script in the website but it still showing the same problem

[Thanh Nguyen Viet Friend Thanh Nguyen VietJoin date: September 2014Posts: 1461Downloads:0Uploads:44 Thanked: 258 times in 217 posts]

#523677

<em>@balithisweek 412525 wrote:</em><blockquote>Hi, Thanks for your answer,

i already have that script in the website but it still showing the same problem</blockquote>

My apology, you need to update a little bit more to resolve this issue.

Open the file that mentioned above, find the following code line:

[PHP]$query = “SELECT COUNT(*) FROM #__k2_items as i RIGHT JOIN #__k2_categories c ON c.id = i.catid”;[/PHP]

and replace it with:

[PHP]$query = “SELECT COUNT(DISTINCT i.id) FROM #__k2_items as i RIGHT JOIN #__k2_categories c ON c.id = i.catid”;[/PHP]

If it does not help, please PM me FTP credentials of your site, I’ll help you out.

[quangtuan0302 Friend quangtuan0302Join date: May 2014Posts: 2Downloads:0Uploads:0]

#535022

<em>@Dead Code 412532 wrote:</em><blockquote>My apology, you need to update a little bit more to resolve this issue.

Open the file that mentioned above, find the following code line:

[PHP]$query = “SELECT COUNT(*) FROM #__k2_items as i RIGHT JOIN #__k2_categories c ON c.id = i.catid”;[/PHP]

and replace it with:

[PHP]$query = “SELECT COUNT(DISTINCT i.id) FROM #__k2_items as i RIGHT JOIN #__k2_categories c ON c.id = i.catid”;[/PHP]

If it does not help, please PM me FTP credentials of your site, I’ll help you out.</blockquote>

i use source 05/14/2014 but not fix..please help me…
http://www.joomlart.com/forums/topic/duplicate-search-result-ja-k2-search/

[Author]

Posts