- Posts: 4
COMMUNITY FORUM
K2 tools Search Module
- Gamal Andrews
-
Topic Author
- Offline
- New Member
Please Log in or Create an account to join the conversation.
- william white
-
- Offline
- Platinum Member
- Posts: 3722
Do you have it set to search all categories or specific ones?
Is this on the site in your profile? I see its at the bottom of the page under the content area.
Try allowing it to search all categories first
Please Log in or Create an account to join the conversation.
- Gamal Andrews
-
Topic Author
- Offline
- New Member
- Posts: 4
William White said:How are you setting up the search module? Do you have it set to search all categories or specific ones?
Is this on the site in your profile? I see its at the bottom of the page under the content area.
Try allowing it to search all categories first
Please Log in or Create an account to join the conversation.
- william white
-
- Offline
- Platinum Member
- Posts: 3722
Use the Joomla Module Manager
Select New - K2 tools
Make sure that all is checked on the left and search box is selected in the picklist on the right
Select the position you want it in
Leave everything else default and publish
see attached png for my settings that work
Please Log in or Create an account to join the conversation.
- Gamal Andrews
-
Topic Author
- Offline
- New Member
- Posts: 4
William White said:deactivate the module you have now Use the Joomla Module Manager
Select New - K2 tools
Make sure that all is checked on the left and search box is selected in the picklist on the right
Select the position you want it in
Leave everything else default and publish
see attached png for my settings that work
Please Log in or Create an account to join the conversation.
- william white
-
- Offline
- Platinum Member
- Posts: 3722
Its eaisest to use and get to work. There is much discussion in this forum about sig that you can search for.
i sent you pm
Please Log in or Create an account to join the conversation.
- Case Noland
-
- Offline
- Junior Member
- Posts: 25
I have it configured properly but am not seeing results that I would expect from even a simple search.
For example, check out:
www.design3.net/by-software/unity-3d/unity-fundamentals?layout=category
You can see in the list plenty of names and descriptions with the keyword "Unity" as well as it listed in the tags and "software used" which is one of my extra fields.
However a simple search for 'unity' in the search box brings up zero results.
A search for 'intro' brings up one item from a different category.
My working assumption is that the search is currently only querying the item name field. How can I broaden this to include search results from the item description, tags and extra fields?
Thanks!
Please Log in or Create an account to join the conversation.
- william white
-
- Offline
- Platinum Member
- Posts: 3722
it works then
im not sure whats up in the code but i think it was fixed in 2.3 beta which i am using
let me test it and i will get back
pm a friend request to me
Please Log in or Create an account to join the conversation.
- william white
-
- Offline
- Platinum Member
- Posts: 3722
2.3 search seems flakey also
I can search for values in xtra fields and it will find (this is service) (is service) and (sdgf) all without quotes
but
it will not find (sdgf) wether quoted or not
It will find (buffy) and (Honea Path) which is in fulltext
but
It will not find ("E.T.") which are quoted in the fulltext field
Regular expressions are difficult to say the least. I tried passing escapes with various combinations of the above with no luck. Again REGULAR EXPRESSIONS ARE DIFFICULT
Please Log in or Create an account to join the conversation.
- Gamal Andrews
-
Topic Author
- Offline
- New Member
- Posts: 4
William White said:WTF 2.3 search seems flakey also
I can search for values in xtra fields and it will find (this is service) (is service) and (sdgf) all without quotes
but
it will not find (sdgf) wether quoted or not
It will find (buffy) and (Honea Path) which is in fulltext
but
It will not find ("E.T.") which are quoted in the fulltext field
Regular expressions are difficult to say the least. I tried passing escapes with various combinations of the above with no luck. Again REGULAR EXPRESSIONS ARE DIFFICULT
Please Log in or Create an account to join the conversation.
- Case Noland
-
- Offline
- Junior Member
- Posts: 25
That doesn't seem to make sense in this scenario however where "unity" is found but not - unity.
Search is critical to my site, I appreciate any help or just input to point me in the right direction.
I've also started a specific thread here:
community.getk2.org/forum/topics/k2-search-only-pulling-results
William White said:Try putting unity in quotes it works then
im not sure whats up in the code but i think it was fixed in 2.3 beta which i am using
let me test it and i will get back
pm a friend request to me
Please Log in or Create an account to join the conversation.
- Case Noland
-
- Offline
- Junior Member
- Posts: 25
#
SELECT i.*, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM jos_k2_items AS i
LEFT JOIN jos_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.access <= 0
AND i.trash = 0
AND c.published = 1
AND c.access <= 0
AND c.trash = 0
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2010-05-25 00:29:37' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2010-05-25 00:29:37' )
AND MATCH(i.title, i.introtext, i.`fulltext`,i.image_caption,i.image_credits,i.video_caption,i.video_credits,i.extra_fields_search,i.metadesc,i.metakey) AGAINST ('terrain')
ORDER BY i.id DESC
LIMIT 0, 10
Gamal Andrews said:You are correct case. It seems only to be searching the items name. How do you broaden it to everything? Thanks again William, you got me this far.
Please Log in or Create an account to join the conversation.
- william white
-
- Offline
- Platinum Member
- Posts: 3722
I have noticed that the extra fields are stored in the item table like this
[Doe,Jane, 18, 123anystreet]
I will check the field names, turn debug on and see what my 2.3 is doing
Please Log in or Create an account to join the conversation.
- mitay
-
- Offline
- New Member
- Posts: 2
Sorry for my English.
Please Log in or Create an account to join the conversation.