Hi, this seems like it is related to only full group by database rule, try to open this file:
administrator\components\com_phocacart\libraries\phocacart\related\related.php
And try to edit it.
LINE cca. 82
FROM
Code: Select all
$query = ' SELECT a.id as id, a.title as title, a.image as image, a.alias as alias,'
.' c.id as catid, c.alias as catalias, c.title as cattitle';
TO
Code: Select all
//$query = ' SELECT a.id as id, a.title as title, a.image as image, a.alias as alias,'
// .' c.id as catid, c.alias as catalias, c.title as cattitle';
$query = ' SELECT DISTINCT a.id as id, a.title as title, a.image as image, a.alias as alias,'
.' SUBSTRING_INDEX(GROUP_CONCAT(c.id ORDER BY c.parent_id), \',\', 1) as catid,'
.' SUBSTRING_INDEX(GROUP_CONCAT(c.title ORDER BY c.parent_id), \',\', 1) as cattitle,'
.' SUBSTRING_INDEX(GROUP_CONCAT(c.alias ORDER BY c.parent_id), \',\', 1) as catalias';
LINE cca. 115
FROM
Code: Select all
$query .= ' GROUP BY a.id, a.title, a.image, a.alias, c.id, c.alias, c.title';
TO
Code: Select all
//$query .= ' GROUP BY a.id, a.title, a.image, a.alias, c.id, c.alias, c.title';
$query .= ' GROUP BY a.id, a.title, a.image, a.alias';
Testing now, it should work. Please let me know if this is working for you.
Thank you, Jan
