Related Products bug?

[Reijo83]

Every time when I add Related Products to an item, then this Related Products are added two times in product view.
Example image

Update

After Related Products added and when we go back products list, then there we see twice product what I add to related products.
Example image

[Jan]

Hi, which version do you use? Testing now version 3.0.3 without any such problem:



???

Jan

[Reijo83]

My ver 3.0.3. Ok i try clean install (jooomla and Phoca Cart). Maybe update messed up something.

[Reijo83]

Hi, Jan
So these two sites were in my local machine. But now moved to the server and problems still exist (Clean install).
My test site: https://omakoduleht.ee/test/tuisk/1-vobler/1-hall-ujuv

[Jan]

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

[Reijo83]

Hi Jan
Tested and its working.

[Reijo83]

another bug. When you want to delete related Products you can't. After clearing fields and save it, then related products are still there.
See video: https://youtu.be/YqbUg_Lka1A

[Jan]

Hi, thank you very much for the info, this was caused but not removing the changes for the debugging, will be fixed in next version, for now just make a quick fix, open:
administrator\components\com_phocacart\models\fields\phocaselectitem.php

on line cca 138
uncomment: // $s[] = ' jQuery(element).val(\'\');';

so
FROM:

Code: Select all

//$s[] = '    jQuery(element).val(\'\');';

TO:

Code: Select all

$s[] = '    jQuery(element).val(\'\');';

Thank you, Jan