Keyword

Bug? in K2 search Plugin

  • Andreas Heckmann
  • Andreas Heckmann's Avatar Topic Author
  • Offline
  • New Member
More
9 years 11 months ago #143865 by Andreas Heckmann
Bug? in K2 search Plugin was created by Andreas Heckmann
I tried to activate the "search tags" option. When i did a search on my frontpage a weird sql error appears.

I changed in /plugins/search/k2/k2.php
line 91
to
$quoted = $db->Quote('%'.$escaped.'%', false);


and from line 104 to $querry
if ($phrase == 'exact')
            {
                $text = JString::trim($text, '"');
                $escaped = K2_JVERSION == '15' ? $db->getEscaped($text, true) : $db->escape($text, true);
				$quoted = $db->Quote($escaped);
				$where = " ( LOWER(i.title) = ".$quoted." OR LOWER(i.introtext) = ".$quoted." OR LOWER(i.`fulltext`) = ".$quoted." OR LOWER(i.extra_fields_search) = ".$quoted." OR LOWER(i.image_caption) = ".$quoted." OR LOWER(i.image_credits) = ".$quoted." OR LOWER(i.video_caption) = ".$quoted." OR LOWER(i.video_credits) = ".$quoted." OR LOWER(i.metadesc) = ".$quoted." OR LOWER(i.metakey) = ".$quoted;
            }
            else
            {
                JArrayHelper::toInteger($itemIDs);
                $escaped = K2_JVERSION == '15' ? $db->getEscaped($text, true) : $db->escape($text, true);
				$quoted = $db->Quote('%'.$escaped.'%', false);
				$where = " ( LOWER(i.title) LIKE ".$quoted." OR LOWER(i.introtext) LIKE ".$quoted." OR LOWER(i.`fulltext`) LIKE ".$quoted." OR LOWER(i.extra_fields_search) LIKE ".$quoted." OR LOWER(i.image_caption) LIKE ".$quoted." OR LOWER(i.image_credits) LIKE ".$quoted." OR LOWER(i.video_caption) LIKE ".$quoted." OR LOWER(i.video_credits) LIKE ".$quoted." OR LOWER(i.metadesc) LIKE ".$quoted." OR LOWER(i.metakey) LIKE ".$quoted;
            }

            if ($pluginParams->get('search_tags') && count($itemIDs))
            {
                JArrayHelper::toInteger($itemIDs);
                $where .= " OR i.id IN(".implode(',', $itemIDs).")";
            }
            $where .= " )";

Mainly the %where lines are altered

Now it works for me!

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

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
9 years 11 months ago #143871 by Krikor Boghossian
Replied by Krikor Boghossian on topic Bug? in K2 search Plugin
Which version of K2 and Joomla! are you using?

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

  • Andreas Heckmann
  • Andreas Heckmann's Avatar Topic Author
  • Offline
  • New Member
More
9 years 11 months ago #143881 by Andreas Heckmann
Replied by Andreas Heckmann on topic Bug? in K2 search Plugin
K2 : 2.6.9

Joomla: 3.4.1

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

More
9 years 11 months ago #143904 by Lefteris
Replied by Lefteris on topic Bug? in K2 search Plugin
@Andreas Heckmann

Hi,

This issue has been fixed already for the next release. Can you try with this file ( raw.githubusercontent.com/joomlaworks/k2/master/plugins/search/k2.php ) and let us know ?

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


Powered by Kunena Forum