Forum Replies Created
-
Posts
-
Hey Ernest,
I went through what you did, and it makes sense!
Like you recommended, I made a second search for the mega menu, so that when you hit enter or click, it will take the searcher to the search page. I copied the menu you helped me with exactly, except I changed the results on hitting enter or clicking the magnifying glass to go to the search page.
When I put it in the menu, a broken page loaded with this text:
string(2298) ” SELECT wp_v5z5qh_posts.post_title as title, wp_v5z5qh_posts.ID as id, wp_v5z5qh_posts.post_date as date, wp_v5z5qh_posts.post_content as content, wp_v5z5qh_posts.post_excerpt as excerpt, wp_v5z5qh_users.user_nicename as author, (0) as meta_matches, CONCAT(‘–‘, GROUP_CONCAT(DISTINCT wp_v5z5qh_terms.term_id SEPARATOR ‘—-‘), ‘–‘) as ttid, wp_v5z5qh_posts.post_type as post_type, CASE WHEN wp_v5z5qh_ajaxsearchpro_priorities.priority IS NULL THEN 100 ELSE wp_v5z5qh_ajaxsearchpro_priorities.priority END AS priority, ((case when (lower(wp_v5z5qh_posts.post_title) REGEXP ‘happy’) then 3 else 0 end) + (case when (lower(wp_v5z5qh_posts.post_title) LIKE ‘%happy%’) then 10 else 0 end) + (case when (lower(wp_v5z5qh_posts.post_title) REGEXP ‘happy’) then 10 else 0 end)) as relevance FROM wp_v5z5qh_posts LEFT JOIN wp_v5z5qh_postmeta ON wp_v5z5qh_postmeta.post_id = wp_v5z5qh_posts.ID LEFT JOIN wp_v5z5qh_ajaxsearchpro_priorities ON (wp_v5z5qh_ajaxsearchpro_priorities.post_id = wp_v5z5qh_posts.ID AND wp_v5z5qh_ajaxsearchpro_priorities.blog_id = 1) LEFT JOIN wp_v5z5qh_users ON wp_v5z5qh_users.ID = wp_v5z5qh_posts.post_author LEFT JOIN wp_v5z5qh_term_relationships ON wp_v5z5qh_posts.ID = wp_v5z5qh_term_relationships.object_id LEFT JOIN wp_v5z5qh_term_taxonomy ON wp_v5z5qh_term_taxonomy.term_taxonomy_id = wp_v5z5qh_term_relationships.term_taxonomy_id LEFT JOIN wp_v5z5qh_terms ON wp_v5z5qh_term_taxonomy.term_id = wp_v5z5qh_terms.term_id WHERE (wp_v5z5qh_posts.post_type REGEXP ‘[[:<:]]post[[:>:]]’) AND (lower(wp_v5z5qh_posts.post_status) REGEXP ‘publish’) AND (( lower(wp_v5z5qh_posts.post_title) LIKE ‘%happy%’ )) AND (wp_v5z5qh_posts.ID NOT IN (-55)) GROUP BY wp_v5z5qh_posts.ID HAVING (ttid REGEXP ‘–3–‘) ORDER BY priority DESC, relevance DESC, wp_v5z5qh_posts.post_date DESC LIMIT 10″ string(2298) ” SELECT wp_v5z5qh_posts.post_title as title, wp_v5z5qh_posts.ID as id, wp_v5z5qh_posts.post_date as date, wp_v5z5qh_posts.post_content as content, wp_v5z5qh_posts.post_excerpt as excerpt, wp_v5z5qh_users.user_nicename as author, (0) as meta_matches, CONCAT(‘–‘, GROUP_CONCAT(DISTINCT wp_v5z5qh_terms.term_id SEPARATOR ‘—-‘), ‘–‘) as ttid, wp_v5z5qh_posts.post_type as post_type, CASE WHEN wp_v5z5qh_ajaxsearchpro_priorities.priority IS NULL THEN 100 ELSE wp_v5z5qh_ajaxsearchpro_priorities.priority END AS priority, ((case when (lower(wp_v5z5qh_posts.post_title) REGEXP ‘happy’) then 3 else 0 end) + (case when (lower(wp_v5z5qh_posts.post_title) LIKE ‘%happy%’) then 10 else 0 end) + (case when (lower(wp_v5z5qh_posts.post_title) REGEXP ‘happy’) then 10 else 0 end)) as relevance FROM wp_v5z5qh_posts LEFT JOIN wp_v5z5qh_postmeta ON wp_v5z5qh_postmeta.post_id = wp_v5z5qh_posts.ID LEFT JOIN wp_v5z5qh_ajaxsearchpro_priorities ON (wp_v5z5qh_ajaxsearchpro_priorities.post_id = wp_v5z5qh_posts.ID AND wp_v5z5qh_ajaxsearchpro_priorities.blog_id = 1) LEFT JOIN wp_v5z5qh_users ON wp_v5z5qh_users.ID = wp_v5z5qh_posts.post_author LEFT JOIN wp_v5z5qh_term_relationships ON wp_v5z5qh_posts.ID = wp_v5z5qh_term_relationships.object_id LEFT JOIN wp_v5z5qh_term_taxonomy ON wp_v5z5qh_term_taxonomy.term_taxonomy_id = wp_v5z5qh_term_relationships.term_taxonomy_id LEFT JOIN wp_v5z5qh_terms ON wp_v5z5qh_term_taxonomy.term_id = wp_v5z5qh_terms.term_id WHERE (wp_v5z5qh_posts.post_type REGEXP ‘[[:<:]]post[[:>:]]’) AND (lower(wp_v5z5qh_posts.post_status) REGEXP ‘publish’) AND (( lower(wp_v5z5qh_posts.post_title) LIKE ‘%happy%’ )) AND (wp_v5z5qh_posts.ID NOT IN (-55)) GROUP BY wp_v5z5qh_posts.ID HAVING (ttid REGEXP ‘–3–‘) ORDER BY priority DESC, relevance DESC, wp_v5z5qh_posts.post_date DESC LIMIT 10″
I switched it back. You can see it if you go to widgets, and for the baby sign search menu change the search to Baby Sign Language 2. Then in the menu, the search is scrunched, has gray text, and is missing the header.
I am so sorry that I am really bad at this. I have no idea what I am doing wrong. It’s embarrassing because I read the documentation three times!
Yayyyyyy!!! Thank you so much, Ernest! I don’t have to change anything so that it is just the baby sign category because I think it had more categories before?
Thank you again for being so patient. I am so happy this is done.
Bawhahahaha. Thank you for being so patient with me. I wondered if that was just for the woo commerce because it had a little thing about woo commerce above that.
So the search logic here is that if I include a category with 700 posts, posts will be eliminated if they appear in any excluded categories?
Is there a way for it to just include anything that appears in one certain category? I would like it to just pull up anything that appears in that one Baby Sign Language Category.
Does it slow it down if it is searching through 1 category vs 55 categories? My search goes really slow. I read something on your site that it has to do with the server speed. Is that correct or could searching through lots of categories affect it?
2. So, so great. I will make a different one for the menu that goes to the search page instead.
4. I understand that everything is included by default. This is what I did, and it doesn’t make sense that some signs will search and some will not:
INCLUDE
Baby Sign LanguageEXCLUDE
EVERY other categoryBanana’s Categories are: B, Baby Sign Language, Food, TEST
Bath: B, Baby Sign Language, RoutinesBanana should show up because it is in Baby Sign Language even if the other categories it is in is excluded. Bath shows up even if B and Routines are excluded. I don’t want to have to pay someone to search all 700 terms to make sure the plugin is actually pulling up the results for the baby sign category that the post is already included. It doesn’t make sense that some signs are showing up and some are not. Every post in Baby Sign Language should appear.
If I include every category a baby sign appears in, it takes a really long time to search through all of them. There are over 40 categories. I just want to use the 1 category that they are all in.
Do you see the problem? Is it possible for this plugin to search through one category and pull of the results for that one category?
1. Great!
2. Yes, I have. And it didn’t work. I read the documentation through several times. Every time I used it and added the short code, nothing appeared. I even used the widget for the sidebar. I put it back to hovering, so results would show in other instances. I just want the block view to work.
4. Banana is ALSO in Baby Sign Language, just like all the others. I want every sign that is in Baby Sign Language to appear even if it is in another category as well. For every other sign, they have at least 3 other categories, and they are not included in the search instance because when they were it was too slow. This makes me worry that there are problems with other posts that are in Baby Sing Language but might not show up. How can it work so that every post in Baby Sign Language appears? It doesn’t make sense that I would have to include TEST. I didn’t include B and bath still appears. Do you get what I’m saying?
Thank you so much for going through all this. I am understanding all of this a lot better.
1. This makes sense. However, when I use the “view more” button, it includes all the posts that aren’t in the Baby Sign Category.
2. I would just like to use block results for everything, but the block results don’t show up when I use them. Even if I add the result short code under the search short code. It is blank.
3. THANK YOU!!!
4. All of my signs are in the Baby Sign Category. They are also in other categories, like the first letter of the word “B” or “Food.” It was too slow when I had the extra categories, so I just did the Baby Sign Category. Banana is in test but it is also in Baby Sign Language. Why isn’t it showing up? I need to delete the Test category anyway, because I am done testing what it was a part of for an essential grid.
5. What do you mean by fix the FTP access? I’d be happy to do it.
I REALLY appreciate your help. Search is so essential for people finding signs on this website, so this is really big for us.
Thank you!
