Support Forum

Every time that you post a problem, PLEASE add the Joomla and the extension's versions and revisions (for example: Joomla 3.3.6, Contact Enhanced 3.3.5), PHP version and Server's Operating System. If you only manage only one site it is easier if you edit your profile and just add that information to your signature. Don't forget to add a detailed description of the problem. If possible, write down all steps to simulate the problem.

Before submitting a new post, PLEASE make sure you are running the latest version, test in different browsers (IE, FF, Chrome,..) and clear Joomla and browser's cache after every change you make.

Also, most questions are already answered in our FAQ and in iFAQ and Contact Enhanced documentation pages.

× Ideal Store Locator Plugin (iStoreLocator) works with Google Maps API which allows your website visitors to easily locate stores/contacts on the map.

Product Page

Tags from articles counted as contact tags [solved]

5 years 4 months ago #24636 by brandnew
Hi.

Today I found very strange and hard to diagnose tag filter behavior.
I'm using tag system both to contact enhanced and to articles.
For some reason, few of articles tags was displayed over iSL map, where some others (oldest) not.
After few hours investigation :( I found reason and solution.

Bad SQL query is located in:
/plugins/system/istorelocator/istorelocator.php
line 931 (in my file)

Whole condition is:
$query = "SELECT GROUP_CONCAT(ts.title)
FROM #__contentitem_tag_map AS ci
LEFT JOIN #__tags AS ts ON ts.id = ci.tag_id
WHERE ci.content_item_id = ".$contact->id
." AND published = 1 "

But this query works bad, because it compare content_item_id to $contact->id, whereas content_item_id field is not unique and may be repeated for many types of content, b.e. articles.

Fixed query is:
$query = "SELECT GROUP_CONCAT(ts.title)
FROM #__contentitem_tag_map AS ci
LEFT JOIN #__tags AS ts ON ts.id = ci.tag_id
WHERE ci.content_item_id = ".$contact->id
." AND type_alias LIKE 'com_contactenhanced.contact' AND published = 1 "

This query select only tags assigned to Contact Enhanced rows.


Best regards,
Brand New

Please Log in or Create an account to join the conversation.

5 years 4 months ago #24637 by support
Greetings,

Thanks for letting us know.

We've fixed in the code.

Thanks again.

Please Log in or Create an account to join the conversation.

Powered by Kunena Forum

Copyright © 2018 IdealExtensions.com. All Rights Reserved.

This site is not affiliated with or endorsed by the Joomla!™ Project. It is not supported or warranted by the Joomla!™ Project or Open Source Matters™. The Joomla!™ logo is used under a limited license granted by Open Source Matters™, the trademark holder in the United States and other countries.
We may collect your IP address and your browser's User Agent string while using our site for security reasons and deriving aggregate information (analytics). This information is retained for a minimum of 1 and a maximum of 24 months.
Feedback